Oracle 视图 DBA_HIST_INSTANCE_RECOVERY 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图是数据字典视图，DBA_HIST_INSTANCE_RECOVERY是用于查询实例恢复历史记录的视图。该视图存储自发生故障恢复至最近恢复完成的所有历史记录，其中包括恢复的实例，最初的故障，恢复的起止日期，恢复的ORACLE版本等数据。
使用方法：
例1：通过如下查询查询在最近6小时内恢复完成的所有实例：
SELECT * FROM DBA_HIST_INSTANCE_RECOVERY
WHERE END_TIME > SYSDATE – 6/24;
例2：查询指定失败实例的恢复数据：
SELECT * FROM DBA_HIST_INSTANCE_RECOVERY
WHERE INSTANCE_NAME = ‘inst_name’;
官方英文解释
DBA_HIST_INSTANCE_RECOVERY displays the historical monitoring of the mechanisms available to the user to limit recovery I/O.
This view contains snapshots of V$INSTANCE_RECOVERY.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique snapshot ID |
|
|
|
|
Database ID for the snapshot |
|
|
|
|
Instance number for the snapshot |
|
|
|
Number of dirty buffers in the buffer cache. |
|
|
|
|
Current actual number of redo blocks required for recovery |
|
|
|
|
Current target number of redo blocks that must be processed for recovery. This value is the minimum value of the following 3 columns, and identifies which of the 3 user-defined limits determines checkpointing. |
|
|
|
|
Maximum number of redo blocks required to guarantee that a log switch does not occur before the checkpoint completes |
|
|
|
|
Number of redo blocks that need to be processed during recovery to satisfy the |
|
|
|
|
Number of redo blocks that need to be processed during recovery to satisfy the |
|
|
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always null. |
|
|
|
|
Effective MTTR (mean time to recover) target value in seconds. The In such cases, the |
|
|
|
|
Current estimated mean time to recover (MTTR) based on the number of dirty buffers and log blocks ( |
|
|
|
|
Number of blocks written by checkpoint writes |
|
|
|
|
Redo log file size (in megabytes) that is considered optimal based on the current setting of |
|
|
|
|
Estimated time (in seconds) that the cluster would become partially available should the instance fail. This column is only meaningful in an Oracle Real Application Clusters (Oracle RAC) environment. In a non-Oracle RAC environment, the value of this column is null. |
|
|
|
|
Number of writes driven by the |
|
|
|
|
Number of writes driven by the smallest redo log file size |
|
|
|
|
Number of writes driven by the |
|
|
|
|
Number of writes driven by other reasons (such as the deprecated |
|
|
|
|
Number of writes due to auto-tune checkpointing |
|
|
|
|
Number of writes due to full thread checkpoints |
|
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
|
The ID of the container that
|
See Also:
“V$INSTANCE_RECOVERY”
