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?

The correct answer is A. from the last complete checkpoint position. Have a recovery time governed by the number of terminated instances, amount of redo generated in each terminated redo thread since the last checkpoint, and by user-configurable factors such as the number and size of redo log files, checkpoint frequency, and the parallel…

Configuring for Recoverability

Question

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?

Options

Afrom the last complete checkpoint position
Bfrom the beginning of the current redo log file until the instance failure
Cfrom the last committed transaction
Dfrom the beginning of the current redo log file to the checkpoint position
Efrom the most recent incremental checkpoint

How the community answered

(37 responses)

A
76% (28)
B
3% (1)
C
11% (4)
D
8% (3)
E
3% (1)

Explanation

Have a recovery time governed by the number of terminated instances, amount of redo generated in each terminated redo thread since the last checkpoint, and by user-configurable factors such as the number and size of redo log files, checkpoint frequency, and the parallel recovery setting Reference https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm#CNCPT005

Topics

#checkpoint#instance recovery#crash recovery#redo log

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice