SQL>recoverdatabaseusing backup controlfile until cancel; ORA-00279:change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1 ORA-00289: suggestion : L:/ORACLE/PRODUCT/10.2.0/ORADATA/ORC2/ARCHIVEARC00007_0641832494.001 ORA-00280:change 4697108 for thread 1 isinsequence #7
Specify log:{<RET>=suggested | filename | AUTO |CANCEL} cancel ORA-01547: warning:RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152:file 1 was not restored from a sufficiently old backup ORA-01110:datafile 1:'L:/ORACLE/PRODUCT/10.2.0/ORADATA/ORC2/SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL>alterdatabase open resetlogs; alterdatabase open resetlogs * ERROR at line 1: ORA-01152:file 1 was not restored from a sufficiently old backup ORA-01110:datafile 1:'L:/ORACLE/PRODUCT/10.2.0/ORADATA/ORC2/SYSTEM01.DBF'
SQL>alter system set"_allow_resetlogs_corruption"=truescope=spfile;
System altered.
SQL>recoverdatabaseusing backup controlfile until cancel; ORA-00279:change 4697108 generated at 12/24/2007 11:48:57 needed for thread 1 ORA-00289: suggestion : L:/ORACLE/PRODUCT/10.2.0/ORADATA/ORC2/ARCHIVEARC00007_0641832494.001 ORA-00280:change 4697108 for thread 1 isinsequence #7
Specify log:{<RET>=suggested | filename | AUTO |CANCEL} cancel ORA-01547: warning:RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152:file 1 was not restored from a sufficiently old backup ORA-01110:datafile 1:'L:/ORACLE/PRODUCT/10.2.0/ORADATA/ORC2/SYSTEM01.DBF'
ORA-01112: media recovery not started
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01092: ORACLE instance terminated. Disconnection forced
具体步骤如下: startup force; alter system set "_allow_resetlogs_corruption"=true scope=spfile; recover database using backup controlfile until cancel; alter databse open resetlogs;