rman delete failed - did a force

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 15 May 2009 09:09:42 -0400
Message-Id: <4A0D3155.3406.000B.0_at_gcrta.org>

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          R:\RMAN_BKUP_CTLG\BACKUP_RMANCTLG_05KD6QMR_1_1
 
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 RMAN-06214: Backup Piece R:\RMAN_BKUP_CTLG\BACKUP_RMANCTLG_05KD6QMR_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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 15 2009 - 08:09:42 CDT