The script. of RMAN backup is as follows:

run
{
BACKUP FORMAT '/home/oracle/backup_rman/dbf_%U' DATABASE TAG Full_bk;
BACKUP CURRENT ControlFile FORMAT '/home/oracle/backup_rman/ctl_%U';
BACKUP FORMAT '/home/oracle/backup_rman/arch_%U' ARCHIVELOG ALL TAG Archivelog_bk;
RESTORE DATABASE VALIDATE;
CROSSCHECK BACKUP OF DATABASE;
REPORT OBSOLETE;
}
LIST BACKUP SUMMARY;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-8';

Errors are as follows:

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: Archivelog      +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239
RMAN-06214: Archivelog      +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239

 

#如果Object Type是Backup Piece, 那么执行
MAN> CROSSCHECK BACKUP;
#因为这里Object Type都是Archivelog, 所以
RMAN> CROSSCHECK Archivelog all;
#或者指定过期日期
RMAN> CROSSCHECK ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
...............................
Crosschecked 22 objects

RMAN> REPORT OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          9670   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239
Archive Log          9669   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239
 
RMAN> DELETE NOPROMPT OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log          9670   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239
Archive Log          9669   08-MAR-11          +BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239
deleted archive log
archive log filename=+BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_3_seq_1545.5219.745259239 recid=9670 stamp=745259243
deleted archive log
archive log filename=+BACKUP_DG/pwiuim/archivelog/2011_03_08/thread_1_seq_1626.3205.745259239 recid=9669 stamp=745259243
Deleted 2 objects

RMAN> REPORT OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
no obsolete backups found