DATAGUARD SWITCHOVER

 SQL> alter database flashback on ;   <-- Both Source and Target

Database altered.

server6[<db>1]_osuser> dgmgrl

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/******@database_p2

Connected as SYSDBA.

DGMGRL> show configuration

Configuration - <dbname>_dg_config

  Protection Mode: MaxPerformance

  Members:

  database_p2 - Primary database

    database_p1 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 56 seconds ago)

DGMGRL> validate database database_p2;

  Database Role:    Primary database

  Ready for Switchover:  Yes

DGMGRL> validate database database_p1;

  Database Role:     Physical standby database

  Primary Database:  database_p2

  Ready for Switchover:  Yes

  Ready for Failover:    Yes (Primary Running)

  Flashback Database Status:

    database_p2:  On

    database_p1:  Off

DGMGRL> switchover to database_p1

Performing switchover NOW, please wait...

Operation requires a connection to instance "<db>2" on database "database_p1"

Connecting to instance "<db>2"...

Connected as SYSDBA.

New primary database "database_p1" is opening...

Oracle Clusterware is restarting database "database_p2" ...

Switchover succeeded, new primary is "database_p1"

DGMGRL>

SWITCH BACK 

++++++++++++++

server1[<db>1]_osuser> tellme sys

******

server1[<db>1]_orwccp1> dgmgrl

DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/******@database_p1

Connected as SYSDBA.

DGMGRL>

DGMGRL> show configuration

Configuration - arpkwcp1_dg_config

  Protection Mode: MaxPerformance

  Members:

  database_p1 - Primary database

    database_p2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS   (status updated 13 seconds ago)

DGMGRL> validate database database_p1

  Database Role:    Primary database

  Ready for Switchover:  Yes

DGMGRL> validate database database_p2

  Database Role:     Physical standby database

  Primary Database:  database_p1

  Ready for Switchover:  Yes

  Ready for Failover:    Yes (Primary Running)

DGMGRL>

DGMGRL> switchover to database_p2

Performing switchover NOW, please wait...

Operation requires a connection to instance "<db>1" on database "database_p2"

Connecting to instance "<db>1"...

Connected as SYSDBA.

New primary database "database_p2" is opening...

Oracle Clusterware is restarting database "database_p1" ...

Switchover succeeded, new primary is "database_p2"

DGMGRL>