Using the LIST command in Recovery Manager (RMAN), which two pieces of information in
the RMAN repository can be listed? (Choose two.)
A.
stored scripts in the recovery catalog
B.
backups that can be deleted from disk
C.
backup sets and image copies are obsolete
D.
backups that do not have the AVAILABLE status in the RMAN repository
Explanation:
About the LIST command
The primary purpose of the LIST command is to list backup and copies. For example, you
can list:
Backups and proxy copies of a database, tablespace, data file, archived redo log, or control
file
Backups that have expired
Backups restricted by time, path name, device type, tag, or recoverability
Archived redo log files and disk copies
Besides backups and copies, RMAN can list other types of data. For example, you can list:
Backup sets and proxy copies
Image copies
Archived redo log files
Database incarnations
Databases in a Data Guard environmentBackups and copies for a primary or standby database in a Data Guard environment
Restore points
Names of stored scripts
Failures for use with Data Recovery Advisor
not AVAILABLE = EXPIRED
and you can do a
LIST EXPIRED …
A and D are correct:
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm
Table 10-2 Most Common LIST Options
LIST Option Description
LIST EXPIRED
Lists backups or copies that are recorded in the RMAN repository but that were not present at the expected location on disk or tape during the most recent crosscheck. Such backups may have been deleted outside of RMAN.
LIST … BY FILE
Lists backups of each datafile, archived redo log file, control file, and server parameter file. Each row describes a backup of a file.
LIST … SUMMARY
Provides a one-line summary of each backup.
Agree with Eamon