今天在做rman 删除过期备份的文件。命令如下:
RMAN> allocate channel for maintenance type disk ;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=382 instance=socl1 devtype=DISK
RMAN> crosscheck backup ;
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/2dld3018_77_1_05 recid=76 stamp=718372910
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/backup/2eld303o_78_1_05 recid=77 stamp=718372985
crosschecked backup piece: found to be 'EXPIRED'
。。。。。
RMAN> delete expired backup ;
List of Backup Pieces
BP KeyBS KeyPc# Cp# StatusDevice Type Piece Name
------- ------- --- --- ----------- ----------- ----------
76761 1 EXPIRED DISK/backup/2dld3018_77_1_05
77771 1 EXPIRED DISK/backup/2eld303o_78_1_05
78781 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100507-00
79791 1 EXPIRED DISK/backup/2gld5kc3_80_1_05
。。。。。。。。
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/backup/2dld3018_77_1_05 recid=76 stamp=718372910
deleted backup piece
backup piece handle=/backup/2eld303o_78_1_05 recid=77 stamp=718372985
deleted backup piece
。。。。。。
RMAN> delete expired backup ;
List of Backup Pieces
BP KeyBS KeyPc# Cp# StatusDevice Type Piece Name
------- ------- --- --- ----------- ----------- ----------
76761 1 EXPIRED DISK/backup/2dld3018_77_1_05
77771 1 EXPIRED DISK/backup/2eld303o_78_1_05
78781 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100507-00
79791 1 EXPIRED DISK/backup/2gld5kc3_80_1_05
80801 1 EXPIRED DISK/backup/2hld5kdb_81_1_05
81811 1 EXPIRED DISK/backup/2ild5kfr_82_1_05
82821 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100508-00
83831 1 EXPIRED DISK/backup/2kld88oa_84_1_05
84841 1 EXPIRED DISK/backup/2lld88p7_85_1_05
85851 1 EXPIRED DISK/backup/2mld88rn_86_1_05
86861 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100509-00
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/backup/2dld3018_77_1_05 recid=76 stamp=718372910
deleted backup piece
backup piece handle=/backup/2eld303o_78_1_05 recid=77 stamp=718372985
deleted backup piece
。。。。。。
RMAN> delete expired backup ;
List of Backup Pieces
BP KeyBS KeyPc# Cp# StatusDevice Type Piece Name
------- ------- --- --- ----------- ----------- ----------
76761 1 EXPIRED DISK/backup/2dld3018_77_1_05
77771 1 EXPIRED DISK/backup/2eld303o_78_1_05
78781 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100507-00
79791 1 EXPIRED DISK/backup/2gld5kc3_80_1_05
80801 1 EXPIRED DISK/backup/2hld5kdb_81_1_05
81811 1 EXPIRED DISK/backup/2ild5kfr_82_1_05
82821 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100508-00
83831 1 EXPIRED DISK/backup/2kld88oa_84_1_05
84841 1 EXPIRED DISK/backup/2lld88p7_85_1_05
85851 1 EXPIRED DISK/backup/2mld88rn_86_1_05
86861 1 EXPIRED DISK/u01/app/oracle/product/10/rac/dbs/c-3646897695-20100509-00
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/backup/2dld3018_77_1_05 recid=76 stamp=718372910
deleted backup piece
backup piece handle=/backup/2eld303o_78_1_05 recid=77 stamp=718372985
deleted backup piece
。。。。。。
MAN> delete obsolete ;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> release channel ;
released channel: ORA_MAINT_DISK_1
RMAN> list backupset ;