RMAN CROSSCHECK

手工删除了一些东西

RMAN>  crosscheck archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_22/o1_mf_1_47_5g09g7ls_.arc recid=3 stamp=700939721
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_1_5g2587mc_.arc recid=4 stamp=701000986
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_2_5g25cwdz_.arc recid=5 stamp=701001124
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_3_5g25f53j_.arc recid=6 stamp=701001154
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_4_5g25g3s9_.arc recid=7 stamp=701001177
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_5_5g25j6m0_.arc recid=8 stamp=701001249
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_6_5g2lrjk5_.arc recid=9 stamp=701014805
validation succeeded for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_11_10/o1_mf_1_7_5hllhht6_.arc recid=10 stamp=702587404
validation succeeded for archived log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_11_13/o1_mf_1_8_5hspgzox_.arc recid=11 stamp=702820840
Crosschecked 9 objects

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
3       1    47      X 22-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_22/o1_mf_1_47_5g09g7ls_.arc
4       1    1       X 22-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_1_5g2587mc_.arc
5       1    2       X 23-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_2_5g25cwdz_.arc
6       1    3       X 23-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_3_5g25f53j_.arc
7       1    4       X 23-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_4_5g25g3s9_.arc
8       1    5       X 23-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_5_5g25j6m0_.arc
9       1    6       X 23-OCT-09 /opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_6_5g2lrjk5_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_22/o1_mf_1_47_5g09g7ls_.arc recid=3 stamp=700939721
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_1_5g2587mc_.arc recid=4 stamp=701000986
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_2_5g25cwdz_.arc recid=5 stamp=701001124
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_3_5g25f53j_.arc recid=6 stamp=701001154
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_4_5g25g3s9_.arc recid=7 stamp=701001177
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_5_5g25j6m0_.arc recid=8 stamp=701001249
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/ORCL/archivelog/2009_10_23/o1_mf_1_6_5g2lrjk5_.arc recid=9 stamp=701014805
Deleted 7 EXPIRED objects
RMAN> report obsolete;

using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      22-OCT-09        
  Backup Piece       1      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp
Backup Set           2      22-OCT-09        
  Backup Piece       2      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      22-OCT-09        
  Backup Piece       1      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp
Backup Set           2      22-OCT-09        
  Backup Piece       2      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp

Do you really want to delete the above objects (enter YES or NO)? YES 

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: Backup Piece    /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp
RMAN-06214: Backup Piece    /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp

 

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK
specification does not match any archive log in the recovery catalog

 

 

RMAN> crosscheck backupset ;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp recid=1 stamp=700928862
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp recid=2 stamp=700929077
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp recid=3 stamp=700929082
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T143121_5fzzcg0l_.bkp recid=4 stamp=700929390
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143634_5fzzcmfo_.bkp recid=5 stamp=700929395
Crosschecked 5 objects

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      22-OCT-09        
  Backup Piece       1      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp
Backup Set           4      22-OCT-09        
  Backup Piece       4      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T143121_5fzzcg0l_.bkp

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
-------------------- ------ ------------------ --------------------
Backup Set           1      22-OCT-09        
  Backup Piece       1      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp
Backup Set           4      22-OCT-09        
  Backup Piece       4      22-OCT-09          /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T143121_5fzzcg0l_.bkp

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T142737_5fzytyh2_.bkp recid=1 stamp=700928862
deleted backup piece
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_ncnnf_TAG20091022T143121_5fzzcg0l_.bkp recid=4 stamp=700929390
Deleted 2 objects

 

删不掉，用如下命令

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
2       2       1   1   EXPIRED     DISK        /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp
3       3       1   1   EXPIRED     DISK        /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp
5       5       1   1   EXPIRED     DISK        /opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143634_5fzzcmfo_.bkp

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143115_5fzz1oyv_.bkp recid=2 stamp=700929077
deleted backup piece
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_nnndf_TAG20091022T143121_5fzz1t8k_.bkp recid=3 stamp=700929082
deleted backup piece
backup piece handle=/opt/oracle/flash_recovery_area/ORCL/backupset/2009_10_22/o1_mf_annnn_TAG20091022T143634_5fzzcmfo_.bkp recid=5 stamp=700929395
Deleted 3 EXPIRED objects

RMAN> crosscheck backupset;

using channel ORA_DISK_1