Saturday, May 24, 2025

How delete obsolete rman backup ?

 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

-------------------- ------ ------------------ --------------------

Archive Log          1      06-MAR-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_03_06/o1_mf_1_6_mwm73otb_.arc

Backup Set           1      06-MAR-25

  Backup Piece       1      06-MAR-25          /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_03_06/o1_mf_s_1195045112_mwm6zsr4_.bkp

Archive Log          2      22-MAR-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_03_22/o1_mf_1_7_mxwwwloz_.arc

Archive Log          3      28-APR-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_04_28/o1_mf_1_8_n0y2ykq0_.arc

Archive Log          4      29-APR-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_04_29/o1_mf_1_9_n10thgfr_.arc

Backup Set           2      29-APR-25

  Backup Piece       2      29-APR-25          /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199689267_n10y9nxy_.bkp

Backup Set           3      29-APR-25

  Backup Piece       3      29-APR-25          /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199689871_n10ywkbc_.bkp

Archive Log          5      30-APR-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_04_30/o1_mf_1_10_n13lcxjj_.arc

Backup Set           4      29-APR-25

  Backup Piece       4      29-APR-25          /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199690476_n10zhg00_.bkp

Archive Log          6      01-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_01/o1_mf_1_11_n162t9hh_.arc

Archive Log          7      21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_12_n2v9ht9q_.arc

Archive Log          8      21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_13_n2vbzlxk_.arc

Archive Log          9      21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_14_n2vbznnl_.arc

Archive Log          10     21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_15_n2vbzzdo_.arc

Archive Log          11     21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_16_n2vhpmo0_.arc

Backup Set           5      21-MAY-25

  Backup Piece       5      21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201689578_n2vccdph_.bkp

Backup Set           10     21-MAY-25

  Backup Piece       10     21-MAY-25          /u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201695424_n2vk22pc_.bkp


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

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_03_06/o1_mf_1_6_mwm73otb_.arc RECID=1 STAMP=1195045240

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_03_06/o1_mf_s_1195045112_mwm6zsr4_.bkp RECID=1 STAMP=1195045113

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_03_22/o1_mf_1_7_mxwwwloz_.arc RECID=2 STAMP=1196411027

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_04_28/o1_mf_1_8_n0y2ykq0_.arc RECID=3 STAMP=1199595729

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_04_29/o1_mf_1_9_n10thgfr_.arc RECID=4 STAMP=1199685359

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199689267_n10y9nxy_.bkp RECID=2 STAMP=1199689268

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199689871_n10ywkbc_.bkp RECID=3 STAMP=1199689873

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_04_30/o1_mf_1_10_n13lcxjj_.arc RECID=5 STAMP=1199775359

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_04_29/o1_mf_s_1199690476_n10zhg00_.bkp RECID=4 STAMP=1199690477

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_01/o1_mf_1_11_n162t9hh_.arc RECID=6 STAMP=1199944138

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_12_n2v9ht9q_.arc RECID=7 STAMP=1201687679

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_13_n2vbzlxk_.arc RECID=8 STAMP=1201689203

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_14_n2vbznnl_.arc RECID=9 STAMP=1201689204

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_15_n2vbzzdo_.arc RECID=10 STAMP=1201689215

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/DB1/archivelog/2025_05_21/o1_mf_1_16_n2vhpmo0_.arc RECID=11 STAMP=1201694035

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201689578_n2vccdph_.bkp RECID=5 STAMP=1201689580

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201695424_n2vk22pc_.bkp RECID=10 STAMP=1201695426

Deleted 17 objects



RMAN>

No comments:

Post a Comment