使用rman執行recover database 的時候出現RMAN-06054的錯誤提示

pxbibm發表於2017-02-14
Database

RMAN> recover database;

Starting recover at 14-FEB-17
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=4120
channel ORA_DISK_1: reading from backup piece /dbbackup/hcms/backupset/2/FULL_HCMS_LOG_20170214_e4rsibf3_1_1.rmanbak
channel ORA_DISK_1: piece handle=/dbbackup/hcms/backupset/2/FULL_HCMS_LOG_20170214_e4rsibf3_1_1.rmanbak tag=TAG20170214T125603
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/app/oracle/archive/1_4120_858952281.dbf thread=1 sequence=4120
unable to find archived log
archived log thread=1 sequence=4121
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/14/2017 13:44:51
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 4121 and starting SCN of 152305555

在11g官方文件error messages中對錯誤描述如下：
RMAN-06054: media recovery requesting unknown archived log for thread string with sequence string and starting SCN of string

Cause: Media recovery is requesting a log whose existence is not recorded in the recovery catalog or target database control file.
Action: If a copy of the log is available, then add it to the recovery catalog and/or control file via a CATALOG command and then retry the RECOVER command. If not, then a point-in-time recovery up to the missing log is the only alternative and database can be opened using ALTER DATABASE OPEN RESETLOGS command.

可見，出先此錯誤的原因是恢復需要的日誌記錄在控制檔案或恢復目錄中找不到。解決方法分兩種情況：
1.如果相關的日誌存在且可用的話，就將此日誌記錄新增到控制檔案或恢復目錄中。
2.如果相關的日誌已經被刪除了或不可用了，那麼就按照錯誤的提示scn將資料庫恢復到此scn，本案例是152305555。也就是說此時資料庫只能進行不完全恢復了.
3.在開啟資料庫時得使用resetlogs開啟。

RMAN>  recover database until scn 152305555;

Starting recover at 14-FEB-17
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 14-FEB-17

RMAN> alter database open resetlogs;

database opened




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12798004/viewspace-2133511/，如需轉載，請註明出處，否則將追究法律責任。

相關文章