Oracle 11g RMAN恢復時報錯"RMAN-06100"、"RMAN-06026"、"RMAN-03002"

feelpurple發表於2016-05-19
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備份註冊到控制檔案中

RMAN> CATALOG START WITH '/oradata/rman';

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

相關文章