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/rman@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.

Oracle Error :: RMAN-06093

recovery catalog contains obsolete version of datafile string

Cause

The specified datafile number was dropped and then reused. The control file mounted by the target database contains the newer version of the datafile, but the recovery catalog contains information about only the older version.

Action

Issue a RESYNC command to update the recovery catalog, then reissue the failing command. If the error persists, contact Oracle Customer Support.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22049049/viewspace-1024033/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/22049049/viewspace-1024033/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值