Converting a Snapshot Standby Database to a Physical Standby Database

In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby.

Prerequisites : Snapshot database is already exists

Step 1 : Check Primary Database Information :

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  READ WRITE	       PRIMARY

Step 2 : Check Snapshot Database Information :

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  READ WRITE	       SNAPSHOT STANDBY

Step 3 : Shut down standby database  :

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Step 4 : Start standby database in mount state :

SQL> STARTUP MOUNT
ORACLE instance started.

Total System Global Area  392495104 bytes
Fixed Size		    2253584 bytes
Variable Size		  176164080 bytes
Database Buffers	  209715200 bytes
Redo Buffers		    4362240 bytes
Database mounted.
SQL>

Step 5 : Convert database to physical standby database :

SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Database altered.

Step 6 : View information of physical standby database :

SQL>  SELECT NAME,OPEN_MODE,DATABASE_ROLE FROM V$DATABASE;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  MOUNTED	       PHYSICAL STANDBY

SQL>

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp