You are administering a multitenant container database (CDB) cdb1 that is running in
archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2. While
opening pdb_1, you get an error: Exhibit: To repair the failure, you open an RMAN session
for the target database CDBSROOT. You execute the following as the first command:
RMAN>REPAIRFAILURE; Which statement describes the consequence of the command?
A.
The command performs the recovery and closes the failure.
B.
The command produces an error because RMAN is not connected to the target database
pdb_1.
C.
The command produces an error because the advise failure command was not executed
before the REPAIRFAILUER command.
D.
The command executes successfully, performs recovery, and opens PDB_1.
C
Usage Notes
Repairs are consolidated whenever possible so that a single repair can fix multiple failures. Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session to successfully repair each of the identified failures. You typically iterate through a REPAIR session with the following commands:
REPAIR FAILURE;
LIST FAILURE;
ADVISE FAILURE;
REPAIR FAILURE;
Hi Peter,
It’s not correct, I think the right answer is A and the following why i see C is not the correct answer:
The REPAIR FAILURE command is used after an ADVISE FAILURE command within the
same RMAN session. By default, the command uses the single, recommended repair option of the last ADVISE FAILURE execution in the current session. If none exists, the REPAIR FAILURE command initiates an implicit ADVISE FAILURE command. After completing the repair, the command closes the failure.
Reference:
Oracle Database 12c: Backup and Recovery Workshop 9 – 15
Thanks,
Mohamed
A – The command performs an implicit ADVISE FAILURE if this command has not yet been executed in the current session.
C is the correct answer.
C
Implicit ADVISE FAILURE command only if none exists after last ADVISE FAILURE execution in the current session.