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)
A.
In the event of an instance failure, the database will become partially available In 100 seconds.
B.
In the event of an instance failure, the database will become fully available in 100 seconds.
C.
In the event of an instance failure, the failed instance will become fully available In 300
seconds.
D.
In the event of an instance failure, the database will become partially available in 200 seconds.
E.
In the event of an instance failure, the failed instance will become available In 300 seconds.
Explanation:
FAST_START_MTTR_TARGETFAST_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.
Oracle Database Reference
11g Release 2 (11.2)
A is right. partially available in 100s
B is wrong. not fully
C is wrong. not fully
D is wrong. not 200s
E is right. available in 300s
So A.E. are correct