Oracle Data Guard: Difference between revisions

Revision as of 02:11, 8 September 2010

Revision as of 12:42, 14 September 2010

Line 33:

=== Active Data Guard ===

The "Oracle Active Data Guard" option, an extra-cost facility,<ref name="Oracle Database Options">

{{cite web

| first = Diana

Line 50:

}}

</ref>

extends Oracle Data Guard physical standby functionality in Oracle 11g configurations. It allows read-only access on the standby node at the same time as archiving transactions from the primary node.<ref name="Oracle Active data Guard">

{{cite web

| title = Oracle Active data Guard

Line 108 ⟶ 107:

Data Guard restricts use to like platform and Oracle RDBMS versions. As mentioned in this reference,

| title <ref name= "Oracle Database Options"/>

<ref>

{{cite web

| first = Diana

| last = Lorentz

| title = Oracle Database Options

| url = http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#sthref21

| archiveurl =

| work = Oracle Database Licensing Information 11g Release 1 (11.1)

| publisher = Oracle Corporation

| date = 01/2009

| year = 2009

| month = February

| archivedate =

| accessdate = 2009-04-22

| quote = If a physical standby database in a Data Guard configuration has any of the above features enabled, then the Active Data Guard option must be licensed for every such physical standby, and also for the primary database.

}}

</ref>

Data Guard is an added cost option bundled within "Enterprise Edition" of the [[Oracle RDBMS]] and allows purely read-only access.

| title <ref name= "Oracle Active data Guard"/>

<ref>

{{cite web

| title = Oracle Active data Guard

| url = http://www.oracle.com/database/active-data-guard.html

| work = Oracle Database

| publisher = Oracle Corporation

| date = 01/2010

| year =

| month =

| archivedate =

| accessdate = 2009-04-22

| quote = Oracle Active Data Guard enables read-only access to a physical standby database for queries, sorting, reporting, web-based access, etc., while continuously applying changes received from the production database.

}}

</ref>

Substantial costs savings are possible using Oracle Standard Edition (SE) or Oracle Standard Edition One (SE1) with use of a third-party product such as [http://www.quest.com/shareplex-for-oracle/ SharePlex for Oracle Database Replication] to provide [[high availability]] for a database system.

<ref>