Oracle Data Guard 19c

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)

$2,395.00

*Looking for flexible schedule (after hours or weekend)? Please call or email us: 858-208-4141 or sales@ccslearningacademy.com.
Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Qty:
Category:

Download PDF of Course Details

Course Description:

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.

 

Course Topics

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

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

Target Audience

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

Lab 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

Inclusions

With CCS Learning Academy, you’ll receive:

  • Certified Instructor-led training
  • Official Training Seminar Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*

*For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com