+++++++++++++++++++++++++++++++++++++++++++++++++++++
How to find which backup files can be deleted in rman?
++++++++++++++++++++++++++++++++++++++++++++++++++++++
[oracle@wasiq ~]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jan 10 22:33:22 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: PROD (DBID=246965557)
RMAN>
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
-------------------- ------ ------------------ --------------------
Backup Set 4 27-DEC-13
Backup Piece 4 27-DEC-13 /backup/rman/prod/c-246965557-20131227-01
Backup Set 6 27-DEC-13
Backup Piece 6 27-DEC-13 /backup/rman/prod/c-246965557-20131227-02
Backup Set 8 27-DEC-13
Backup Piece 8 27-DEC-13 /backup/rman/prod/c-246965557-20131227-03
Backup Set 10 27-DEC-13
Backup Piece 10 27-DEC-13 /backup/rman/prod/c-246965557-20131227-04
Backup Set 12 27-DEC-13
Backup Piece 12 27-DEC-13 /backup/rman/prod/c-246965557-20131227-05
Backup Set 14 27-DEC-13
Backup Piece 14 27-DEC-13 /backup/rman/prod/c-246965557-20131227-06
Backup Set 15 27-DEC-13
Backup Piece 15 27-DEC-13 /backup/rman/prod/PROD_DB_0fosjonf_15_1
Backup Set 16 27-DEC-13
Backup Piece 16 27-DEC-13 /backup/rman/prod/PROD_DB_0gosjoni_16_1
Backup Set 17 27-DEC-13
Backup Piece 17 27-DEC-13 /backup/rman/prod/PROD_DB_0hosjooc_17_1
Backup Set 18 27-DEC-13
Backup Piece 18 27-DEC-13 /backup/rman/prod/c-246965557-20131227-07
Backup Set 19 28-DEC-13
Backup Piece 19 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0josm4s5_s19_p1_t835392389_db
Backup Set 22 28-DEC-13
Backup Piece 22 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0kosm4s6_s20_p1_t835392390_db
Backup Set 23 28-DEC-13
Backup Piece 23 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0losm4s6_s21_p1_t835392390_db
Backup Set 21 28-DEC-13
Backup Piece 21 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0mosm4s6_s22_p1_t835392390_db
Backup Set 20 28-DEC-13
Backup Piece 20 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0nosm4s6_s23_p1_t835392390_db
Backup Set 24 28-DEC-13
Backup Piece 24 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0oosm4tk_s24_p1_t835392436_db
Backup Set 25 28-DEC-13
Backup Piece 25 28-DEC-13 /backup/rman/prod/c-246965557-20131228-00
Backup Set 26 28-DEC-13
Backup Piece 26 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/Control_bk_u0qosm4tn_s26_p1_t835392439_bk
Backup Set 27 28-DEC-13
Backup Piece 27 28-DEC-13 /backup/rman/prod/c-246965557-20131228-01
Backup Set 29 30-DEC-13
Backup Piece 29 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-00
Backup Set 31 30-DEC-13
Backup Piece 31 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-01
Backup Set 34 30-DEC-13
Backup Piece 34 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-02
Backup Set 38 30-DEC-13
Backup Piece 38 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-03
Backup Set 40 30-DEC-13
Backup Piece 40 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-04
Backup Set 41 30-DEC-13
Backup Piece 41 30-DEC-13 /d04/oracle/db_1dosr957_1_1.bck
Backup Set 42 30-DEC-13
Backup Piece 42 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-05
Backup Set 44 30-DEC-13
Backup Piece 44 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-06
Backup Set 45 30-DEC-13
Backup Piece 45 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_annnn_TAG20131230T205254_9d33ygf8_.bkp
Backup Set 46 30-DEC-13
Backup Piece 46 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_nnndf_TAG20131230T205255_9d33yhoz_.bkp
Archive Log 12 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_30/o1_mf_1_14_9d33yjqw_.arc
Backup Set 47 30-DEC-13
Backup Piece 47 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_annnn_TAG20131230T205256_9d33yjvs_.bkp
Datafile Copy 2 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/datafile/o1_mf_sysaux_9d34c0wd_.dbf
Backup Set 48 30-DEC-13
Backup Piece 48 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-07
Backup Set 49 30-DEC-13
Backup Piece 49 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-08
Backup Set 51 01-JAN-14
Backup Piece 51 01-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140101-00
Backup Set 53 01-JAN-14
Backup Piece 53 01-JAN-14 /d01/oracle/flash_recovery_area/PROD/backupset/2014_01_01/o1_mf_nnndf_TAG20140101T092010_9d743lot_.bkp
Backup Set 55 01-JAN-14
Backup Piece 55 01-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140101-01
Backup Set 57 01-JAN-14
Backup Piece 57 01-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140101-02
Backup Set 58 05-JAN-14
Backup Piece 58 05-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140105-00
Backup Set 59 10-JAN-14
Backup Piece 59 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-00
Backup Set 60 10-JAN-14
Backup Piece 60 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-01
Backup Set 61 10-JAN-14
Backup Piece 61 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-02
Backup Set 62 10-JAN-14
Backup Piece 62 10-JAN-14 /d01/oracle/flash_recovery_area/PROD/backupset/2014_01_10/o1_mf_nnsnf_TAG20140110T211622_9f05ggz1_.bkp
Backup Set 63 10-JAN-14
Backup Piece 63 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-03
RMAN>
How to find which backup files can be deleted in rman?
++++++++++++++++++++++++++++++++++++++++++++++++++++++
[oracle@wasiq ~]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jan 10 22:33:22 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target /;
connected to target database: PROD (DBID=246965557)
RMAN>
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
-------------------- ------ ------------------ --------------------
Backup Set 4 27-DEC-13
Backup Piece 4 27-DEC-13 /backup/rman/prod/c-246965557-20131227-01
Backup Set 6 27-DEC-13
Backup Piece 6 27-DEC-13 /backup/rman/prod/c-246965557-20131227-02
Backup Set 8 27-DEC-13
Backup Piece 8 27-DEC-13 /backup/rman/prod/c-246965557-20131227-03
Backup Set 10 27-DEC-13
Backup Piece 10 27-DEC-13 /backup/rman/prod/c-246965557-20131227-04
Backup Set 12 27-DEC-13
Backup Piece 12 27-DEC-13 /backup/rman/prod/c-246965557-20131227-05
Backup Set 14 27-DEC-13
Backup Piece 14 27-DEC-13 /backup/rman/prod/c-246965557-20131227-06
Backup Set 15 27-DEC-13
Backup Piece 15 27-DEC-13 /backup/rman/prod/PROD_DB_0fosjonf_15_1
Backup Set 16 27-DEC-13
Backup Piece 16 27-DEC-13 /backup/rman/prod/PROD_DB_0gosjoni_16_1
Backup Set 17 27-DEC-13
Backup Piece 17 27-DEC-13 /backup/rman/prod/PROD_DB_0hosjooc_17_1
Backup Set 18 27-DEC-13
Backup Piece 18 27-DEC-13 /backup/rman/prod/c-246965557-20131227-07
Backup Set 19 28-DEC-13
Backup Piece 19 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0josm4s5_s19_p1_t835392389_db
Backup Set 22 28-DEC-13
Backup Piece 22 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0kosm4s6_s20_p1_t835392390_db
Backup Set 23 28-DEC-13
Backup Piece 23 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0losm4s6_s21_p1_t835392390_db
Backup Set 21 28-DEC-13
Backup Piece 21 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0mosm4s6_s22_p1_t835392390_db
Backup Set 20 28-DEC-13
Backup Piece 20 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0nosm4s6_s23_p1_t835392390_db
Backup Set 24 28-DEC-13
Backup Piece 24 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/PROD_db_u0oosm4tk_s24_p1_t835392436_db
Backup Set 25 28-DEC-13
Backup Piece 25 28-DEC-13 /backup/rman/prod/c-246965557-20131228-00
Backup Set 26 28-DEC-13
Backup Piece 26 28-DEC-13 /backup/rman/prod/28dec2013_fullbkp/Control_bk_u0qosm4tn_s26_p1_t835392439_bk
Backup Set 27 28-DEC-13
Backup Piece 27 28-DEC-13 /backup/rman/prod/c-246965557-20131228-01
Backup Set 29 30-DEC-13
Backup Piece 29 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-00
Backup Set 31 30-DEC-13
Backup Piece 31 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-01
Backup Set 34 30-DEC-13
Backup Piece 34 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-02
Backup Set 38 30-DEC-13
Backup Piece 38 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-03
Backup Set 40 30-DEC-13
Backup Piece 40 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-04
Backup Set 41 30-DEC-13
Backup Piece 41 30-DEC-13 /d04/oracle/db_1dosr957_1_1.bck
Backup Set 42 30-DEC-13
Backup Piece 42 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-05
Backup Set 44 30-DEC-13
Backup Piece 44 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-06
Backup Set 45 30-DEC-13
Backup Piece 45 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_annnn_TAG20131230T205254_9d33ygf8_.bkp
Backup Set 46 30-DEC-13
Backup Piece 46 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_nnndf_TAG20131230T205255_9d33yhoz_.bkp
Archive Log 12 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/archivelog/2013_12_30/o1_mf_1_14_9d33yjqw_.arc
Backup Set 47 30-DEC-13
Backup Piece 47 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/backupset/2013_12_30/o1_mf_annnn_TAG20131230T205256_9d33yjvs_.bkp
Datafile Copy 2 30-DEC-13 /d01/oracle/flash_recovery_area/PROD/datafile/o1_mf_sysaux_9d34c0wd_.dbf
Backup Set 48 30-DEC-13
Backup Piece 48 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-07
Backup Set 49 30-DEC-13
Backup Piece 49 30-DEC-13 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20131230-08
Backup Set 51 01-JAN-14
Backup Piece 51 01-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140101-00
Backup Set 53 01-JAN-14
Backup Piece 53 01-JAN-14 /d01/oracle/flash_recovery_area/PROD/backupset/2014_01_01/o1_mf_nnndf_TAG20140101T092010_9d743lot_.bkp
Backup Set 55 01-JAN-14
Backup Piece 55 01-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140101-01
Backup Set 57 01-JAN-14
Backup Piece 57 01-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140101-02
Backup Set 58 05-JAN-14
Backup Piece 58 05-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140105-00
Backup Set 59 10-JAN-14
Backup Piece 59 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-00
Backup Set 60 10-JAN-14
Backup Piece 60 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-01
Backup Set 61 10-JAN-14
Backup Piece 61 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-02
Backup Set 62 10-JAN-14
Backup Piece 62 10-JAN-14 /d01/oracle/flash_recovery_area/PROD/backupset/2014_01_10/o1_mf_nnsnf_TAG20140110T211622_9f05ggz1_.bkp
Backup Set 63 10-JAN-14
Backup Piece 63 10-JAN-14 /d01/oracle/product/11.2.0/dbs/cfc-246965557-20140110-03
RMAN>
No comments:
Post a Comment