Oracle 11g Data Guard R2

Course code: O1051

4 days £1,680.00

Oracle 11g R2 Data Guard training course, delegates will learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes.

Course content >

Who Should Attend?

  • Database Administrators
  • Support Engineer
  • Technical Consultant


Course Reviews

Course Contents

The iTrain Oracle Database 11g Release 2 Data Guard course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations.

Oracle 11g R2 Data Guard training course will demonstrate to delegates how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role. The Oracle 11g R2 Data Guard training course includes Data Guard architecture, the configuration of a physical standby database, and role transitions.

Oracle 11g Data Guard R2 Training Course Contents

Oracle Data Guard Introduction

  • Requirements for Maintaining a
  • Standby Database
  • Describe the basics of
  • Data Guard
  • Role Management Services
  • High availability usage of Data Guard architecture
  • Considerations of planned and unplanned down time
  • Types of Standby Databases
  • Data Guard Installation
  • Standby Database Creation

Oracle Data Guard Architecture

  • Data Guard Configuration
  • Architectural Components
  • Operational requirements of Data Guard
  • Data Guard Apply Modes
  • Archive Gap Sequence

Log Management Services

  • How Redo data is sent
  • Control Redo Data
  • Handle Transmission Errors
  • Manage Archive Gap
  • Data protection modes
  • Service Configuration Options

Oracle Data Guard Environment

  • Understanding the differences of configuration with Data Guard
  • Initialization parameters
  • Data Guard views
  • Performance configurations

Implementing Standby Databases

  • Prepare the Primary Database
  • Datafile & Controlfile Duplication
  • Create Standby Instance
  • Archive Log Loss
  • Database Switchover
  • Monitoring the Primary & Standby Databases

Role Transition Commands

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

Oracle Data Guard 11g R2 Extensions

  • Support for the Oracle Active Data Guard Option
  • Failover enhancements
  • Enhanced data protection
  • Redo Transport enhancements
  • Apply performance enhancements
  • Transient Logical Standby
  • RMAN enhancements for Data Guard
  • Enhanced security
  • Enhanced SQL Apply support
  • SQL Apply Manageability
Contact us for more information