Certified and Advanced Degree
Computer Instructors and Consultants
Course Catalog
Oracle Data Guard 19c (TTOR05219)
Code: Oracle Data Guard
Duration: 3 Day
$2495 USD

OVERVIEW

Oracle 19c Data Guard is a three day hands on course where students will gain experience working with the latest features and functions in ODG.

DELIVERY FORMAT

This course is available in the following formats:

Virtual Classroom

Duration: 3 Day
Classroom

Duration: 3 Day

CLASS SCHEDULE
Call 800-798-3901 to enroll in this class!

GOALS

Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:

  • Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  • Create and manage physical and logical standby databases
  • Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  • Use Data Guard to achieve a highly available Oracle database
  • Gain an understanding of Oracle Database Exadata Cloud Service

 

OUTLINE

Introduction to Oracle Data Guard

  • Basic components of Oracle Data Guard
  • Physical and logical standby databases
  • Benefits of implementing Oracle Data Guard

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

  • Data Guard broker configuration
  • Physical standby database
  • Data Guard configuration
  • Database properties
  • Data Guard configuration

Oracle Net Services in a Data Guard Environment

  • Basics of Oracle Net Services
  • Client connectivity
  • Data Guard best practice solutions

Creating a Physical Standby Database by Using SQL and RMAN Commands

  • Primary database and Oracle Net Services
  • Physical standby database

Using Oracle Active Data Guard

  • Real-time query
  • RMAN block change tracking
  • Far Sync

Creating and Managing a Snapshot Standby Database

  • Snapshot standby database
  • Converting a snapshot standby database

Creating a Logical Standby Database

  • Creating a logical standby database
  • SQL Apply filtering

Oracle Data Guard Broker: Overview

  • Data Guard broker architecture
  • Data Guard broker components
  • Benefits of the Data Guard broker
  • Data Guard broker configurations
  • Enterprise Manager
  • DGMGRL

Creating a Data Guard Broker Configuration

  • Monitoring a Data Guard Broker Configuration
  • Enterprise Manager Cloud Control
  • DGMGRL
  • SQL

Configuring Data Protection Modes

  • Describing the Data Protection Modes
  • Changing the Data Protection Modes

Performing Role Transitions

  • Database roles
  • Switchover
  • Failover

Using Flashback Database in a Data Guard Configuration

  • Advantages of using Flashback Database
  • Configuring Flashback Database

Enabling Fast-Start Failover

  • Fast-start failover
  • Fast-start failover configuration
  • Observer
  • Role changes
  • Reinstating the primary database

Backup and Recovery Considerations in an Oracle Data Guard Configuration

  • Recovery Manager (RMAN)
  • Offload backups
  • Recovering primary database

Enhanced Client Connectivity in a Data Guard Environment

  • Client Connectivity in a Data Guard Environment
  • Failover procedures

Patching and Upgrading Databases in a Data Guard Configuration

  • Standby-First Patch Apply technique
  • Traditional upgrade methods
  • Rolling upgrades
  • DBMS_ROLLING

Optimizing a Data Guard Configuration

  • Monitoring configuration performance
  • Redo transport
  • SQL Apply

Oracle Database Exadata Cloud Service Overview

  • Architecture and capabilities of Exadata Cloud Service
  • Exadata Cloud Service and an on-premise Exadata implementation

 

Introduction to Oracle Data Guard

  • Basic components of Oracle Data Guard
  • Physical and logical standby databases
  • Benefits of implementing Oracle Data Guard

Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

  • Data Guard broker configuration
  • Physical standby database
  • Data Guard configuration
  • Database properties
  • Data Guard configuration

Oracle Net Services in a Data Guard Environment

  • Basics of Oracle Net Services
  • Client connectivity
  • Data Guard best practice solutions

Creating a Physical Standby Database by Using SQL and RMAN Commands

  • Primary database and Oracle Net Services
  • Physical standby database

Using Oracle Active Data Guard

  • Real-time query
  • RMAN block change tracking
  • Far Sync

Creating and Managing a Snapshot Standby Database

  • Snapshot standby database
  • Converting a snapshot standby database

Creating a Logical Standby Database

  • Creating a logical standby database
  • SQL Apply filtering

Oracle Data Guard Broker: Overview

  • Data Guard broker architecture
  • Data Guard broker components
  • Benefits of the Data Guard broker
  • Data Guard broker configurations
  • Enterprise Manager
  • DGMGRL

Creating a Data Guard Broker Configuration

  • Monitoring a Data Guard Broker Configuration
  • Enterprise Manager Cloud Control
  • DGMGRL
  • SQL

Configuring Data Protection Modes

  • Describing the Data Protection Modes
  • Changing the Data Protection Modes

Performing Role Transitions

  • Database roles
  • Switchover
  • Failover

Using Flashback Database in a Data Guard Configuration

  • Advantages of using Flashback Database
  • Configuring Flashback Database

Enabling Fast-Start Failover

  • Fast-start failover
  • Fast-start failover configuration
  • Observer
  • Role changes
  • Reinstating the primary database

Backup and Recovery Considerations in an Oracle Data Guard Configuration

  • Recovery Manager (RMAN)
  • Offload backups
  • Recovering primary database

Enhanced Client Connectivity in a Data Guard Environment

  • Client Connectivity in a Data Guard Environment
  • Failover procedures

Patching and Upgrading Databases in a Data Guard Configuration

  • Standby-First Patch Apply technique
  • Traditional upgrade methods
  • Rolling upgrades
  • DBMS_ROLLING

Optimizing a Data Guard Configuration

  • Monitoring configuration performance
  • Redo transport
  • SQL Apply

Oracle Database Exadata Cloud Service Overview

  • Architecture and capabilities of Exadata Cloud Service
  • Exadata Cloud Service and an on-premise Exadata implementation

 

LABS

Machine based practical labs and exercises. Student machines are required.

Machine based practical labs and exercises. Student machines are required.

WHO SHOULD ATTEND

This hands on course is geared for experienced Database Administrators who possess

  • Basic understanding of Oracle Database principles
  • Linux operating system fundamentals
  • Basic understanding of PL/SQL and Triggers

 

PREREQUISITES

  • Basic understanding of Oracle Database principles
  • Linux operating system fundamentals
  • Basic understanding of PL/SQL and Triggers