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

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle 19c to PostgreSQL 15 Migration: Step-by-Step Production Guide (Ora2Pg + DMS)

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...