Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? last checkpoint, and by user-configurable factors such as the number and size of redo log files, checkpoint frequency, and the parallel recovery setting
A.
from the last complete checkpoint position
B.
from the beginning of the current redo log file until the instance failure
C.
from the last committed transaction
D.
from the beginning of the current redo log file to the checkpoint position
E.
from the most recent incremental checkpoint
Explanation:
or C,D (50-50)
Have a recovery time governed by the number of terminated instances, amount of redo generated in each terminated redo thread since the
Reference https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm#CNCPT005