欢迎进入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 twffan="done"> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ><span>STARTUP NOMOUNT <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>CREATE</span><span> CONTROLFILE REUSE </span><span>DATABASE</span><span> "rman" NORESETLOGS ARCHIVELOG <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>--</span><span> SET STANDBY TO MAXIMIZE PERFORMANCE</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>MAXLOGFILES </span><span>50</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXLOGMEMBERS </span><span>5</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXDATAFILES </span><span>100</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXINSTANCES </span><span>1</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXLOGHISTORY </span><span>226</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >LOGFILE <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>GROUP</span><span> </span><span>1</span><span> </span><span>'</span><span>D:ORACLEORADATarmANREDO01.LOG</span><span>'</span><span> SIZE 100M, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>GROUP</span><span> </span><span>2</span><span> </span><span>'</span><span>D:ORACLEORADATarmANREDO02.LOG</span><span>'</span><span> SIZE 100M, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>GROUP</span><span> </span><span>3</span><span> </span><span>'</span><span>D:ORACLEORADATarmANREDO03.LOG</span><span>'</span><span> SIZE 100M <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>--</span><span> STANDBY LOGFILE</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>DATAFILE <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANSYSTEM01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANUNDOTBS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANCWMLITE01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANDRSYS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANEXAMPLE01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANINDX01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANODM01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANTOOLS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANUSERS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANXDB01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATarmANTEST.ORA</span><span>'</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>CHARACTER</span><span> </span><span>SET</span><span> WE8MSWIN1252</span></p>
2)将上面这段话修改为如下:
<p twffan="done"> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ><span>STARTUP NOMOUNT <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>CREATE</span><span> CONTROLFILE </span><span>set</span><span> </span><span>DATABASE</span><span> "tti" RESETLOGS </span><span>--</span><span>注意这里要"set"</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >--</span><span> SET STANDBY TO MAXIMIZE PERFORMANCE</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>MAXLOGFILES </span><span>50</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXLOGMEMBERS </span><span>5</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXDATAFILES </span><span>100</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXINSTANCES </span><span>1</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >MAXLOGHISTORY </span><span>226</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" >LOGFILE <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>GROUP</span><span> </span><span>1</span><span> </span><span>'</span><span>D:ORACLEORADATAttiREDO01.LOG</span><span>'</span><span> SIZE 100M, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>GROUP</span><span> </span><span>2</span><span> </span><span>'</span><span>D:ORACLEORADATAttiREDO02.LOG</span><span>'</span><span> SIZE 100M, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>GROUP</span><span> </span><span>3</span><span> </span><span>'</span><span>D:ORACLEORADATAttiREDO03.LOG</span><span>'</span><span> SIZE 100M <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>--</span><span> STANDBY LOGFILE</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>DATAFILE <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiSYSTEM01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiUNDOTBS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiCWMLITE01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiDRSYS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiEXAMPLE01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiINDX01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiODM01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiTOOLS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiUSERS01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiXDB01.DBF</span><span>'</span><span>, <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>'</span><span>D:ORACLEORADATAttiTEST.ORA</span><span>'</span><span> <img src="/inc/test.jsp?url=http%3A%2F%2Foracle.chinaitlab.com%2FUploadFiles_7269%2F200611%2F20061124104939678.gif&refer=http%3A%2F%2Foracle.chinaitlab.com%2Fbackup%2F531249_2.html" alt="如何恢复一个只有完好数据文件的数据库?" ></span><span>CHARACTER</span><span> </span><span>SET</span><span> WE8MSWIN1252</span></p>
[1] [2] [3]