What is Active Data Guard 12c?

Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Below are the benefit of using active dataguard. Reporting queries can be offloaded to standby database.

How Much Is Active Data Guard?

Active Data Guard carries a list price of $11,500 USD, and both the primary and standby databases must be licensed if they reside on different physical servers. The danger with Active Data Guard is that some of our customers open their standby databases and do not realize that ADG is in use.

Does Oracle Data Guard require separate license?

Data Guard is a feature of the Oracle Database Enterprise Edition itself and does not require separate licensing.

Is Oracle dataguard free?

Active Data Guard is not free, however. Active Data Guard carries a list price of $11,500 USD, and both the primary and standby databases must be licensed if they reside on different physical servers.

How do I set up Active Data Guard?

Perform the following steps:

1. Invoke DGMGRL and connect as SYS. Enter for SYS.
2. Invoke SQL*Plus and connect to your standby database as SYSDBA.
3. Invoke DGMGRL and connect as SYS.
4. Invoke SQL*Plus and connect to your standby database as SYSDBA.
5. Invoke SQL*Plus and connect to your primary database as SYSDBA.

How do I start MRP in Active Data Guard?

8.1. 1 Starting Up a Physical Standby Database

1. Start and mount the physical standby database: SQL> STARTUP MOUNT;
2. Start Redo Apply or real-time apply: To start Redo Apply, issue the following statement: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE 2> DISCONNECT FROM SESSION;

What is an active Data Guard?

Active Data Guard enables read-only access to a physical standby database while Redo Apply is active. Queries and reports can be offloaded from the production system to a synchronized physical standby database – all queries at the standby database return up-to-date results.

How does Active Data Guard work?

Data Guard automatically synchronizes the primary database and all standby databases by transmitting primary database redo – the information used by every Oracle Database to protect transactions – and applying it to the standby database.