DELETE BACKUP

Verifica dei backup effettuati

RMAN> list backup of database;

Per cancellare tutti i backup del container e dei pdb fare

RMAN> delete backup;

oppure

RMAN> delete noprompt backup;

oppure

RMAN> delete backup TAG 'tag_name';

Per quanto riguada uno specifico PDB

RMAN> list backup of database orclpdb;

using target database control file instead of recovery catalog

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

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

34      Full    844.49M    DISK        00:00:02     14-DEC-20

        BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20201214T163309

        Piece Name: /u01/app/oracle/fast_recovery_area/ORCL/AE3ED9EC84541FB8E053C58E670AB441/backupset/2020_12_14/o1_mf_nnndf_TAG20201214T163309_hxh1fo7o_.bkp

  List of Datafiles in backup set 34

  Container ID: 3, PDB Name: ORCLPDB

  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name

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

  9       Full 12899824   14-DEC-20              NO    /u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf

  10      Full 12899824   14-DEC-20              NO    /u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf

  11      Full 12899824   14-DEC-20              NO    /u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf

  12      Full 12899824   14-DEC-20              NO    /u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf

  84      Full 12899824   14-DEC-20              NO    /u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf

Nell'esempio c'è il backupset BS 34 quindi per cancellarlo basta usare il comando 

RMAN> delete backupset 34;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=56 device type=DISK

List of Backup Pieces

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

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

34      34      1   1   AVAILABLE   DISK        /u01/app/oracle/fast_recovery_area/ORCL/AE3ED9EC84541FB8E053C58E670AB441/backupset/2020_12_14/o1_mf_nnndf_TAG20201214T163309_hxh1fo7o_.bkp

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

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/ORCL/AE3ED9EC84541FB8E053C58E670AB441/backupset/2020_12_14/o1_mf_nnndf_TAG20201214T163309_hxh1fo7o_.bkp RECID=34 STAMP=1059150789

Deleted 1 objects

Verifica

RMAN> list backup of database orclpdb;

specification does not match any backup in the repository