Oracle查实例恢复状态

select RECOVERY_ESTIMATED_IOS reio,

ACTUAL_REDO_BLKS arb,

TARGET_REDO_BLKS trb,

LOG_FILE_SIZE_REDO_BLKS lfsrb,

LOG_CHKPT_TIMEOUT_REDO_BLKS lctrb,

LOG_CHKPT_INTERVAL_REDO_BLKS lcirb,

FAST_START_IO_TARGET_REDO_BLKS fsiotrb,

TARGET_MTTR tmttr,

ESTIMATED_MTTR emttr,

CKPT_BLOCK_WRITES cbw

from v$instance_recovery;

select RECOVERY_ESTIMATED_IOS  reios,

       TARGET_MTTR             tmttr,

       ESTIMATED_MTTR          emttr,

       WRITES_MTTR             wmmttr,

       WRITES_OTHER_SETTINGS   woset,

       CKPT_BLOCK_WRITES       ckptbw,

       WRITES_AUTOTUNE         wauto,

       WRITES_FULL_THREAD_CKPT wftckpt

  from v$instance_recovery;