Oracle Data Guard Tutorial: Data Guard for Performance and Reduced Licensing Costs | Demonstration: The Read Mostly Database: Query the Standby, DML to the Primary, Transparently

Oracle Data Guard Tutorial: Data Guard for Performance and Reduced Licensing Costs

We all know that Data Guard is essential for protecting data. And we know that it is expensive and relies on largely idle systems, sitting there waiting for a problem that may never happen.  This tutorial provides a quick review of what Data Guard is, and then goes on to show how you can extract value from Data Guard in every-day usage: how you can use it to enhance performance, and to reduce (yes, reduce!) your need for Oracle licences.

Audience:  This will be of interest to anyone already running Data Guard (or the old Standard Edition “standby database” facility) who needs to become aware of the newer capabilities, and to anyone trying to motivate the investment needed for a new Data Guard implementation.

Recommended Prerequisites: As is common with SkillBuilders webinars, the content is technical, including live demonstrations of the techniques described. Some knowledge of Data Guard is recommended.

Presenter: John Watson, Oracle Certified Master.

This free training is segmented into several separate lessons:

1. Introduction and Data Guard Quick Review (Revision) (16:53)
2. Demonstration: Open the Standby Read Only (16:49)
3. Demonstration: Open the Standby Read Write (14:09)
4. Demonstration: The Read Mostly Database: Query the Standby, DML to the Primary, Transparently (07:19) (click on video below)

Date: Nov 7, 2012
click to read the Transcript

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.