數據庫rman restore database 之后，執行recover database的時候，報告ORA-01245錯誤，詳細的錯誤信息如下：

SQL> recover database until cancel;

ORA-00279: change 575876 generated at 12/01/2009 08:19:49 needed for thread 1

ORA-00289: suggestion :

/oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc

ORA-00280: change 575876 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log

'/oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log

'/oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

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

ORA-01245: offline file 2 will be lost if RESETLOGS is done

ORA-01110: data file 2: '/oracle/oradata/orcl/undotbs01.dbf'

SQL>[@more@]

檢查ORA-01245那一行，發現是datafile 2狀態為offline，解決的方法就是首先將datafile 2 online，然后再recover database。SQL> alter database datafile 2 online;

Database altered.

SQL> recover database until cancel;

ORA-00279: change 575876 generated at 12/01/2009 08:19:49 needed for thread 1

ORA-00289: suggestion :

/oracle/flash_recovery_area/ORCL/archivelog/2009_12_01/o1_mf_1_2_%u_.arc

ORA-00280: change 575876 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

Media recovery cancelled.

SQL> alter database open resetlogs;

Database altered.

SQL>

總結

以上是生活随笔為你收集整理的oracle ora 00279,ORA-01245、ORA-01547错误的解决的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。