Oracle 11g RMAN恢復時報錯"RMAN-06100"、"RMAN-06026"、"RMAN-03002"
Oracle 11g RMAN異機恢復時報錯,錯誤如下:
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2016-05-19 11:00:01
released channel: dev1
released channel: dev2
released channel: dev3
released channel: dev4
released channel: dev5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/19/2016 11:00:01
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 80
RMAN-06100: no channel to restore a backup or copy of datafile 79
RMAN-06100: no channel to restore a backup or copy of datafile 78
RMAN-06100: no channel to restore a backup or copy of datafile 77
RMAN-06100: no channel to restore a backup or copy of datafile 76
RMAN-06100: no channel to restore a backup or copy of datafile 75
報錯原因:
恢復控制檔案後,沒有將RMAN備份註冊到控制檔案中,導致RMAN在恢復資料檔案時無法找到備份
解決辦法:
將RMAN備份註冊到控制檔案中
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 2016-05-19 11:00:01
released channel: dev1
released channel: dev2
released channel: dev3
released channel: dev4
released channel: dev5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/19/2016 11:00:01
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 80
RMAN-06100: no channel to restore a backup or copy of datafile 79
RMAN-06100: no channel to restore a backup or copy of datafile 78
RMAN-06100: no channel to restore a backup or copy of datafile 77
RMAN-06100: no channel to restore a backup or copy of datafile 76
RMAN-06100: no channel to restore a backup or copy of datafile 75
恢復控制檔案後,沒有將RMAN備份註冊到控制檔案中,導致RMAN在恢復資料檔案時無法找到備份
解決辦法:
將RMAN備份註冊到控制檔案中
RMAN> CATALOG START WITH '/oradata/rman';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26506993/viewspace-2102987/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11g RMAN 異機恢復Oracle
- Oracle 11g RMAN恢復-只讀表空間的恢復Oracle
- 應對RMAN-06026錯誤,使用dbms_backup_restore進行恢復REST
- 資料遷移的時候出現RMAN-03002,RMAN-06026
- Oracle 11g RMAN 異機恢復報錯 RMAN-06172、ORA-07202Oracle
- rman恢復方案和oracle異機恢復Oracle
- oracle實驗記錄 (恢復-rman恢復)Oracle
- Oracle RMAN恢復測試Oracle
- Oracle rman 各種恢復Oracle
- Oracle RMAN異機恢復Oracle
- Xtrabackup恢復時報錯'Error: datadir must be specified'Error
- Oracle RMAN 表空間恢復Oracle
- oracle的RMAN異機恢復Oracle
- Windows oracle 11g rman備份恢復到linux系統WindowsOracleLinux
- RMAN-06026報錯解決方法
- Oracle異機恢復執行startup nomount時報錯ORA-1565、ORA-27037、RMAN-4014Oracle
- Oracle 11g RMAN恢復-使用者誤刪除表空間Oracle
- “神奇”的oracle 11.2.0.3 RMAN恢復Oracle
- oracle RMAN 備份恢復總結Oracle
- oracle RMAN 備份恢復總結Oracle
- oracle之rman恢復資料庫Oracle資料庫
- oracle rman備份恢復的例子Oracle
- oracle rman之丟失spfile恢復Oracle
- RMAN恢復 執行重要檔案RMAN恢復
- RMAN-06026 錯誤分析與解決
- Oracle 11G 恢復目錄Oracle
- Oracle 11g 例項恢復Oracle
- Oracle 11G 備份與恢復 使用RMAN建立備份集舉例Oracle
- Oracle 11G 備份與恢復 使用RMAN建立映象拷貝舉例Oracle
- RMAN跨版本恢復--從Oracle10.2.0.5恢復到Oracle11.2.0.4Oracle
- ORACLE DG從庫 Rman備份恢復Oracle
- Oracle RMAN 表空間的完全恢復Oracle
- Oracle 12c RMAN 異機恢復Oracle
- oracle 12C rman下表的恢復Oracle
- ORACLE RMAN異機異目錄恢復Oracle
- RMAN-06014:RMAN-03002:錯誤解決方法
- Oracle10g/11g – 恢復管理器 (Recovery Manager, RMAN) 入門指南Oracle
- 【RMAN】RMAN跨版本恢復(上)