This time around, we'll do a switchover and switchback exercise using Oracle dataguard broker. If you need help on setting up the broker, refer my previous post How to setup DGMGRL, broker with example. We'll see how easy it is to switchover using just one command provided the broker is configured correctly. We'll also cover sample examples along with troubleshooting tips and comprehensive sanity checks.

Using Oracle's heterogenous services also known as HS, we can make a connection to non-Oracle databases and access the data remotely. I used MS SQL server as the target non-Oracle database on Windows and used HS to access from Oracle database residing on Linux. Here, we'll see step by step instructions on how to set up a connection from Oracle database to Microsoft SQL server.