rman delete failed - did a force

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
  • Date: Fri, 15 May 2009 09:09:42 -0400

I changed the command to "delete force obsolete" and then it worked.
Getting following error when doing a delete command.  I can not run a 
crosscheck command since we backup the backups via OS to tape and then delete 
the file that rman had created.  Therefore, only the most current backup is on 
disk.  How do I resolve this error?
RMAN> delete noprompt expired backup;
2> delete obsolete;
3> backup as compressed backupset database plus archivelog delete input;
4> exit;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=58 devtype=DISK
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 21 days
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      23-APR-09         
  Backup Piece       1      23-APR-09          F:\10G\DATABASE\01KD6Q25_1_1
Backup Set           2      23-APR-09         
  Backup Piece       2      23-APR-09          F:\10G\DATABASE\02KD6Q2E_1_1
Backup Set           3      23-APR-09         
  Backup Piece       3      23-APR-09          F:\10G\DATABASE\03KD6Q2U_1_1
Backup Set           4      23-APR-09         
  Backup Piece       4      23-APR-09          F:\10G\DATABASE\04KD6Q32_1_1
Backup Set           5      23-APR-09         
  Backup Piece       5      23-APR-09          
RMAN-06207: WARNING: 5 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: Backup Piece    F:\10G\DATABASE\01KD6Q25_1_1
RMAN-06214: Backup Piece    F:\10G\DATABASE\02KD6Q2E_1_1
RMAN-06214: Backup Piece    F:\10G\DATABASE\03KD6Q2U_1_1
RMAN-06214: Backup Piece    F:\10G\DATABASE\04KD6Q32_1_1
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Greater Cleveland Regional Transit 
Authority (GCRTA)

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.

Other related posts: