Dataguard Broker Switchover

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 […]

Put standby database into snapshot standby

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 […]