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 ...
Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.