1Z0-067 · Question #39
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…
The correct answer is C. The command produces an error because the advise failure command was not executed before. 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…
Question
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:
SQL> alter pluggable database pdb_1 open; ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile ORA-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 CDBSROOT. You execute the following as the first command:
RMAN>REPAIRFAILURE; Which statement describes the consequence of the command?
Options
- AThe command performs the recovery and closes the failure.
- BThe command produces an error because RMAN is not connected to the target database pdb_1.
- CThe command produces an error because the advise failure command was not executed before
- DThe command executes successfully, performs recovery, and opens PDB_1.
How the community answered
(32 responses)- A16% (5)
- B9% (3)
- C72% (23)
- D3% (1)
Explanation
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; - ADVISE FAILURE; - REPAIR FAILURE;
Topics
Community Discussion
No community discussion yet for this question.