Using the LIST command in Recovery Manager (RMAN), which two pieces of information from 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 images copies that are obsolete
D.
Backups that do not have the AVAILABLE status in the RMAN repository
Explanation:
Prerequisites
Execute LIST only at the RMAN prompt. Either of the following conditions must be met:
– RMAN must be connected to a target database. If RMAN is not connected to a recovery catalog,
and if
you are not executing the LIST FAILURE command, then the target database must be mounted or
open. If RMAN is connected to a recovery catalog, then the target database instance must be
started.
– RMAN must be connected to a recovery catalog and SET DBID must have been run.
Usage Notes
With the exception of LIST FAILURE, the LIST command displays the backups and copies against
which you can run CROSSCHECK and DELETE commands. The LIST FAILURE command
displays failures against which you can run the ADVISE FAILURE and REPAIR FAILURE
commands.
“RMAN Backups in a Data Guard Environment” explains how RMAN handles backups in a Data
Guard environment. In general, RMAN considers tape backups created on one database in the
environment as accessible to all databases in the environment, whereas disk backups are
accessible only to the database that created them. In a Data Guard environment, LIST displays
those files that are accessible to the connected target database. RMAN prints the LIST output to
either standard output or the message log, but not to both at the same time.
Oracle Press 1Z0-053 Exam Guide, Chapter 4: Creating RMAN Backups
The LIST command displays information about backupsets and image copies in the repository and
can also store the contents of scripts stored in the repository catalog.
Another variation on the LIST command is LIST FAILURE, which displays database failures; LIST
FAILURE, ADVISE FAILURE, and REPAIR FAILURE