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

欢迎进入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]