Switchover with Data Guard Broker : DGMGRL

 Switchover with Data Guard Broker 

DGMGRL>

DGMGRL>

DGMGRL> show configuration;

Configuration - prod_ddb

  Protection Mode: MaxPerformance

  Members:

  ddb    - Primary database

    ddb_dr - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:

SUCCESS   (status updated 11 seconds ago)

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL> switchover to ddb_dr

Performing switchover NOW, please wait...

Operation requires a connection to database "ddb_dr"

Connecting ...

Connected to "ddb_dr"

Connected as SYSDBA.

New primary database "ddb_dr" is opening...

Operation requires start up of instance "ddb" on database "ddb"

Starting instance "ddb"...

Connected to an idle instance.

ORACLE instance started.

Connected to "ddb"

Database mounted.

Connected to "ddb"

Switchover succeeded, new primary is "ddb_dr"

DGMGRL>

DGMGRL>

DGMGRL> show configuration

Configuration - prod_ddb

  Protection Mode: MaxPerformance

  Members:

  ddb_dr - Primary database

    ddb    - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:

SUCCESS   (status updated 78 seconds ago)

DGMGRL>

DGMGRL>

DGMGRL> switchover to ddb

Performing switchover NOW, please wait...

Operation requires a connection to database "ddb"

Connecting ...

Connected to "ddb"

Connected as SYSDBA.

New primary database "ddb" is opening...

Operation requires start up of instance "ddb_dr" on database "ddb_dr"

Starting instance "ddb_dr"...

Connected to an idle instance.

ORACLE instance started.

Connected to "ddb_dr"

Database mounted.

Connected to "ddb_dr"

Switchover succeeded, new primary is "ddb"

DGMGRL>

DGMGRL>

DGMGRL>

DGMGRL> show configuration

Configuration - prod_ddb

  Protection Mode: MaxPerformance

  Members:

  ddb    - Primary database

    ddb_dr - Physical standby database

Fast-Start Failover:  Disabled

Configuration Status:

SUCCESS   (status updated 77 seconds ago)

DGMGRL>