The steps to perform a switch over using dataguard broker are very simple you just need to do the following: 1. Connect to dgmgrl and make sure the configuration status = SUCCESS 2. Connect to the standby database as sys using the SID 3. Then use the command switchover to “XXXXX” where XXXXX is your […]

So we are going to convert our physical standby database into a read-write real time clone of the primary database and we can then temporarily use this environment for carrying out DR testing. The Snapshot Standby database in turn uses the Flashback Database technology to create a guaranteed restore point to which the database can be later […]