Which statement describes the consequence of the command?

You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_1 and pdb_2.While opening pdb_1, you get an error:SQL> alter pluggable database pdb_1 open;ORA-01157: cannot identify/lock data file 11-see DBWR trace fileORA-01110:data file 11:’/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf’To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:RMAN>REPAIR FAILURE;Which statement describes the consequence of the command?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; http://docs.oracle.com/database/121/RCMRF/ rcmsynta2004.htm#RCMRF199

Question:

Which statement describes the consequence of the command?

Options:

The command performs the recovery and closes the failure.

The command produces an error because RMAN is not connected to the target database pdb_1.

The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.

The command executes successfully, performs recovery, and opens PDB_1.

Correct Answer

The Correct Answer for this Question is

The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *