柔中带刚，刚中带柔，淫荡中富含柔和，刚猛中荡漾风骚，无坚不摧，无孔不入！
全部博文（1669）
分类： Oracle
2011-12-26 10:21:04
新搭建的环境，还没上线，今天在部署脚本，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 Type Filename/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 1 20-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 1 20-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 Type Filename/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 1 20-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了.
