Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'O:\ORACLE\ORADATA\LEEGLE\SYSTEM01.DBF'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'O:\ORACLE\ORADATA\LEEGLE\SYSTEM01.DBF'
我是用resetlogs之后的控制文件恢复的。按理,recover database应该能够进行的。可还是下不去。我重建controlfile,用recover database using backup controlfile until cancel;还是不能恢复,提示错误一样。
alert.log中的记录
alter database open resetlogs
RESETLOGS after complete recovery through change 66512
SQL> startup
ORACLE instance started.
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'O:\ORACLE\ORADATA\LEEGLE\SYSTEM01.DBF'
SQL> recover database using backup controlfile until change 66512;
ORA-00279: change 66180 generated at 05/06/2004 10:23:13 needed for thread 1
ORA-00289: suggestion : O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_65.1
ORA-00280: change 66180 for thread 1 is in sequence #65
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 66383 generated at 05/08/2004 16:09:53 needed for thread 1
ORA-00289: suggestion : O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_66.1
ORA-00280: change 66383 for thread 1 is in sequence #66
ORA-00278: log file 'O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_65.1' no longer
needed for this recovery
ORA-00279: change 66389 generated at 05/08/2004 16:10:09 needed for thread 1
ORA-00289: suggestion : O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_67.1
ORA-00280: change 66389 for thread 1 is in sequence #67
ORA-00278: log file 'O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_66.1' no longer
needed for this recovery
ORA-00279: change 66433 generated at 05/08/2004 16:11:49 needed for thread 1
ORA-00289: suggestion : O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_68.1
ORA-00280: change 66433 for thread 1 is in sequence #68
ORA-00278: log file 'O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_67.1' no longer
needed for this recovery
ORA-00279: change 66446 generated at 05/08/2004 16:12:27 needed for thread 1
ORA-00289: suggestion : O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_69.1
ORA-00280: change 66446 for thread 1 is in sequence #69
ORA-00278: log file 'O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_68.1' no longer
needed for this recovery
ORA-00279: change 66451 generated at 05/08/2004 16:12:34 needed for thread 1
ORA-00289: suggestion : O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_70.1
ORA-00280: change 66451 for thread 1 is in sequence #70
ORA-00278: log file 'O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_69.1' no longer
needed for this recovery
ORA-00308: cannot open archived log 'O:\ORACLE\ORADATA\LEEGLE\ARCHIVE\ARC_70.1'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。
Total System Global Area 101784276 bytes
Fixed Size 453332 bytes
Variable Size 75497472 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'O:\ORACLE\ORADATA\LEEGLE\SYSTEM01.DBF'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: 'O:\ORACLE\ORADATA\LEEGLE\SYSTEM01.DBF'