Databases Reference
In-Depth Information
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Incr 1 17.11M DISK 00:00:02 21-JUL-12
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20120721T183841
Piece Name: +FRA/cdb1/backupset/2012_07_21/ncsnn1_tag20120721t183841_0.261.789244779
SPFILE Included: Modification time: 21-JUL-12
SPFILE db_unique_name: CDB1
Control File Included: Ckp SCN: 2196567 Ckp time: 21-JUL-12
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 80.00K DISK 00:00:01 02-AUG-12
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20120802T215514
Piece Name: +FRA/cdb1/backupset/2012_08_02/nnsnf0_tag20120802t215514_0.267.790293387
SPFILE Included: Modification time: 02-AUG-12
SPFILE db_unique_name: CDB1
2.
Now, to delete a backup set, let's say number 7, issue a
delete backupset
command:
RMAN> delete backupset 7;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
7 7 1 1 AVAILABLE DISK +FRA/cdb1/backupset/2012_08_02/nnsnf0_tag20120802t21
5514_0.267.790293387
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=+FRA/cdb1/backupset/2012_08_02/nnsnf0_tag20120802t215514_0.267.790293387
RECID=7 STAMP=790293386
Deleted 1 objects
The backup set is now removed.
3.
If you want to delete a backup set without being prompted for confirmation issue a
delete
noprompt backupset
command.
How It Works
This process is no different than deleting the backup sets from any other location. When you give a
delete backupset
command, RMAN knows about all the available backup sets and deletes the one specified by the user. However,
please note that RMAN must know about the existence of the backup set. If the backup set is removed from the RMAN
metadata, then RMAN does not know about it, and the delete operation will not work.
