This content has been marked as final. Show 10 replies
Please suggest a good step by step guide to implement Oracle Active Dataguard on Oracle 11g, OS : RHEL 5.4
Have searched a couple of documents, but ending up with physical or logical dataguard setup guides...
Please suggest end to end steps guide for Active Dataguard Implementation
DB : Oracle 11g Release 2
OS : RHEL 5.4
Active dataguard is option after configuring dataguard.
You can put standby database in Open(read only) mode also you can enable Recover(MRP) while open so this can be used for reporting purpose too.
Please refer below links for configuring them.
Before going into any technical details (Blog posting or Documentation), just make sure to get the terminology right at first:
1) in 11g, you can create the Standby without using a backup with the RMAN command:
RMAN> duplicate target database for standby from active database;
This is not Active Data Guard but just a new way to do the duplicate.
2) in 11g, you can have a Physical Standby in READ-ONLY OPEN mode while the Redo Apply (actualization) is still done.
That feature is called Real-Time Query and requires the (extra charged) Active Data Guard Option .
It is really simple and no effort at all to use that feature after you have implemented the Physical Standby
With Active Data Guard you have an exact copy of the Primary database.
In a logica Data Guard setupl some data types are not supported.
Better failover and switchover options with pure Physical.
The ability to open the database read-only and still meet the RTO and RPO objectives.
The Standby is 100 percent available for failover and switchover.
Fast incremental backups.
user1687821 wrote:Active Dataguard is the feature that standby database can be open in read-only mode while redo apply (Read-Only with Apply). Therefore, the database is called the Active Standby. If we look at in terms of benefits to us of the Active Data Guard; We can make our real-time reporting (while continuing to apply redo),backup operations through the active standby database.Thus, we will reduce the processing load of production.
Hi Uwe Hesse,
Thanks for the valuable information and reply...
Converting the Physical standby and making it readonly is a feature already adopted by logical standby... (Correct me if iam wrong)
So what is the advantage of Active Dataguard then...
Talip Hakan Ozturk