BROKER COMMANDS

Snapshot Standby database is a few feature of Oracle 11g Datagaurd. Using this feature , the physical standby database can be opened in read write mode for application testing and convert back to to physical standby mode.
Steps are
Make sure that primary and standby database are in sync
Convert the physical standby into snapshot standby
Open the snapshot standby in read write mode
Create new objects in the snapshot standby database
Convert the snapshot standby database back to physical standby
Restart the  media recovery
For this exercise  , i am using Dataguard broker. These activities can be performed via SQL commands too .
Converting the existing physical standby database to snapshot standby
 DGMGRL> convert database stand to snapshot standby;
DGMGRL> convert database stand to snapshot standby;
Converting database "stand" to a Snapshot Standby database, please wait…
Database "stand" converted successfully
DGMGRL>
Confirm the conversion to snapshot standby
DGMGRL> show configuration
Configuration – dg_config
  Protection Mode: MaxPerformance
  Databases:
    prim  – Primary database
    stand – Snapshot standby database
Fast-Start Failover: DISABLED


Configuration Status:
SUCCESS
DGMGRL>