ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

 出现的错误

ORA-00279: change 2492710 generated at 08/06/2015 01:04:59 needed for thread 1

ORA-00289: suggestion : /u01/oradata/denver/archive/1_21.dbf

ORA-00280: change 2492710 for thread 1 is in sequence #21

错误起因:

在模拟控制文件丢失,redo log文件丢失,数据文件存在,在用以备份的控制文件脚本恢复文件之后,利用recover database using backup control file until cancel出现以上错误

错误经过:

SQL> recover database until cancel using backup controlfile;

ORA-00279: change 2492710 generated at 08/06/2015 01:04:59 needed for thread 1

ORA-00289: suggestion : /u01/oradata/denver/archive/1_21.dbf

ORA-00280: change 2492710 for thread 1 is in sequence #21

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

cancel   --因为redo log文件丢失,所以选择cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/oradata/denver/system01.dbf'

ORA-01112: media recovery not started

   如果这个时候用alter database open resetlogs是无法打开的,如下:

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/oradata/denver/system01.dbf' --说明system表空间需要redo log才能恢复,那么如何解决的?

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29840459/viewspace-1763505/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29840459/viewspace-1763505/