RMAN恢復歸檔但是歸檔放到ASM中,ASM已經掛掉的情況
Starting recover at 21-SEP-13
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=118
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1
ORA-19504: failed to create file "+ARCH"
ORA-17502: ksfdcre:4 Failed to create file +ARCH
ORA-15001: diskgroup "ARCH" does not exist or is not mounted
ORA-15001: diskgroup "ARCH" does not exist or is not mounted
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/21/2013 15:15:28
RMAN-20506: no backup of archived log found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 118 and starting SCN of 2282135 found to
如下:
RMAN> run {
2> set archivelog destination to '/home/oracle/';
3> recover database;}
executing command: SET ARCHIVELOG DESTINATION
Starting recover at 21-SEP-13
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle/
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=118
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1
channel ORA_DISK_1: piece handle=/oracle/app/oracle/product/11.2.0/dbs/05okdn1e_1_1 tag=TAG20130921T143110
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/home/oracle/1_118_823620769.dbf thread=1 sequence=118
channel ORA_DISK_1: starting archived log restore to user-specified destination
archived log destination=/home/oracle/
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=119
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=120
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=121
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=122
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=123
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=124
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=125
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=126
channel ORA_DISK_1: reading from backup piece /oracle/app/oracle/product/11.2.0/dbs/06okdn6b_1_1
channel ORA_DISK_1: piece handle=/oracle/app/oracle/product/11.2.0/dbs/06okdn6b_1_1 tag=TAG20130921T143346
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=/home/oracle/1_119_823620769.dbf thread=1 sequence=119
archived log file name=/home/oracle/1_120_823620769.dbf thread=1 sequence=120
archived log file name=/home/oracle/1_121_823620769.dbf thread=1 sequence=121
archived log file name=/home/oracle/1_122_823620769.dbf thread=1 sequence=122
archived log file name=/home/oracle/1_123_823620769.dbf thread=1 sequence=123
archived log file name=/home/oracle/1_124_823620769.dbf thread=1 sequence=124
archived log file name=/home/oracle/1_125_823620769.dbf thread=1 sequence=125
archived log file name=/home/oracle/1_126_823620769.dbf thread=1 sequence=126
記錄一下
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7728585/viewspace-774621/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle dg 歸檔日誌恢復情況Oracle
- ASM 管理歸檔ASM
- rman datafile恢復(歸檔模式)模式
- RAC(ASM)歸檔模式修改ASM模式
- Oracle控制檔案在缺失歸檔日誌的情況下的恢復Oracle
- 【BBED】丟失歸檔檔案情況下的恢復
- 恢復案例:無歸檔,掉電,控制檔案全部丟失恢復
- 無歸檔日誌恢復rman資料
- oracle RMAN 非歸檔資料庫恢復Oracle資料庫
- ASM 中使用RMAN delete archivelog until time刪除歸檔檔案ASMdeleteHive
- 誤刪資料檔案在沒有歸檔的情況下恢復實驗
- 【備份恢復】恢復 丟失已歸檔重做日誌檔案
- rman恢復--歸檔模式有備份,丟失資料檔案的恢復模式
- rman恢復--歸檔模式無備份,丟失資料檔案的恢復模式
- rman 恢復---歸檔丟失and資料檔案損壞
- 【DATAGUARD】物理dg在主庫丟失歸檔檔案的情況下的恢復(七)
- 11.2.0.3.2 RMAN無法恢復歸檔日誌
- Rman Crosscheck刪除失效歸檔-備份恢復ROS
- 測試在丟失歸檔日誌的情況下,跳過部分歸檔日誌進行資料恢復資料恢復
- RMAN備份及恢復歸檔日誌的語法
- asm下如何自動刪除standby上已經applied過的歸檔日誌ASMAPP
- dg丟失歸檔,使用rman增量備份恢復
- 恢復之非歸檔模式下的恢復模式
- ORACLE非歸檔下的恢復Oracle
- 【故障處理】DG環境主庫丟失歸檔情況下資料檔案的恢復
- 歸檔資料庫中的不可恢復操作資料庫
- 丟失已歸檔日誌檔案下恢復資料庫資料庫
- 無備份恢復(歸檔模式)已刪除資料檔案模式
- rman 非歸檔模式下停庫備份與恢復模式
- 恢復歸檔日誌檔案的常用方法
- 指令碼定期自動刪除ASM下的歸檔檔案指令碼ASM
- Rman在run命令塊裡臨時設定歸檔目錄,歸檔日誌能否恢復主要看預設的歸檔路徑
- Data Guard跳歸檔恢復的案例
- DG歸檔日誌缺失恢復
- 無備份恢復(歸檔模式)模式
- RMAN備份恢復之歸檔日誌對BLOCKRECOVER的影響BloC
- [ORACLE ASM] AMDU 恢復資料檔案OracleASM
- RMAN恢復表空間,資料檔案,歸檔檔案,控制檔案等介紹