Oracle Database 12c: Advanced Administration — Question 7

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?

Answer options

• A. It lists failures only for the CDB root database.
• B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.
• C. It lists failures for the CDB and all the PDBs in this CDB.
• D. It lists failures only if RMAN is connected to a PDB.

Correct answer: A

Explanation

The correct answer is A because the 'LIST FAILURE' command, when executed while connected to CDB$ROOT, only reports failures related to the root database itself. The other options are incorrect as they misstate the command's scope and connection requirements.