如何恢复一个只有完好数据文件的数据库？

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 5、开始重建控制文件 1）在类似的数据库(比如数据库名称”rman”)上执行： alter database backup controlfile to trace; 然后在D:oracleadminrmanudump下找到最新的trace文件，以文本方式打开，找到

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

　　5、开始重建控制文件

　　1）在类似的数据库(比如数据库名称”rman”)上执行：
　　alter database backup controlfile to trace;
　　然后在D:oracleadminrmanudump下找到最新的trace文件，以文本方式打开，找到类似下面的一段话:

<p><span>STARTUP NOMOUNT</SPAN><span>CREATE</SPAN><span> CONTROLFILE REUSE </SPAN><span>DATABASE</SPAN><span> "rman" NORESETLOGS ARCHIVELOG</SPAN><span>--</SPAN><span> SET STANDBY TO MA<i style="color:transparent">本文来源gaodai$ma#com搞$$代**码)网8</i>XIMIZE PERFORMANCE</SPAN><span></SPAN><span>MAXLOGFILES </SPAN><span>50</SPAN><span>MAXLOGMEMBERS </SPAN><span>5</SPAN><span>MAXDATAFILES </SPAN><span>100</SPAN><span>MAXINSTANCES </SPAN><span>1</SPAN><span>MAXLOGHISTORY </SPAN><span>226</SPAN><span>LOGFILE</SPAN><span>GROUP</SPAN><span> </SPAN><span>1</SPAN><span> </SPAN><span>'</SPAN><span>D:ORACLEORADATarmANREDO01.LOG</SPAN><span>'</SPAN><span> SIZE 100M,</SPAN><span>GROUP</SPAN><span> </SPAN><span>2</SPAN><span> </SPAN><span>'</SPAN><span>D:ORACLEORADATarmANREDO02.LOG</SPAN><span>'</SPAN><span> SIZE 100M,</SPAN><span>GROUP</SPAN><span> </SPAN><span>3</SPAN><span> </SPAN><span>'</SPAN><span>D:ORACLEORADATarmANREDO03.LOG</SPAN><span>'</SPAN><span> SIZE 100M</SPAN><span>--</SPAN><span> STANDBY LOGFILE</SPAN><span></SPAN><span>DATAFILE</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANSYSTEM01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANUNDOTBS01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANCWMLITE01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANDRSYS01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANEXAMPLE01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANINDX01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANODM01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANTOOLS01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANUSERS01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANXDB01.DBF</SPAN><span>'</SPAN><span>,</SPAN><span>'</SPAN><span>D:ORACLEORADATarmANTEST.ORA</SPAN><span>'</SPAN><span></SPAN><span>CHARACTER</SPAN><span> </SPAN><span>SET</SPAN><span> WE8MSWIN1252</SPAN></p>

　　2）将上面这段话修改为如下：

喜欢 (0)赏

[搞代码]

分享 (0)