Oracle 11g Dataguard Physical standby configuration (vi) broker Fastfailover test

This paper uses Oracle 11g Dataguard broker Fastfailover Test

Oracle 11g Dataguard Fast failover configuration, requires a primary database to turn on the flash back function, flash back to open this article skip.

When the flash-back is activated to the Mount state, the primary standby listener does not turn off at will.

1. DGMGRL View Primary repository status

$ DGMGRL sys/oracle

DGMGRL for Linux:version 11.2.0.3.0-64bit Production

Copyright (c), 2009, Oracle. All rights reserved.

Welcome to the DGMGRL, for information, type Help.

is connected.

Dgmgrl> show configuration;

Configuration-Dgorcldb

Protection mode: Maxperformance

Database:

ORCL-Primary Database

Slave-Physical Standby database

Quick Start Failover: DISABLED

Configuration Status:

SUCCESS

#Fast start failover is unavailable.





#View failover situation, disabled is not enabled.

Dgmgrl> Show Fast_start failover

Quick Start Failover: DISABLED

Threshold value: 30 seconds

Goal: (none)

Observation procedure: (none)

Lag limit: 30 seconds

Close Primary Database: TRUE

Automatic recovery: TRUE

Configurable failover conditions

Health status:

Corrupted Controlfile YES

Corrupted Dictionary YES

Inaccessible Logfile NO

Stuck Archiver NO

DataFile Offline YES

Oracle error Condition:

No

2. Start a quick start failover

dgmgrl> enable Fast_start failover;

3. Start Quick Start failover Observer Watch program

Dgmgrl> start observer;

NOTE: After start observer, the Watcher will not run in the background, it will be displayed in the foreground.

In the actual use of the process, you need to start on the server alone, in the background automatically run, can not be closed, or the main reserve can not automatically monitor the running state.

You cannot use the Quick Start failover feature.

4. Perform a view in another window

$ DGMGRL sys/oracle

Dgmgrl> show Fast_start failover;

Fast Start failover: ENABLED

Threshold value: 30 seconds

Goal: Slave

Observation Program: Master

Lag limit: 45 seconds

Close Primary Database: TRUE

Automatic recovery: TRUE

Configurable failover conditions

Health status:

Corrupted Controlfile YES

Corrupted Dictionary YES

Inaccessible Logfile NO

Stuck Archiver NO

DataFile Offline YES

Oracle error Condition:

No

Dgmgrl> Show Configuration

Configuration-Dgorcldb

Protection mode: Maxperformance

Database:

Slave-Primary Database

ORCL-(*) Physical standby database