Switch over from primary to standby database

Assumptions before we begin this exercise.
1.  Primary and standby are running on two hosts, H1 and H2  (see previous post)

Check the status of the primary database.

SWITCHOVER_STATUS
--------------------
TO STANDBY

Issus the switch over command.

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;

Then shutdown the primary database and start it up mount.

Check the status again

SWITCHOVER_STATUS
--------------------
TO PRIMARY

Confirm the database role of the new standby

DATABASE_ROLE    DB_UNIQUE_NAME                 NAME
---------------- ------------------------------ ---------
PHYSICAL STANDBY chicago                                      CHICAGO

On the new primary database, perform the following

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

Then open the database.

Check the role of the new primary database now

DATABASE_ROLE    DB_UNIQUE_NAME                 NAME
---------------- ------------------------------ ---------
PRIMARY          boston                                            CHICAGO

Test out the log switching, goto the new standby and run a query on the archive logs

Start the standby recover process on the new standby

Issue a log switch from new primary

Check again the archive logs on the new standby