Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 256

exeRCiSe 6.2 (continued)
BP Key: 1348 Status: EXPIRED Compressed: YES Tag: TAG20131018T163034
Piece Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18
\O1_MF_NNNDF_TAG20131018T163034_4HNRWKVC_.BKP
List of Datafiles in backup set 1342
File LV Type Ckp SCN Ckp Time Name
---- -- ---- -------- --------- ----
1 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
3 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
4 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\USERS01.DBF
5 Full 1224452 18-OCT-13 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF
7. Finally, mark the backup set piece as deleted by using the DELETE EXPIRED BACKUP
command. You will need to respond when prompted to verify that you want to delete
the backup set piece:
RMAN> delete expired backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1348 1342 1 1 EXPIRED DISK C:\ORACLE\FAST_RECOVERY_AREA\
ORCL\BACKUPSET\2013_10_18
\O1_MF_NNNDF_TAG20131018T163034_4HNRWKVC_.BKP
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\
2013_10_18\O1_MF_NNNDF_TAG20131018T163034_4HNRWKVC_.BKP RECID=33
STAMP=668449841
Deleted 1 EXPIRED objects
Monitoring, Administering,
and Tuning RMAN
For the OCP exam, you will be expected to know a little bit about how to monitor RMAN
operations. The exam will also test your knowledge of RMAN administration and tuning
options. In the following sections, we will address all of these items.