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

Seeing the LIST EXPIRED BACKUP Command in Action
When you run the CROSSCHECK command (discussed later in this chapter), any missing backup
files will be marked as EXPIRED , meaning that they are no longer on the media where they
are expected to be. The LIST EXPIRED command will show you the backups that are expired.
You can review this list and then use the DELETE command to mark the backup files as deleted
in the control file and the recovery catalog. Here is an example of the LIST EXPIRED BACKUP
command in use:
RMAN> list expired backup of database;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
425 Full 176.72M DISK 00:06:02 11-OCT-13
BP Key: 433 Status: EXPIRED Compressed: YES Tag: TAG20131011T142622
Piece Name: C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2013_10_11\
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
In this case, we have one backup set that is expired. Each backup set has its own unique
backup-set key that you will find in many reports. In this report, the backup-set key 425 is
missing. This backup includes backups of four data files. Since it's expired, this essentially
means it's missing from the database. Expired backups will not show up on this report until
the CROSSCHECK command detects that they are missing. You can find more information on
the CROSSCHECK command later in this chapter. If you want to mark these as deleted in the
recovery catalog, you can use the DELETE EXPIRED command. You can find more information
on the DELETE EXPIRED command later in this chapter.
Seeing the LIST INCARNATION Command in Action
The LIST INCARNATION command provides information related to database incarnation
from the control file or the recovery catalog. You can use this command to guide you in
situations in which you need to reset the database incarnation for certain types of database
recoveries (see Chapter 5, “Recovering Databases with RMAN,” for more on this topic).
The LIST INCARNATION command output is slightly different depending on whether you
are connected to a recovery catalog or the database control file. For example, here is some