Search This Blog

Monday, June 29, 2009

Oracle 11g - Active Standby Database

After reading about Oracle's 11g Active Data Guard I am very excited about pushing these new enhancements to production. First step will be to try these new enhancements out in my lab environment and seeing if they are as useful as advertised.

Following are the few notable enhancements:

1. Enabling physical standby database in read only mode while all the changes from the production database are being applied to it. This feature resemblance to logical standby database techniques in previous Oracle versions.

2. Snapshot Standby - A snapshot Standby is open for read-write which can be ideally suited for test environments, able to process transactions independently of the primary database. At the same time, it maintains protection by continuing to receive data from the production database, archiving it for later use.
Using a single command discard changes made while read-write mode and quickly resynchronizes the standby with the primary database.

For more information, read the following pdf document which is available at Oracle site.

http://www.oracle.com/technology/products/database/oracle11g/pdf/active-data-guard-11g-datasheet.pdf

No comments:

Post a Comment