Oracle Data Guard

So far I have covered Oracle and Oracle RAC, in this series I cover Oracle Data Guard 11g, as I become more experienced I will update this series from time to time. For the examples I have setup a test environment using VMware, feel free to setup a similar environment.

I have to say this was one of the hardest projects I have had to configure, make sure that you read the Oracle documentation thoroughly as there are many pitfalls with this solution, but once you get it configured and running it is a breeze managing it and make sure to test and document your switchover and failover procedures.

The series has been comprised of reading the following books and real world experience, if you are new to Oracle Data Guard I highly recommend that you should purchase these books as they contain far more information than this web site contains and of course the Oracle web site contains all the documentation you will ever need.

Please feel free to email me any constructive criticism you have with the site as any additional Oracle knowledge or mistakes that I have made would be most welcomed.



  Data Guard Overview
  Apply Services
  Protection Modes
  Switchover and Failover
  Data Guard Management

Installation and Configuration
  Virtual machines setup
  Primary Database VM setup
  Grid Control VM setup
  Physical Standby Database VM setup
  Logical Standby Database VM setup

Physical Standby
  Setup a physical standby database using RMAN

Logical Standby
  Creating a logical standby database
  SQL Apply
  Tuning SQL Apply

Redo Processing
  Components of a physical Standby
  Tools and Views for Monitoring
  Physical Standby Corruption Detection

Oracle Data Guard Broker
  Broker Introduction
  Configuration Files
  State and Monitoring

Enterprise Manager Grid Control
  Installation and Configuration
  Grid Control Agent

Monitoring Data Guard
  Data Guard Utility Menu

Switchover and Failover
  FlashBack and Data Guard
  Physical Switchover
  Logical Switchover
  Performing a Failover
  The old primary
  Automatic Failover (FSFO)

Active Data Guard
  Read-Only Standby
  Snapshot Standby
  Real Application Testing
  Active Data Guard

Automating Site and Client Failover
  Transparent Application Failover (TAF)

Backup and Recovery
  RMAN configuration in Data Guard
  Backups and Recovery

  Configuration and Management Errors
  Physical Standby Issues
  Logical Standby Issues
  Switchover Issues

Data Guard Complete setup guide
  Complete Setup information


Oracle Data Guard Books
Oracle Data Guard 11g Handbook - Larry Carpenter There are not many dedicated Data Guard books, this book is all you will probably need and some information from the internet, the book is easy to read and the chapters flow in the correct order, but you should ideally setup a test rig and play around.
Oracle Data Guard 10g High Availability with RAC, Flashback and Data Guard - Matthew Hart & Scott Jesse A short section on Oracle Date Guard, althrough 10G is different the concepts are still the same.