RMAN-06054: media recovery requesting unknown archived log for thread...
使用rman執行recover database 的時候出現RMAN-06054的錯誤提示:
在11g官方文件error messages中對錯誤描述如下:
RMAN-06054: media recovery requesting unknown archived log for thread string with sequence string and starting SCN of string
RMAN> recover database;
Starting recover at 21-OCT-14
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 1 is already on disk as file /u01/app/archivelog/dest2/1_1_861389770.dbf
archived log for thread 1 with sequence 2 is already on disk as file /u01/app/archivelog/dest1/1_2_861389770.dbf
archived log for thread 1 with sequence 3 is already on disk as file /u01/app/archivelog/dest1/1_3_861389770.dbf
archived log for thread 1 with sequence 4 is already on disk as file /u01/app/archivelog/dest1/1_4_861389770.dbf
archived log for thread 1 with sequence 5 is already on disk as file /u01/app/archivelog2/dest1/1_5_861389770.dbf
archived log for thread 1 with sequence 6 is already on disk as file /u01/app/archivelog2/dest1/1_6_861389770.dbf
archived log file name=/u01/app/archivelog/dest2/1_1_861389770.dbf thread=1 sequence=1
archived log file name=/u01/app/archivelog/dest1/1_2_861389770.dbf thread=1 sequence=2
archived log file name=/u01/app/archivelog/dest1/1_3_861389770.dbf thread=1 sequence=3
archived log file name=/u01/app/archivelog/dest1/1_4_861389770.dbf thread=1 sequence=4
archived log file name=/u01/app/archivelog2/dest1/1_5_861389770.dbf thread=1 sequence=5
archived log file name=/u01/app/archivelog2/dest1/1_6_861389770.dbf thread=1 sequence=6
unable to find archived log
archived log thread=1 sequence=7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/21/2014 01:28:11
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 7 and starting SCN of 2292709
在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,本案例是2292709。也就是說此時資料庫只能進行不完全恢復了,在開啟資料庫時得使用resetlogs開啟。
可見,出先此錯誤的原因是恢復需要的日誌記錄在控制檔案或恢復目錄中找不到。解決方法分兩種情況:
1.如果相關的日誌存在且可用的話,就將此日誌記錄新增到控制檔案或恢復目錄中。
2.如果相關的日誌已經被刪除了或不可用了,那麼就按照錯誤的提示scn將資料庫恢復到此scn,本案例是2292709。也就是說此時資料庫只能進行不完全恢復了,在開啟資料庫時得使用resetlogs開啟。
RMAN> recover database until scn 2292709;
Starting recover at 21-OCT-14
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 21-OCT-14
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29800581/viewspace-1307267/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- NBU (98) error requesting media (tpreq)Error
- Crash recovery和Media recovery的區別
- Archived redolog is (significant) smaller than the redologfileHiveNifi
- ORA-16139: media recovery requiredUI
- 【REDO】Archived redolog is (significant) smaller than the redologfileHiveNifi
- oracle media recovery介質恢復實驗-Oracle
- oracle media recovery介質恢復小記Oracle
- Archived redolog is (significant) smaller than the redologfile_1356604.1HiveNifi
- RMAN-05541: no archived logs found in target databaseHiveDatabase
- OGG-00446 ERROR: Could not find archived logErrorHive
- Oracle OCP 1Z0 053 Q517(Block Media Recovery&Archivelog Mode&Flashback Logging)OracleBloCHive
- RMAN-08137: WARNING: Archived Log Not DeletedHivedelete
- ogg GGS ERROR 500 Could not find archived logErrorHive
- Create recovery catalog Configure Recovery Manager
- ORACLE 9i歸檔之ARCn: Media recovery disabledOracle
- Log actively being archived by another process問題解決Hive
- 【oracle】ORA-16038: log 2 sequence# 98 cannot be archivedOracleHive
- Recovery Catalog creation and MaintenanceAINaN
- oracle 9i physical standby database 上的v$archived_logOracleDatabaseHive
- MRP0- Background Media Recovery terminated with error 1111Error
- Oracle OCP 1Z0 053 Q399(block media recovery)OracleBloC
- Oracle OCP 1Z0 053 Q401(Block Media Recovery)OracleBloC
- Archived Redo Logs歸檔重做日誌介紹及其優點Hive
- 清除Oracle控制檔案中的歸檔資訊v$archived_logOracleHive
- RMAN-08137: WARNING: archived log not deleted, needed for standby or upstreamHivedelete
- Disk Drill Media Recovery for Mac(支援多種格式的資料恢復工具)Mac資料恢復
- MRP0: Background Media Recovery terminated with error 328,ORA-00328Error
- RMAN 中V$ARCHIVED_LOG 中STATUS 為"X" 的檔案處理Hive
- ASM管理環境----資料檔案丟失介質恢復(MEDIA RECOVERY)ASM
- rman 刪除v$archive_log檢視裡的記錄(Removing entries in v$archived_log)HiveREM
- mysqlbinlog: unknown variable 'default-character-set=utf8'MySql
- ERROR 1193: Unknown system variable 'log_slow_queries'Error
- 【問題處理】ORA-01113 file xxx need media recovery
- ORA-16014: log 1 sequence# 4 not archived, no available destinationsHiveAI
- ORA-16014: log 2 sequence# 59 not archived, no available destinationsHiveAI
- ORA-16014: log 1 sequence# 857 not archived, no available destinationsHiveAI
- Duplicating a Database Without Recovery Catalog or Target ConnectionDatabase
- 多種格式的資料恢復軟體Disk Drill Media Recovery 4.5.972中文資料恢復