CREATE">

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

WBOY
リリース: 2016-06-07 15:23:57
オリジナル
1119 人が閲覧しました

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

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

ソース:php.cn
このウェブサイトの声明
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。
人気のチュートリアル
詳細>
最新のダウンロード
詳細>
ウェブエフェクト
公式サイト
サイト素材
フロントエンドテンプレート