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 冷备