[Rman]RMAN-06207 WARNING:2 objects could not be deleted for DISK channel(s) due

1)使用RMAN刪除備份時，出現RMAN-06207和RMAN-06208錯誤

RMAN> delete obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=28 device type=DISK

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

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

Backup Set           369    27-NOV-15        

  Backup Piece       375    27-NOV-15          /u01/oracle/fast_recovery_area/NEAL/backupset/2015_11_27/o1_mf_nnndf_TAG20151127T163150_c5j57pds_.bkp

Backup Set           371    27-NOV-15        

  Backup Piece       377    27-NOV-15          /u01/oracle/fast_recovery_area/NEAL/backupset/2015_11_27/o1_mf_nnndf_TAG20151127T163431_c5j5dql1_.bkp

Backup Set           372    27-NOV-15        

  Backup Piece       378    27-NOV-15          /file/backup/rman/controlfile_c-4033362200-20151127-0e

Control File Copy     389    24-NOV-15          /u01/a.txt

Backup Set           374    27-NOV-15        

  Backup Piece       380    27-NOV-15          /file/backup/rman/controlfile_c-4033362200-20151127-0f

Control File Copy     390    24-NOV-15          /u01/a.tc

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece

backup piece handle=/u01/oracle/fast_recovery_area/NEAL/backupset/2015_11_27/o1_mf_nnndf_TAG20151127T163150_c5j57pds_.bkp RECID=210 STAMP=896891510

deleted backup piece

backup piece handle=/u01/oracle/fast_recovery_area/NEAL/backupset/2015_11_27/o1_mf_nnndf_TAG20151127T163431_c5j5dql1_.bkp RECID=216 STAMP=896891671

deleted backup piece

backup piece handle=/file/backup/rman/controlfile_c-4033362200-20151127-0e RECID=217 STAMP=896891672

deleted backup piece

backup piece handle=/file/backup/rman/controlfile_c-4033362200-20151127-0f RECID=219 STAMP=896891680

Deleted 4 objects

RMAN-06207: WARNING: 2 objects could not be deleted 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/a.txt

RMAN-06214: Datafile Copy   /u01/a.tc

2）使用crosscheck controlfilecopy時需要帶上檔案路徑

RMAN> CROSSCHECK CONTROLFILECOPY;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found ";": expecting one of: "tag, double-quoted-string, integer, single-quoted-string"

RMAN-01007: at line 2 column 1 file: standard input

RMAN> CROSSCHECK CONTROLFILECOPY '/u01/a.txt';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=28 device type=DISK

validation failed for control file copy

control file copy file name=/u01/a.txt RECID=11 STAMP=896609481

Crosschecked 1 objects

RMAN> CROSSCHECK CONTROLFILECOPY '/u01/a.tc';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=28 device type=DISK

validation failed for control file copy

control file copy file name=/u01/a.tc RECID=12 STAMP=896609577

Crosschecked 1 objects

3）再次刪除時，問題解決

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

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

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

Control File Copy     389    24-NOV-15          /u01/a.txt

Control File Copy     390    24-NOV-15          /u01/a.tc

Do you really want to delete the above objects (enter YES or NO)? yes

deleted control file copy

control file copy file name=/u01/a.txt RECID=11 STAMP=896609481

deleted control file copy

control file copy file name=/u01/a.tc RECID=12 STAMP=896609577

Deleted 2 objects

Author:NEAL
DATE:2015-12-03