Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups. Which statement is true about the loss of a duplexed control file?
A.
The database remains open but transactions are not permitted.
B.
The database instance aborts, and media recovery is required after restoration of the control file to open the database.
C.
The database instance remains open and the control file can be restored without shutting down the database.
D.
The database instance aborts and a control file restore operation does not require media recovery.
Sorry I think D as per DOC
Identifying a Lost Control File
It is usually obvious when the control file of your database is lost. The database shuts down immediately when any of the multiplexed control files become inaccessible. Also, the database reports an error if you try to start it without a valid control file at each location specified in the CONTROL_FILES initialization parameter.
Loss of some but not all copies of your control file does not require you to restore a control file from backup. If at least one control file remains intact, then you can either copy an intact copy of the control file over the damaged or missing control file, or update the initialization parameter file so that it does not refer to the damaged or missing control file. After the CONTROL_FILES parameter references only present, intact copies of the control file, you can restart your database.
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm#BRADV89763
If you just copy the other controlfile to the duplexed controlfile using cp command without shutting down the instance, then when you shutdown instance or switch redo log or archive redo log, instance will crash. And after that if you try to check the md5 of all controlfiles , you will find out that they are not identical at all. I had test it with 12.1.0.2 in oracle linux.
So D is correct.
option D is correct as per test that I performed. When once control file was damaged, the session didn't terminate unless I issued a log switch command, because during log switch the SCN number gets written to control file. So database instance aborts and we can start database after we copy un-corrupt file to new file name (provided no change in control file locations)
I think that the right answer is D.
Here is the explaination from oracle site.
Read this:
Multiplex Control Files on Different Disks
-----------------------------------------------------------------
Every Oracle Database should have at least two control files, each stored on a different physical disk. If a control file is damaged due to a disk failure, the associated instance must be shut down. Once the disk drive is repaired, the damaged control file can be restored using the intact copy of the control file from the other disk and the instance can be restarted. In this case, no media recovery is required.
The behavior of multiplexed control files is this:
-The database writes to all filenames listed for the initialization parameter CONTROL_FILES in the database initialization parameter file.
-The database reads only the first file listed in the CONTROL_FILES parameter during database operation.
-If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted.
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14231/control.htm
D is correct, since the database writes to all the control files during its operation.
If it not found anyone of them, then the database get terminated..
We just need to get the copy or restore the controlfile to the second location and restart the database.
Note:The database will be operating only when both the control files are in completely sync
otherwise, the db will get crashed. It may be duplexed or triplexed...
D is correct, since the database writes to all the control files during its operation.
If it not found anyone of them, then the database get terminated..
We just need to get the copy or restore the controlfile to the second location and restart the database.
Note:The database will be operating only when both the control files are in completely sync
otherwise, the db will get crashed. It may be duplexed or triplexed...
I would go for C
because select status from v$instance is open even you delete control files. Keep in mind that some dictionary tables have problems dba_data_files
then you can restore a good control file to bad control file by cp command
Answer: D
If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted.
https://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV90040
https://docs.oracle.com/database/121/ADMIN/control.htm#ADMIN112
https://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV90040
Use the following procedures to recover a database if a permanent media failure has damaged one or more control files of a database and at least one current control file has not been damaged by the media failure.
answer : B
lose of control file always consider as media filer
upvoted 1 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
dancymonkey
Highly Voted 4 years, 3 months agohggz
4 years, 3 months agoNorwayOracle
2 years, 9 months agorcgenilo27
Highly Voted 5 years, 2 months agobadguy001djh
3 years, 8 months agoRay520
Most Recent 2 years, 7 months agoSADIO
3 years, 7 months agocharan94
3 years, 7 months agocharan94
3 years, 7 months agodancymonkey
4 years, 4 months agosherifelia
5 years agokhan
5 years, 8 months agoNorthKorean
4 years, 8 months agotaiyang
4 years, 8 months agoeskias
3 years, 3 months ago