En garde, with Active Data Guard

After a very straightforward install of 11g R2 on RHEL5 (on a VM initially), getting started on building an instance to act as the primary for my Oracle Active Data Guard Proof of Concept paper.

It will also serve as the test install for the migration of Grid Control to the new plaform.

Active Data Guard (extra cost, naturally…) extends ‘vanilla’ Data Guard by facilitating real time application of data to the standby database, so this physical standby can be opened read only for reporting / queries (“Real Time Query” in Oracle jargon).

To be honest, I don’t think we have a business case for using it on any of our systems here, but the standard Data Guard feature of using the failover instance for patch testing should be a go-er on at least one of our systems, where the business owners can be a bit ‘precious’.

Useful link here:

http://www.oracle.com/us/products/database/options/active-data-guard/index.html

And another from the excellent Uwe Hesse, who describes using Data Guard with Flashback:

http://uhesse.wordpress.com/2010/08/06/using-flashback-in-a-data-guard-environment/

Advertisements
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: