RMAN DELETE EXPIRED NOPROMPT

RMAN> delete noprompt expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1       1       1   1   EXPIRED     DISK        /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194619_frcv6wdw_.bkp
2       2       1   1   EXPIRED     DISK        /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_nnndf_TAG20180828T194623_frcv709n_.bkp
3       3       1   1   EXPIRED     DISK        /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194929_frcvdssr_.bkp
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194619_frcv6wdw_.bkp RECID=1 STAMP=985376780
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_nnndf_TAG20180828T194623_frcv709n_.bkp RECID=2 STAMP=985376784
deleted backup piece
backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_08_28/o1_mf_annnn_TAG20180828T194929_frcvdssr_.bkp RECID=3 STAMP=985376969
Deleted 3 EXPIRED objects


RMAN> delete noprompt expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    6       X 20-FEB-16
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_6_frcv6t05_.arc

2       1    7       X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_7_frcvds9r_.arc

3       1    8       X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_8_frcz7jfr_.arc

4       1    9       X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_9_frcz7ntb_.arc

5       1    10      X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_10_frcz7s4s_.arc

6       1    11      X 28-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_30/o1_mf_1_11_frjys12v_.arc

7       1    12      X 30-AUG-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_12_fro2zcbg_.arc

8       1    13      X 01-SEP-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_13_fro33gkq_.arc

9       1    14      X 01-SEP-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_14_fro3xqsf_.arc

10      1    15      X 01-SEP-18
        Name: /u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_15_fro42vcv_.arc

deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_6_frcv6t05_.arc RECID=1 STAMP=985376779
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_7_frcvds9r_.arc RECID=2 STAMP=985376969
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_8_frcz7jfr_.arc RECID=3 STAMP=985380896
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_9_frcz7ntb_.arc RECID=4 STAMP=985380900
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_28/o1_mf_1_10_frcz7s4s_.arc RECID=5 STAMP=985380905
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_08_30/o1_mf_1_11_frjys12v_.arc RECID=6 STAMP=985544273
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_12_fro2zcbg_.arc RECID=7 STAMP=985679647
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_13_fro33gkq_.arc RECID=8 STAMP=985679778
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_14_fro3xqsf_.arc RECID=9 STAMP=985680617
deleted archived log
archived log file name=/u01/app/oracle/fast_recovery_area/ORCL/archivelog/2018_09_01/o1_mf_1_15_fro42vcv_.arc RECID=10 STAMP=985680779
Deleted 10 EXPIRED objects

RMAN> delete expired backup;

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=49 device type=DISK

List of Backup Pieces

BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name

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

64      64      1   1   EXPIRED     DISK        /u01/backup/22v4t31i_1_1

66      66      1   1   EXPIRED     DISK        /u01/backup/26v4t3je_1_1

67      66      1   2   EXPIRED     DISK        /u01/backup/26v4t3je_1_2

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

deleted backup piece

backup piece handle=/u01/backup/22v4t31i_1_1 RECID=64 STAMP=1045335091

deleted backup piece

backup piece handle=/u01/backup/26v4t3je_1_1 RECID=66 STAMP=1045335662

deleted backup piece

backup piece handle=/u01/backup/26v4t3je_1_2 RECID=67 STAMP=1045335662

Deleted 3 EXPIRED objects

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=49 device type=DISK

specification does not match any archived log in the repository

RMAN>