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
Yohei the poor English writer.
