`
ijavagos
  • 浏览: 1183117 次
  • 性别: Icon_minigender_2
  • 来自: 北京
文章分类
社区版块
存档分类
最新评论

RMAN 备份报错 RMAN-06207 RMAN-06208 解决方法

阅读更多

新搭建的环境,还没上线,今天在部署脚本,RMAN 备份中有一个警告,内容如下:

RMAN-06207: WARNING: 1 objects could not bedeleted for DISK channel(s) due

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212: Object TypeFilename/Handle

RMAN-06213: ------------------------------------------------------------------

RMAN-06214: Datafile Copy /u01/control01.ctl

这个文件是DG的一个控制文件,环境弄好之后,就把这个文件在OS 级别rm 掉了。结果备份就报这个错误。

RMAN> report obsolete;

RMAN retention policy will be applied tothe command

RMAN retention policy is set to redundancy 1

Report of obsolete backups and copies

Type Key Completion Time Filename/Handle

-------------------- ------------------------ --------------------

Control File Copy 120-OCT-11/u01/control01.ctl

RMAN> delete noprompt obsolete;

RMAN retention policy will be applied tothe command

RMAN retention policy is set to redundancy1

using channel ORA_DISK_1

Deleting the following obsolete backups andcopies:

Type Key Completion Time Filename/Handle

-------------------- ------------------------ --------------------

Control File Copy 120-OCT-11/u01/control01.ctl

RMAN-06207: WARNING: 1 objects could not bedeleted for DISK channel(s) due

RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status

RMAN-06210: List of Mismatched objects

RMAN-06211: ==========================

RMAN-06212: Object TypeFilename/Handle

RMAN-06213: ------------------------------------------------------------------

RMAN-06214: Datafile Copy /u01/control01.ctl

解决方法:

RMAN> crosscheck copy;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=1070 devtype=DISK

validation failed for control file copy

control file copyfilename=/u01/control01.ctl recid=1 stamp=765039758

validation succeeded for archived log

archive logfilename=/u01/archive/1_23_765024159.arc recid=44 stamp=765127875

validation succeeded for archived log

archive logfilename=/u01/archive/1_24_765024159.arc recid=45 stamp=765127875

Crosschecked 3 objects

RMAN> delete obsolete;

RMAN retention policy will be applied tothe command

RMAN retention policy is set to redundancy1

using channel ORA_DISK_1

Deleting the following obsolete backups andcopies:

Type Key Completion Time Filename/Handle

-------------------- ------------------------ --------------------

Control File Copy 120-OCT-11/u01/control01.ctl

Do you really want to delete the aboveobjects (enter YES or NO)? y

deleted control file copy

control file copyfilename=/u01/control01.ctl recid=1 stamp=765039758

Deleted 1 objects

RMAN> report obsolete;

RMAN retention policy will be applied tothe command

RMAN retention policy is set to redundancy1

no obsolete backups found

在备份就ok了.

-------------------------------------------------------------------------------------------------------

版权所有. 文章允许转载, 但必须以链接方式注明源地址,否则追究法律责任.

Blog: http://blog.csdn.net/tianlesoftware

Weibo: http://weibo.com/tianlesoftware

Email: tianlesoftware@gmail.com

DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)

DBA 超级群:63306533(满); DBA4 群:83829929(满) DBA5群: 142216823(满)

DBA6 群:158654907(满) DBA7 群:69087192(满)DBA8 群:172855474

DBA 超级群2:151508914 DBA9群:102954821 聊天 群:40132017(满)

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics