In dataguard setup, we can make primary database as physical standby database and standby as primary . This is known as switch over.


TEST1 – Primary

Before doing switchover, we have to make sure that the existing standby setup is fine and the archives are getting shipped and applied properly on standby.

Check the lag between primary and standby

Also check : How to monitor physical standby setup:

switch some logfile and check whether logs are getting applied in standy or not

switchover primary to standby

switchover standby to primary:

shutdown both primary and standby:

Now TEST1 will be standby and TEST2 primary

startup the new primary[TEST2]

Mount the new standby and start recovery:

Now switch some logs in primary and check whether redos are getting applied or not.