Más información

Contacto: Eva Lupi.
Email: elupi@axigmatechnologies.com
Teléfono: +54 11 5355 2900 de 10 a 17 hs.

Fechas y Registro

Fecha:

25 de enero del 2010 al 27 de enero del 2010

Horario

de 9 a 17 hs.

Duración del curso

3 días

Lugar

Buenos Aires, Argentina

Para más información:

eva.lupi@axigmatechnologies.com

Database 10g: Data Guard Administration

Course Objectives

  • Use Data Guard to achieve a highly available Oracle Database
  • Describe the Data Guard architecture
  • Modify the Data Guard services
  • Use the Data Guard broker
  • Implement physical and logical standby databases
  • Perform failover and switchover operations
  • Enable fast-start failover

Learn To

  • Use Data Guard to achieve a highly available Oracle Database
  • Create physical and logical standby databases
  • Use Enterprise Manager Grid Control to manage the Data Guard configuration

Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant

Suggested Prerequisites

Course Topics

Oracle Data Guard Overview

  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Data Guard Broker Framework
  • Types of Services
  • Benefits of Implementing Oracle Data Guard

Understanding the Oracle Data Guard Architecture

  • Oracle Data Guard Architecture
  • Data Guard Redo Apply Architecture
  • Data Guard SQL Apply Architecture
  • Specifying Role-based Destinations
  • Configuring Standby Redo Logs
  • Standby Database Modes

Using Oracle Data Guard Broker and Enterprise Manager

  • Oracle Data Guard Broker Features
  • Data Guard Broker Configurations
  • Benefits of Using the Data Guard Broker
  • Data Guard Broker Interfaces
  • Using Enterprise Manager 10g Grid Control

Creating a Configuration and Physical Standby Database by Using Enterprise Manager

  • Using Enterprise Manager to Create a Broker Configuration
  • Using the Add Standby Database Wizard
  • Creating a Physical Standby Database
  • Verifying a Configuration
  • Creating Standby Redo Logs
  • Viewing the Data Guard Configuration Status
  • Viewing Data Guard Performance

Creating a Physical Standby Database by Using SQL

  • Preparing the Primary Database
  • Setting Initialization Parameters on the Primary Database
  • Backing Up the Primary Database Using RMAN
  • Creating a Control File for the Standby Database
  • Setting Initialization Parameters on the Standby Database
  • Setting Up the Environment to Support the Standby Database
  • Starting the Physical Standby Database
  • Performing Additional Configuration Tasks

Configuring Data Protection Modes and Log Transport Services

  • Setting the Log Transport Mode
  • Setting the Data Protection Mode
  • Delaying the Application of Redo
  • Using Flashback Database as an Alternative to Apply Delay
  • Additional Attributes that Affect Log Transport Services

Creating a Logical Standby Database by Using Enterprise Manager

  • Benefits of Implementing a Logical Standby Database
  • Preparing to Create a Logical Standby Database
  • Checking for Unsupported Objects and Data Types
  • Enabling Supplemental Logging
  • Creating a Logical Standby Database by using Enterprise Manager
  • Using the Add Standby Database Wizard
  • Enabling and Disabling the Auto-Delete Feature

Creating a Logical Standby Database by Using SQL

  • Preparing to Create a Logical Standby Database
  • Creating a Physical Standby Database
  • Preparing the Primary Database
  • Transitioning to a Logical Standby Database
  • Opening the Logical Standby Database
  • Verifying the Logical Standby Database
  • Performing Additional Configuration Tasks

Performing Switchover and Failover

  • Choosing the Best Role Transition Operation
  • Performing a Switchover by Using Enterprise Manager
  • Performing a Switchover by Using SQL
  • Performing a Failover by Using Enterprise Manager
  • Performing a Failover by Using SQL
  • Restoring Databases After a Role Transition
  • Flashback Through Standby Database Role Transitions

Enabling Fast-Start Failover

  • When Will Fast-Start Failover Occur?
  • Configuring Fast-Start Failover
  • Prohibited Operations After Enabling Fast-Start Failover
  • Managing the Observer
  • Performing Role Changes
  • Using Enterprise Manager to Enable Fast-Start Failover

Using Data Guard in a Real Application Clusters Configuration

  • Real Application Clusters and Data Guard
  • Configuration Considerations with RAC
  • Configuring a Primary Database with RAC
  • Configuring a Standby Database with RAC
  • Apply Instance Failover
  • Role Transitions with RAC

Other Considerations for Oracle Data Guard

  • Using a Physical Standby Database for Read/Write Testing and Reporting
  • Offloading Backups to a Physical Standby Database
  • Using Flashback Database and Real-time Apply
  • Using Flashback Database After RESETLOGS
  • Enabling Redo Encryption
  • Configuring Cascaded Redo Log Destinations

Workshop

  • Workshop Premise
  • Workshop Flow
  • Workshop Scenarios