1Z0-058 · Question #131
In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to 300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the V$INSTANCE_RECOVERY view shows the value 100…
The correct answer is A. In the event of an instance failure, the database will become partially available In 100 seconds. E. In the event of an instance failure, the failed instance will become available In 300 seconds. FAST_START_MTTR_TARGET FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL. V$INSTANCE_RECOVERY Estimated time (in…
Question
In your two-instance RAC database, you find that FAST_START_MTTR_TARGET is set to 300 on both the nodes. The ESTD_CLUSTER_AVAILABLE_TIME column in the V$INSTANCE_RECOVERY view shows the value 100. What is the correct interpretation? (Choose 2)
Exhibit
Options
- AIn the event of an instance failure, the database will become partially available In 100 seconds.
- BIn the event of an instance failure, the database will become fully available in 100 seconds.
- CIn the event of an instance failure, the failed instance will become fully available In 300 seconds.
- DIn the event of an instance failure, the database will become partially available in 200 seconds.
- EIn the event of an instance failure, the failed instance will become available In 300 seconds.
How the community answered
(40 responses)- A80% (32)
- B13% (5)
- C3% (1)
- D5% (2)
Explanation
FAST_START_MTTR_TARGET FAST_START_MTTR_TARGET enables you to specify the number of seconds the database takes to perform crash recovery of a single instance. When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL. V$INSTANCE_RECOVERY Estimated time (in seconds) that the cluster would become partially available should this 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.
Topics
Community Discussion
No community discussion yet for this question.