...
The steps to activate the standby database are:
Stop the scheduling of Dbvisit Standby.
Change the network configuration (or DNS) so that users will connect to the standby database (or server) instead of the primary database (or server).
Activate and open the standby database for normal operation as per the instructions below. Note that as soon as the standby database is activated and becomes the new primary database that is open read/write. The link to the original primary database is lost and it is no longer possible to apply new logs to the original standby database.
To activate and open the standby database for continued operation in the event of a disaster the following procedure discussed in this section must be used.
...
Select this option if you want to activate the standby database now - this is usually in the case when the disaster happened and you need to activate (failover) to the standby database. If you have enabled Standby Update Delay where the standby database archivelogs are aavailable on the standby but not applied. This would give you option to apply all the logs and then activate the standby database.
| Note |
|---|
After the standby database is activated. The Observer and the Automated standby update as disabled. The observer is disabled to ensures that the unnecessary alerts are not sent out. Since, there is no standby database after activation the automated standby update is disabled as well. This options would be prompted when the new standby database is created. |
Clicking on Activate will open the database in read-write mode with resetlogs and once this operation is done , you have to either recreate the standby database after dropping the database , If you are doing this during a true DR scenario where the primary is unavailable then you might have to recreate the primary database as standby and then do a switchover to revert back to original configuration.
...