A node is evicted from a three-node cluster due to poor latency of the underlying storage. Which
two statements are correct in describing the instance recovery process?
A.
Perform a restore of archive redo from flash recovery area to recover database.
B.
Upon startup, the SMON/LMS processes perform instance crash recovery.
C.
Upon startup of failed instance, the SMON process performs instance crash recovery by using
checkpoints to determine which data needs to be applied to data files.
D.
User intervention is not required. Upon startup, PMON (process monitor) performs instance crash
recovery automatically.
E.
User intervention is not required.
A is wrong as there is no need for manual recovery using archive redo.
B is wrong as this is a RAC instance and in RAC surviving instance performs Recovery and does not wait for Instance startup.
C is wrong as this is a RAC instance and in RAC surviving instance performs Recovery and does not wait for Instance startup.
D SMON performs recovery not PMON.
E is Correct as User interventions is not required for instance recovery.
Maybe C and E
Should be B and E
B,E looks better to me..
I think it’s B and E.
LMS is also called GCS:
http://oraclerac-rips.blogspot.ie/2012/11/rac-and-instance-or-crash-recovery.html
E is obviously correct.
Since the question is related to crash recovery instance, I think C is better than B:
https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89047
“[…] The database opens for the first time after the failure of a single-instance database or all instances of an Oracle RAC database. This form of instance recovery is also called crash recovery. Oracle Database recovers the online redo threads of the terminated instances together.
[…] Instance recovery uses checkpoints to determine which changes must be applied to the data files. The checkpoint position guarantees that every committed change with an SCN lower than the checkpoint SCN is saved to the data files.”
Good work Beatrizia.
C E