最近在做System Copy,我将PRD[源]备份于带库中的datafile,control file复制到QAS[目标]系统,
并从PRD的disk上复制了10个归档日志文件:
-rw-r----- 1 oraqas dba 202591744 Nov 21 08:40 PRDarch1_47624_655488034.dbf
-rw-r----- 1 oraqas dba 202594304 Nov 21 08:41 PRDarch1_47625_655488034.dbf
-rw-r----- 1 oraqas dba 38073856 Nov 21 08:41 PRDarch1_47626_655488034.dbf
…中间省略4个…
-rw-r----- 1 oraqas dba 203079168 Nov 21 08:43 PRDarch1_47631_655488034.dbf
-rw-r----- 1 oraqas dba 204076032 Nov 21 08:44 PRDarch1_47632_655488034.dbf
-rw-r----- 1 oraqas dba 202595328 Nov 21 08:44 PRDarch1_47633_655488034.dbf
我成功的通过:brrestore -b bejwoumf.anr -m full -d rman_util -c force -e 2
将PRD中的datafile恢复到了QAS,然后执行:
SQL>RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
“前滚”归档日志,成功从47624应用到了47633,
然后执