9-6 Data Guard - Convert the standby to a snapshot standby

The standby database might be converted to snapshot standby database and opened for READ WRITE operations. During this period of time, all archived log files will be transferred but not applied to the database. After converting the snapshot standby database back to the physical standby database, all redo data will be applied.

 

 

 

Q1. Convert physical standby database to snapshot standby database using DGMGRL (15min)

 

1. Login to Data Guard Broker

on node1

 

 

2. Convert physical standby database to Snapshot standby database.

CONVERT DATABASE oradb_s2 TO SNAPSHOT STANDBY;

 

 

 

3.Switch to node2, let's go play!!!!

/* on node2 */
SELECT open_mode FROM v$database;

 

 

 

 

4. Play time is over. convert snapshot database to physical database.

/* on node2 */
shut;
startup mount;

/* on node1 */
CONVERT DATABASE oradb_s2 TO PHYSICAL DATABASE;

 

 

 

Q2. Convert physical standby database to snapshot standby database using SQL*Plus (15min)

ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

 

 

 

 

 

 

 

References

Oracld Docs 19c, Data Guard Broker

Oracld Docs 19c, Data Guard concepts and administration