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?
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 should be answer.
The command produces an error because the advise failure command was not executed before the REPAIR FAILURE command.
No not correct Vijay:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm
If you execute REPAIR FAILURE with no other command options, then RMAN uses the first repair option of the most recent ADVISE FAILURE command in the current session. The command performs an implicit ADVISE FAILURE if this command has not yet been executed in the current session.
its –> D
WRONG Correct!
Right answer is C
What you said was true in 11g but changed in 12c :
REPAIR FAILURE
Purpose
Use the REPAIR FAILURE command to repair database failures identified by the Data Recovery Advisor.
The recommended workflow is to run LIST FAILURE to display failures, ADVISE FAILURE to display repair options, and REPAIR FAILURE to fix the failures.
Prerequisites
The target database instance must be started. The database must be a single-instance database and must not be a physical standby database.
Ensure that only one RMAN session is running the REPAIR FAILURE command. The only exception is REPAIR FAILURE … PREVIEW, which is permitted in concurrent RMAN sessions.
To perform an automated repair, the Data Recovery Advisor may require specific backups and archived redo log files. If the files needed for recovery are not available, then recovery is not possible.
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:
see here – http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199
Thanks Vonpire. i cleared the 067 exam.This forum helped me immensely in clearing the exam.
Guys(Vonpire,Tri,Steve) your knowledge is commendable.
C
You receive the following error:
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
C
I dont think its C, I dont think its mandatory to execute the ADVISE failure command before the repair command becuase I cant find anywhere which they state its mandatory..
Oracle:
The recommended workflow is to run LIST FAILURE to display failures, ADVISE FAILURE to display repair options, and REPAIR FAILURE to fix the failures.
Note recommended.
Than when you go to the REPAIR FAILURE command i see the following:
Repairs failures recorded in the Automated Diagnostic Repository.
If you execute REPAIR FAILURE with no other command options, then RMAN uses the first repair option of the most recent ADVISE FAILURE command in the current session. The command performs an implicit ADVISE FAILURE if this command has not yet been executed in the current session.
So its saying that if the ADVISE FAILURE not has been executed at all it will be automatically executed within the REPAIR FAILURE command.
Can anyone explain??
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta033.htm
You gave link to old documentation, maybe there is wrong.
What I found in 12c documentation is this sentence:
Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session to successfully repair each of the identified failures.
See: http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199
I don’t know, this is quite tricky, it should be C, as I tested by connecting to CDB and only command to execute was REPAIR FAILURE and I received this error:
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
Also it didn’t run ADVISE FAILURE implicitly.
So I would say C is the right answer.
C => Vonpire PDF is newest I found!
http://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199
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 everybody,
I think it is A or D but 75% I would say A is the right answer
The following why i think C is not the right answer from 12c Backup and Recovery Guide
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
What do you think is the right answer A or D?
It’s true in 11g but NOT in 12c
12c Documentation:
“Be advised that REPAIR FAILURE requires you to explicitly run ADVISE FAILURE in the current session to successfully repair each of the identified failures.”
https://docs.oracle.com/database/121/RCMRF/rcmsynta2004.htm#RCMRF199
The correct answer is “C”.
Mohamed you find the docs is
“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”.” but i tested. It’s not like the docs stated:
RMAN> list failure;
using target database control file instead of recovery catalog
Database Role: PRIMARY
List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
———- ——– ——— ————- ——-
62 HIGH OPEN 04-MAR-16 One or more non-system datafiles are missing
RMAN> repair failure;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of repair command at 03/04/2016 05:16:04
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
RMAN>
A, D all not true. The question is terrible wrong.
Hi Guys,
You said correct, in a given session you have to fire “REPAIR FAILURE”, mandatory preceded by “ADVICE FAILURE”. Else it will land up with,
RMAN-06954: REPAIR command must be preceded by ADVISE command in same session
This error is registered in ORACLE 12c as well. For your reference,
http://oradb-srv.wlv.ac.uk/E50529_01/ERRMG/rmanus.htm
Hence, correct answer is C
C