OBSOLETE :
RMAN> report obsolete; -----------> reports all the Obsolete backups that are not required.
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 20-DEC-17
Backup Piece 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp
Archive Log 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/archivelog/2017_12_20/o1_mf_1_5_f3n7h224_.arc
Backup Set 2 20-DEC-17
Backup Piece 2 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp
Backup Set 3 20-DEC-17
Backup Piece 3 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.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 20-DEC-17
Backup Piece 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp
Archive Log 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/archivelog/2017_12_20/o1_mf_1_5_f3n7h224_.arc
Backup Set 2 20-DEC-17
Backup Piece 2 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp
Backup Set 3 20-DEC-17
Backup Piece 3 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp RECID=1 STAMP=963236979
deleted archived log
archived log file name=/u01/app/oraclebase/fast_recovery_area/TESTDB2/archivelog/2017_12_20/o1_mf_1_5_f3n7h224_.arc RECID=1 STAMP=963237178
deleted backup piece
backup piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp RECID=2 STAMP=963237037
deleted backup piece
backup piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.bkp RECID=3 STAMP=963237179
Deleted 4 objects
RMAN> report obsolete; -----------> reports all the Obsolete backups that are not required.
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 20-DEC-17
Backup Piece 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp
Archive Log 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/archivelog/2017_12_20/o1_mf_1_5_f3n7h224_.arc
Backup Set 2 20-DEC-17
Backup Piece 2 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp
Backup Set 3 20-DEC-17
Backup Piece 3 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.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 20-DEC-17
Backup Piece 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp
Archive Log 1 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/archivelog/2017_12_20/o1_mf_1_5_f3n7h224_.arc
Backup Set 2 20-DEC-17
Backup Piece 2 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp
Backup Set 3 20-DEC-17
Backup Piece 3 20-DEC-17 /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.bkp
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T134938_f3n78vhm_.bkp RECID=1 STAMP=963236979
deleted archived log
archived log file name=/u01/app/oraclebase/fast_recovery_area/TESTDB2/archivelog/2017_12_20/o1_mf_1_5_f3n7h224_.arc RECID=1 STAMP=963237178
deleted backup piece
backup piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T134938_f3n7bodf_.bkp RECID=2 STAMP=963237037
deleted backup piece
backup piece handle=/u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135258_f3n7h3w3_.bkp RECID=3 STAMP=963237179
Deleted 4 objects
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 1.07G DISK 00:00:57 20-DEC-17
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135301
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_nnndf_TAG20171220T135301_f3n7h5k2_.bkp
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/system01.dbf
2 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/sysaux01.dbf
3 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/undotbs01.dbf
4 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/users01.dbf
5 Full 1011726 20-DEC-17 /u01/app/oraclebase/oradata/testdb2/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 9.36M DISK 00:00:04 20-DEC-17
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135301
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_ncsnf_TAG20171220T135301_f3n7k9sv_.bkp
SPFILE Included: Modification time: 20-DEC-17
SPFILE db_unique_name: TESTDB2
Control File Included: Ckp SCN: 1011748 Ckp time: 20-DEC-17
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6 2.50K DISK 00:00:00 20-DEC-17
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20171220T135411
Piece Name: /u01/app/oraclebase/fast_recovery_area/TESTDB2/backupset/2017_12_20/o1_mf_annnn_TAG20171220T135411_f3n7kcp0_.bkp
List of Archived Logs in backup set 6
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6 1011720 20-DEC-17 1011754 20-DEC-17
No comments:
Post a Comment