Time for action – enabling Active Data Guard using broker
If Data Guard is managed using a broker, it is always simple and even easier to manage it from Oracle 11gR2. When both broker and MRP are running on the standby, you can open the database at any time for reporting purposes.
- Check the configuration and state of the database as follows:
DGMGRL> show configuration; Configuration - PACKT Protection Mode: MaxPerformance Databases: turkey_un - Primary database INDIA_UN - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS DGMGRL> SQL> select db_unique_name,open_mode from v$database; DB_UNIQUE_NAME OPEN_MODE --------------- -------------------- INDIA_UN MOUNTED SQL> SQL> !ps -ef|grep mrp oracle 4686 1 0 16:31 ...