基于cancel的不完全恢复 - 数据库编程

nlrzy8w_.arc' no longer
needed for this recovery

Specify log: {=suggested | filename | AUTO | CANCEL}

--应用sequence #9为9的这个归档日志文件，直接按回车键

ORA-00279: change 884101 generated at 03/20/2013 15:23:53 needed for thread 1
ORA-00289: suggestion :
/u01/app/FRA/ORA11GR2/archivelog/2013_03_20/o1_mf_1_10_8nls0os6_.arc
ORA-00280: change 884101 for thread 1 is in sequence #10
ORA-00278: log file
'/u01/app/FRA/ORA11GR2/archivelog/2013_03_20/o1_mf_1_9_8nls091w_.arc' no longer
needed for this recovery

Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
--手动输入cancel结束恢复，不管后面有没有可恢复文件，都会结束；
Media recovery cancelled.
SYS@ORA11GR2>
SYS@ORA11GR2>alter database open resetlogs;

Database altered.

SYS@ORA11GR2>

7）检查
SYS@ORA11GR2>select table_name,tablespace_name from dba_tables where owner='SCOTT' AND table_name LIKE 'T_';

TABLE_NAME TABLESPACE_NAME
------------------------- ------------------------------
T2 USERS
T1 USERS

SYS@ORA11GR2>
注应用了两个归档日志，第三个归档日志cancel了，从结果中也可以看到，恢复以后的数据库中，只
存在T1,T2两张表，它们俩的重做日志就在前两个归档中，T3表的所有重做条目都在第三个归档中，
由于采取了cancel，所以，T3表并未恢复

基于cancel的不完全恢复(三)