I posted a message to oracle-l mailing list, but ...

I posted a message to oracle-l mailing list and I recieved a following message.

You are not currently authorized to post messages to oracle-l.

New subscribers to this list are not able to post messages at first. To get this privilege turned on, 
you must email the list administrator at oracle-l-admins_at_freelists.org. 
If you are using an anonymous email address, you must also identify yourself. 
Please be sure to send the request from the address for which you require the privilege, 
not from some other address.

...

I sent a mail to oracle-l-admins_at_freelists.org to get posting privilege trun on.
Following is the mail I replied.

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;

...

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

and my reply.

If you use the DELETE command with the optional FORCE keyword, RMAN
deletes the specified backups, but ignores any I/O errors, including
those that occur when a backup is missing from disk or tape.
*If your Oracle Database version is 9iR2 or later, you can use FORCE option.

For example:

DELETE FORCE NOPROMPT BACKUPSET TAG 'weekly_bkup';

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/maint003.htm#sthref721

RMANリポジトリのレコードを強制削除する - ablog


Yohei the poor English writer.