RMAN-06133 錯誤解決一例

一、問題：在做資料庫的異地恢復的時候，恢復控制檔案報RMAN-06024錯

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"';
4> sql 'alter session set NLS_LANGUAGE=American';
5> set until time='2009-07-09 21:50:00';
6> restore controlfile;
7> release channel t1;
8> }

allocated channel: t1
channel t1: sid=1117 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0

sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

sql statement: alter session set NLS_LANGUAGE=American

executing command: SET until clause

Starting restore at 10-JUL-09

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/10/2009 09:24:45
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

crosscheck發現控制檔案是存在的：crosscheck結果如下：

backup piece handle=controlfile1_20090708_691709298 recid=5718 stamp=691709298
crosschecked backup piece: found to be 'AVAILABLE'

透過 restore controlfile from "controlfile1_20090708_691709298";語句可以恢復該控制檔案。

但接下來恢復資料檔案時，報RMAN-06133錯誤：

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"';
4> sql 'alter session set NLS_LANGUAGE=American';
5> set until time='2009-07-09 21:50:00';
6> restore database;
7> release channel t1;
8> }

allocated channel: t1
channel t1: sid=1117 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0

sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

sql statement: alter session set NLS_LANGUAGE=American

executing command: SET until clause

Starting restore at 10-JUL-09

released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/10/2009 10:45:12
RMAN-06133: recovery catalog may have obsolete data for datafile 43

二、在原備份的資料庫上檢查43號檔案，是最近加入的，懷疑是rman的catalog資訊和資料庫的控制檔案不一致，透過resync catalog之後，重新恢復控制檔案，然後恢復資料檔案，解決了問題

三、操作步驟

$ rman target / catalog

RMAN> resync catalog;

starting full resync of recovery catalog
full resync complete

RMAN>

[@more@]

相關錯誤：

RMAN-06133:	recovery catalog may have obsolete data for datafile string
Cause:	A RESTORE UNTIL was issued, and the recovery catalog choose an older incarnation of the datafile than is listed in the control file.
Action:	If the recovery catalog has correct data for the datafile, then restore a backup control file using the same UNTIL clause, then retry the datafile restore. Otherwise, restore a backup of the incarnation of the datafile listed in the control file.