Oracle Database 10g and 11g Release 2 Data Guard

4 Day Course
Hands On
Code ODG

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite

This course introduces the delegate to the main architectural concepts of Data Guard. Delegates will learn how to use Oracle Data Guard to protect Oracle Databases against planned and unplanned downtime. They will also learn how to create and manage physical, logical and snapshot standby databases. They will also learn how to use standby databases in a standby role for reporting, querying and testing purposes.

This course is suitable for users of Oracle 9i, Oracle Database 10g and Oracle Database 11g.

This course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations.

The delegate will practise:

  • Preparing a Primary Database for a Data Guard Configuration
  • Creating a Physical Standby Database
  • Creating a Logical Standby Database
  • Creating a Snapshot Standby Database
  • Monitoring a Standby Database Configuration
  • Managing a Data Guard Configuration
  • Troubleshooting Standby Database Configurations
  • Tuning a Standby Database
  • Backing up and Recovering a Data Guard Configuration
  • Using Flashback in a Data Guard Configuration
  • Using the Data Guard Broker

Data Guard Overview (10 topics)

  • Requirements for Maintaining a Standby Database
  • Data Guard Terminology
  • Levels of Protection
  • Data Guard Monitor
  • Physical and Logical Standby Databases
  • Role Management Services
  • Failover and Switchover
  • Data Guard Interfaces
  • Standby Database Creation
  • Data Guard Installation

Data Guard Architecture (6 topics)

  • Data Guard Configurations
  • Data Guard Architecture
  • Log Transport Services
  • Log Apply Services
  • Processes Active in Standby Configurations
  • Data Guard Architecture and Initialization Processes

Create a Physical Standby Database with SQL Commands (11 topics)

  • Prepare the Primary Database
  • Datafile and Controlfile Duplication
  • Initialization Parameters for a Standby Database
  • Create the Standby Instance
  • Networking Issues
  • Verify Primary and Standby Databases are Working
  • Archive Log Loss
  • Database Switchover
  • Run the Data Guard Configuration
  • Shut Down and Start Up the Data Guard Environment
  • Monitor the Primary and Standby Databases

Redo Transport Services (5 topics)

  • How Data Guard Sends Redo Data
  • Control when Redo Data is Sent
  • Handle Transmission Errors
  • Manage Archive Gaps
  • Levels of Protection

Redo Apply Services (2 topics)

  • Apply Services Configuration Options
  • Terminate Redo Apply Services

Role Transition Using SQL Commands (5 topics)

  • Preparing the Primary Database
  • Preparing the Standby Database
  • Switchover
  • Failover
  • The Failed Primary

Change Management (6 topics)

  • Adding Datafiles or Tablespaces
  • Dropping Datafiles or Tablespaces
  • Transportable Tablespaces
  • Renaming Datafiles
  • Adding or Dropping Redo Log Files
  • Nologging Operations

Create a Standby Database with Recovery Manager (4 topics)

  • Create a Suitable Backup with RMAN
  • Standby Path and File Names
  • Build the Standby Instance
  • Build the Standby Database with RMAN

Creating a Logical Standby Using SQL Commands (8 topics)

  • Preparing the Primary
  • Convert Physical Standby to Logical Standby
  • Rebuild the Password File
  • Start the Standby Instance
  • Verify Primary and Standby Databases are Working
  • Real Time Apply
  • Useful Dictionary Views
  • Monitoring SQL Apply Progress

Managing a Logical Standby Database (10 topics)

  • SQL Apply Architecture
  • Transaction Size Considerations
  • DML and DDL Apply Considerations
  • Intercept DDL Statements
  • Skip DML and DDL on the Standby
  • Modify a Logical Standby Database
  • Materialized Views
  • Table Instantiation
  • Restart SQL Apply
  • Customize DBA_LOGSTDBY_EVENTS

Managing a Logical Standby Database (10 topics)

  • SQL Apply Architecture
  • Transaction Size Considerations
  • DML and DDL Apply Considerations
  • Intercept DDL Statements
  • Skip DML and DDL on the Standby
  • Modify a Logical Standby Database
  • Materialized Views
  • Table Instantiation
  • Restart SQL Apply
  • Customize DBA_LOGSTDBY_EVENTS

Tuning a Standby Database (7 topics)

  • Overview of Tuning a Standby Database
  • Tables without Primary Keys
  • Statistics on the Logical Standby
  • Transaction Consistency
  • Adjusting the Number of Applier Processes
  • Adjusting the Number of Preparer Processes
  • Tuning the Memory for the LCR Cache

Backup and Recovery Considerations (7 topics)

  • Backup and Recovery Strategy
  • Backup the Primary Database with a Physical Standby Database
  • Backup a Logical Standby Database
  • Recovery from Loss of Datafiles
  • Recovery from Loss of Control Files
  • Loss of Online Redo Logs
  • Flashback Database Features in a Data Guard Configuration

Data Guard Broker Overview (6 topics)

  • Oracle Enterprise Manager
  • Command Line Interface
  • Data Guard Monitor
  • Installing Data Guard
  • Using the Data Guard Broker
  • Starting up the Data Guard Broker

Build aa Configuration Using the Broker (4 topics)

  • Preparation
  • Configuring the Primary System
  • Configuring the Standby System
  • Enable and Disable the Configuration

Manage a Configuration Using the Broker (7 topics)

  • Database Properties
  • Set the Configuration Protection Mode
  • Configure Fast Start Failover
  • Execute a Switchover
  • Execute a Failover
  • Alter the state of a Database
  • Monitor the Configuration

Data Guard and Oracle Enterprise Manager (6 topics)

  • Access the Data Guard User Interface
  • Configure fast Start Failover
  • Execute a Switchover
  • Execute a Failover
  • Alter the state of a Database
  • Monitor the Configuration
A working knowledge of Oracle Database Administration is required. This can be obtained by attendance of the pre-requisite courses.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor

  • Oracle Database 10g DBA - Part I

    A 5-day Training Course on Oracle Database 10g DBA - Part I; provides the skills to maintain successful & efficient day-to-day operations of an Oracle database

    course code O10GDBAI Onsite available
  • Oracle Database 10g DBA - Part II

    A 5-day Training Course on Oracle Database 10g DBA - Part II; introduces delegates to the main concepts of Oracle backup and recovery

    course code O10GDBAII Onsite available
CodeLocationDurationPrice Oct Nov Dec Jan Feb Mar
O11GDG 4 Days $2,715
Ask a Question

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course