ORA-01547、ORA-01994错误解决一例

rman恢复后，在做recover database的时候，出现ORA-01547、ORA-01994错误，错误信息如下：

SQL> recover database until cancel; ORA-00279: change 548207 generated at 11/28/2009 10:25:46 needed for thread 1 ORA-00289: suggestion : /oracle/flash_recovery_area/ORCL/archivelog/2009_11_30/o1_mf_1_1_%u_.arc ORA-00280: change 548207 for thread 1 is in sequence #1 Specify log: {=suggested | filename | AUTO | CANCEL} 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: '/oracle/oradata/orcl/system01.dbf' ORA-01112: media recovery not started

[@more@]

尝试使用resetlog方式启动数据库，报如下ORA-01194错误:

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: '/oracle/oradata/orcl/system01.dbf'

尝试使用noresetlogs方式启动数据库，报ORA-01113错误，确定datafile 2需要media recovery

SQL> alter database open noresetlogs; alter database open noresetlogs * ERROR at line 1: ORA-01113: file 2 needs media recovery ORA-01110: data file 2: '/oracle/oradata/orcl/undotbs01.dbf'

对datafile 2进行recover之后，启动数据库，数据库启动正常。

SQL> alter database recover datafile 2; Database altered. SQL> alter database open; Database altered. SQL>

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

转载于:http://blog.itpub.net/22049049/viewspace-1029178/