Database Reference
In-Depth Information
\O1_MF_NNNDF_TAG20131011T142622_4H22ZOMK_.BKP
List of Datafiles in backup set 425
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 903859 11-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 Full 903859 11-OCT-13 C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
3 Full 903859 11-OCT-13 C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
4 Full 903859 11-OCT-13 C:\ORACLE\ORADATA\ORCL\USERS01.DBF
RMAN> delete expired backup;
Allocated channel ORA_DISK_1
Channel ORA_DISK_1: SID=186 device type=DISK
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
433 425 1 1 EXPIRED DISK
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_11
\O1_MF_NNNDF_TAG20131011T142622_4H22ZOMK_.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_11\
O1_MF_NNNDF_TAG20131011T142622_4H22ZOMK_.BKP RECID=2 STAMP=667837589
Deleted 1 EXPIRED objects
One important thing to note is that once you have marked a backup set with a
DELETED
status, that status cannot be changed. Thus, if you ever needed to restore that backup set
piece, you would have to use the
CATALOG
command to reimport it into the database control
file and recovery catalog (assuming it was still available).
Using the
CROSSCHECK
Command
The
CROSSCHECK
command is used to validate RMAN records in the database control file
and the recovery catalog against what is physically on the backup media. The
CROSSCHECK
command can be used on both disk backups and tape backups. In this example, we are
using it to validate that all the backup set pieces recorded in the control file of our database
are actually on the media where they are supposed to be:
RMAN> crosscheck backup of database;
using channel ORA_DISK_1
crosschecked backup piece: found to be EXPIRED'
backup piece handle=C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_18
\O1_MF_NNNDF_TAG20131018T152908_4HNO9DX9_.BKP RECID=27 STAMP=668446156
Crosschecked 1 objects
Search WWH ::
Custom Search