Oracle Data Guard 11g

on 12:09 PM

Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions.

Its configuration consists of one primary database and one or more standby database. The standby databases will be always in sync  with primary database. If primary production database is unavailable due to planned or unplanned outage , then we can switch the production to standby database, making the application less affected by the outage.

 Apart from this we can use the standby database for taking backups and reporting queries, there by reducing some workload from production.

The main features of Oracle data guard is

1. High availablity
2. Data protection
3. Disaster Recovery

# Primary Database : A Data Guard configuartion contains one production database, also referred to as the primary database.

The primary database can be either a single instance Oracle Database or an Oracle Real Application Cluster database.

# Standby Database : A standby database is a transactionally consistent copy of the primary database.

Dataguard automatically maintains each standby database by transmitting redo data from primary database and then applying the redo to the standby database.

0 comments:

Post a Comment