今天客戶誤執行了大量DELETE操作，在為客戶的Oracle RAC Database 11.2.0.3 for Linux做不完全恢復，執行recover操作的時候報如下的錯誤：

unable to find archived log

archived log thread=2 sequence=0

Oracle Error:

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

ORA-01152: file 5 was not restored from a sufficiently old backup

ORA-01110: data file 5: '/oradata/datafile1/ccense/undotbs02.dbf'

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/20/2012 17:50:56

RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 0 and starting SCN of 8429237

下面是對ORA-1547錯誤的描述：

Oracle8

~~~~~~~

Error: ORA-1547

Text: "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"

-------------------------------------------------------------------------------

Cause: Media recovery with one of the incomplete recovery options ended

without error. However, if the ALTER DATABASE OPEN RESETLOGS command

were attempted now, it would fail with the specified error.

The most likely cause of this error is forgetting to restore one or

more datafiles from a sufficiently old backup before executing the

incomplete recovery.

Action: Rerun the incomplete media recovery using different datafile

backups, a different control file, or different stop criteria.

前面的恢復操作是在控制檔案為丟失的情況下執行的。在確保沒有歸檔日誌丟失的情況下，還原一個老的控制檔案，使用老的控制檔案執行不完全恢復即可正常的執行。

從舊控制檔案執行不完全恢復可以參考文章：http://space.itpub.net/23135684/viewspace-722050（RMAN工具）和http://space.itpub.net/23135684/viewspace-722450（sqlplus工具）

總結：執行恢復操作前一定要做好備份，即使資料庫存在問題也應該想辦法做好備份，這樣可以確保在恢復失敗的情況下能夠還原到之前的狀態，這就是所謂的操作回退。做重要的操作前都應該較全面的思考整個操作過程和操作失敗後的回退，這個非常重要！

Oracle RMAN recover報錯：ORA-01547 ORA-01152 ORA-01110

相關文章