V$INSTANCE_RECOVERY

This view monitors the mechanisms available to the user/DBA to limit the I/O needed for recovery.

Fields

The most relevant view fields are as follows:

• RECOVERY_ESTIMATED_IOS: The estimated number of data blocks to process during recovery

• ESTIMATED_MTTR: The estimated time recovery based on the current system load

• TARGET_MTTR: The Mean Time To Recover (MTTR) target value in seconds

• LOG_FILE_SIZE_REDO_BLKS: The number of redo blocks required to be sure that a log switch won't occur before the checkpoint completes

• LOG_CHKPT_INTERVAL_REDO_BLKS: The number of redo blocks that will be processed during recovery to satisfy the LOG_CHECKPOINT_INTERVAL parameter

• LOG_CHKPT_TIMEOUT_REDO_BLKS: The number of redo blocks that will be processed during recovery to satisfy the LOG_CHECKPOINT_TIMEOUT parameter

• ACTUAL_REDO_BLKS: The current number of redo blocks needed to recover

• TARGET_REDO_BLKS: The current target number of redo blocks that must be processed for recovery