Friday 10 January 2014

How to find which backup files can be deleted in 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> 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>

No comments:

Post a Comment