Oracle使用备份控制文件恢复数据库(二)

2014-11-24 17:54:24 · 作者: · 浏览: 4
.dbf


7 ONLINE /u01/oradata/pan/ts_readonly01.dbf


8 ONLINE /u01/oradata/pan/app2_01.dbf


9 RECOVER /u01/oracle/dbs/UNNAMED00009



9 rows selected.


现在明白了,控制文件里的这个文件名为“/u01/oracle/dbs/UNNAMED00009”,我把它先重命名成正确的。


sys@PAN>alter databaserename file'/u01/oracle/dbs/UNNAMED00009'


2 to'/u01/oradata/pan/ts_test02_01.dbf';


现在再一次恢复,使用1号redo日志。


recover database using backup controlfile;


ORA-00279: change443687 generated at06/23/201310:27:38 neededfor thread 1


ORA-00289: suggestion: /u01/flash_recovery_area/PAN/archivelog/2013_06_23/o1_mf_1_4_%u_.arc


ORA-00280: change443687 for thread1 is in sequence #4


Specify log:{<RET>=suggested| filename | AUTO| CANCEL}


/u01/oradata/pan/redo01.log


Log applied.


Media recovery complete.


果然,恢复成功!


步骤11


alter databaseopen resetlogs;


步骤12 冷备