Which two are true about Oracle instance recovery? (Choose two.)

Question

Options

• ARecovery begins from the beginning of the CURRENT redo log group.
• BRecovery begins from the last checkpoint position that was calculated by the Database Writer
• CRecovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log
• DRecovery reads redo until the end of the redo thread. SMON rolls back any dead transactions,
• ERecovery begins from the last checkpoint position that was recorded in the control file by the
• FRecovery reads redo until the end of the redo thread, and then opens the database. SMON then

• A
  12% (6)
• B
  6% (3)
• C
  2% (1)
• D
  2% (1)
• E
  78% (40)

Explanation

E: Instance recovery is the process of applying records in the online redo log to data files to reconstruct changes made after the most recent checkpoint. Instance recovery occurs automatically when an administrator attempts to open a database that was previously shut down The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and F: Oracle Database can roll back multiple transactions simultaneously as needed. All transactions that were active at the time of failure are marked as terminated. Instead of waiting for the SMON process to roll back terminated transactions, new transactions can roll back individual blocks themselves to obtain the required data. https://docs.oracle.com/cd/E25178_01/server.1111/e25789/startup.htm

No community discussion yet for this question.