Oracle Data Guard

Oracle Jobs

SQL Statement Tuning

Backup and Recovery Concepts

Oracle E Suite & Others

Oracle DBA Interview Questions

Oracle Data Guard Concepts

Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. 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.

Standby Database Types

A standby database is a transactionally consistent copy of an Oracle production database that is initially created from a backup copy of the primary database.Read more about Oracle Data Guard .

Data Guard Operational Prerequisites

All members of a Data Guard configuration must run an Oracle image that is built for the same platform.

Standby Database Directory Structure

The directory structure of the various standby databases is important because it determines the path names for the standby datafiles, archived redo log files, and standby redo log files. Read more about Oracle Data Guard

Preparing the Primary Database for Standby Database Creation

Before you create a standby database you must first ensure the primary database is properly configured.

Step-by-Step Instructions for Creating a Physical Standby Database

You can use any backup copy of the primary database to create the physical standby database, as long as you have the necessary archived redo log files to completely recover the database. Read more about Oracle Data Guard

Logical Standby Database

You create a logical standby database by first creating a physical standby database and then transitioning it to a logical standby database.

Redo Transport Services

Redo transport services control the automated transfer of redo data from a database destination to one or more destinations.Read more about Oracle Data Guard

Log Apply Services

Log apply services automatically apply redo to standby databases to maintain synchronization with the primary database and allow transactionally consistent access to the data.

Discuss Oracle Data Guard

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking