ORA-01547、ORA-01994錯誤解決一例

cnhtm發表於2009-11-30

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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章