RMAN错误集锦(四)
Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 18 15-APR-13 /u01/app/oracle/product/11g/dbs/arch1_40_809101738.dbf
Archive Log 20 15-APR-13 /u01/app/oracle/product/11g/dbs/arch1_39_809101738.dbf
Do you really want to delete the above objects (enter YES or NO) yes
deleted archived log
archived log file name=/u01/app/oracle/product/11g/dbs/arch1_39_809101738.dbf RECID=20 STAMP=812827142
Deleted 1 objects
RMAN-06207: WARNING: 1 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 /u01/app/oracle/product/11g/dbs/arch1_40_809101738.dbf
RMAN> crosscheck archivelog '/u01/app/oracle/product/11g/dbs/arch1_40_809101738.dbf'
2> ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
validation failed for archived log
archived log file name=/u01/app/oracle/product/11g/dbs/arch1_40_809101738.dbf RECID=18 STAMP=812827142
Crosschecked 1 objects
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Archive Log 18 15-APR-13 /u01/app/oracle/product/11g/dbs/arch1_40_809101738.dbf
Do you really want to delete the above objects (enter YES or NO) yes
deleted archived log
archived log file name=/u01/app/oracle/product/11g/dbs/arch1_40_809101738.dbf RECID=18 STAMP=812827142
Deleted 1 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found