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?
A.
It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
B.
It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
C.
It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
D.
It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
E.
It will fail because there is no autobackup of the controlfiles.
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.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
niabs
Highly Voted 2 years, 11 months agoAldrid
Highly Voted 3 years ago[Removed]
Most Recent 2 weeks ago[Removed]
2 weeks ago[Removed]
3 days, 10 hours ago_gio_
1 year agohilaire
1 year, 6 months agoHacket
2 years, 4 months ago