Exam 1z0-083 All QuestionsBrowse all questions from this exam
Go to Exam
Question 53

Examine this configuration:

While CDB1 is open, `˜/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.

To recover from this critical failure, you execute these commands:

What will be the outcome?

    Correct Answer: C

    In this scenario, the commands provided to restore the controlfile from an intact multiplexed location should correctly re-create the deleted controlfile at its original location, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'. The restore command in RMAN is used to restore a controlfile to its original state, thus it will attempt to re-create the removed controlfile in its original location. Therefore, option C is the correct answer.

Discussion
niabsOption: C

Agree with C

AldridOption: C

C - Correct

HacketOption: C

C- Correct

hilaireOption: C

C correct

jonsnoowOption: A

I don't think C is the right answer here. In this scenario I think we must either copy the good control file that we have available to the missing control file location or modify the control_files parameter in the initialization file or spfile to remove the lost control file information from spfile/pfile.

jonsnoow

See table Table 30-1 : "If You Lose one copy of a multiplexed control file - Copy an intact multiplexed control file into the location of the damaged or missing control file and open the database. If you cannot copy the control file to its original location, then edit the initialization parameter file to reflect a new location or remove the damaged control file. Then, open the database." https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/user-managed-flashback-dbpitr.html#GUID-D71F3FF3-84E5-4D81-9307-E2AD5CB51833

jonsnoow

C is correct ;)

_gio_Option: C

i agree with c