Oracle Data Guard

From Wikipedia, the free encyclopedia

The software which Oracle Corporation markets as Oracle Data Guard forms an extension to the Oracle database management system. It aids in establishing and maintaining secondary "standby databases" as alternatives to production "primary databases".

Oracle Corporation provides both GUI and command-line tools for managing Data Guard configurations.

Data Guard supports both physical and logical standby sites. It runs under most Oracle editions, but not under Oracle Express Edition (XE).

With appropriately set up Data Guard operations, DBAs can facilitate failovers or switchovers to alternative hosts in alternative locations.

[edit] Operation

A primary site which has an archived redo log to transfer invokes the RFS (remote file server) background process within the Oracle instance running on a standby host. The RFS process then performs the task of receiving archived redo logs sent from the primary database. Once such logs have arrived, other processes (an ARCH (Archiver process), MRP (Managed Recovery Process), LSP (Logical Standby Process)) may set about applying their contents to the standby database.