O1051 - Oracle 11g Data Guard

Availability

DateDurationPriceLocationEnrolment
09/23/122920LondonPlease phone 01275 859666
09/19/122920ReadingPlease phone 01275 859666
09/09/122920EdinburghPlease phone 01275 859666
10/17/122920LondonPlease phone 01275 859666
09/30/122920ReadingPlease phone 01275 859666
10/10/122920EdinburghPlease phone 01275 859666

Training Course Objectives

In this course, delegates learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role. The course includes Data Guard architecture, the configuration of a physical standby database, and role transitions.

Training Course Contents

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 New Feat

  • 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

Who Should Attend

  • Database Administrators
  • Support Engineer
  • Technical Consultant

Pre Requisites

  • Oracle SQL
  • O1032 Oracle 11g Backup & Recovery