Oracle 19c | Converting Physical Standby to Snapshot Standby through Data Guard Broker | DGMGRL Demo

#oraclef1 #dgmgrl #oracle19c #dataguard

In this video, demonstrated creating additional physical standby database and adding physical standby database to dataguard broker through DGMGRL utility. After that converting physical standby database in to snapshot standby database. After validating converting back to snapshot standby database to physical standby database.

Introduced in 11g, snapshot standby allows the standby database to be opened in read-write mode.

When switched back into standby mode,All changes made whilst in read-write mode are lost. This is achieved using flashback database, Oracle provides an unique feature where the physical standby database can be opened in READ WRITE mode to perform update able transactions.

Quite often we have the standby database opened in READ Only mode for reporting purposes and optionally have the active dataguard implemented, but a snapshot standby database can be used to perform both READ and WRITE activities. Most importantly, a snapshot standby database keeps receiving the redo data from the primary database but does not apply them.

These redo data received from the primary database would be applied only when the snapshot standby database is converted back to the Physical standby mode.

There by the snapshot standby database provides data protection on primary database.

Hope this helps!

Cheers!
Ramesh.

Follow Me On:

WhatsApp Channel: Oracle F1