今天在运行 delete obsolete报错了
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Controlfile Copy 15 23-SEP-09 /opt/oracle/control01.ctl
Do you really want to delete the above objects (enter YES or NO)? yes
RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
List of Mismatched objects
==========================
Object Type Filename/Handle
--------------- ---------------------------------------------------
Datafile Copy /opt/oracle/control01.ctl
RMAN> crosscheck backup;
using channel ORA_DISK_1
using channel ORA_DISK_2
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/TTL_ESCALADE_20090923_92 recid=86 stamp=698329633
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/TTL_ESCALADE_20090923_93 recid=87 stamp=698329633
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/arch_ESCALADE_20090923_97 recid=91 stamp=698329715
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/rman_bak/ESCALADE/2009-09-23/ctl_c-2788940106-20090923-04 recid=92 stamp=698329717
Crosschecked 4 objects
发现crosscheck backup 和crosscheck backupset发现不了该文件
要用 CROSSCHECK CONTROLFILECOPY 语句
RMAN> CROSSCHECK CONTROLFILECOPY '/opt/oracle/control01.ctl';
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=32 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=35 devtype=DISK
validation failed for controlfile copy
controlfile copy filename=/opt/oracle/control01.ctl recid=15 stamp=698319446
Crosschecked 1 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Controlfile Copy 15 23-SEP-09 /opt/oracle/control01.ctl
Do you really want to delete the above objects (enter YES or NO)? yes
deleted controlfile copy
controlfile copy filename=/opt/oracle/control01.ctl recid=15 stamp=698319446
Deleted 1 objects
删除成功