Thursday, April 4, 2019

How to activate a standby database so that we end up with 2 primary databases

When planning a migration an important step is to test that all applications can access the new hosts and ideally do some performance tests on the new hardware.

We can clone the DB with RMAN and replicate the redo logs with dataguard.

Then using the following commands we can break the replication and activate the standby without turning the existing primary DB into a standby: If it's a RAC, shutdown all the nodes except one.

SQL>  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>  ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;
SQL>  SHUTDOWN IMMEDIATE;
SQL>  STARTUP;

No comments :

Post a Comment