MyGK
Support
USA USA - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Contact Sales
Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

Oracle Data Guard 19c

Explore the latest features and functions in ODG.

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.

GK# 100730 Vendor# Oracle Data Guard 19
Vendor Credits:
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.

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

 

What You'll Learn

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

 

Course 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

 

Labs Outline

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

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