Oracle 19c Data Guard (ODG 19c) (TTOR30519)

Gain the skills required to effectively implement, manage, and optimize Data Guard environments for optimal database protection and disaster recovery

TTOR30519

Intermediate

3 Days

Course Overview

Oracle 19C Data Guard is a three-day hands-on course, designed provide you with a thorough understanding of this powerful technology, equipping you with the skills needed to create, manage, and optimize your Oracle Data Guard environment. Whether you're a seasoned professional or new to the field, our expert-led sessions will empower you to take control of your data and enhance your organization's resilience and performance.

Throughout the course, you'll gain valuable insights into the various types of standby databases, Data Guard services, and data protection modes. You'll explore Oracle Net Services in a Data Guard environment, learning about local naming configuration files, connect-time failover, and dynamic service registration. In addition, our hands-on exercises will guide you through the process of creating physical and logical standby databases, managing files, and optimizing your Data Guard configuration. By the end of the course, you'll be well-versed in implementing and managing Oracle Active Data Guard, enabling Fast-Start Failover, and utilizing Flashback Database in your Data Guard setup.

Don't miss this opportunity to elevate your career and unlock the potential of Oracle Data Guard. Our interactive course offers a valuable blend of theoretical knowledge and practical application, ensuring that you leave with a deep understanding of the technology and its real-world applications. With our expert instructors by your side, you'll gain the confidence and expertise needed to harness the power of Oracle Data Guard, maximizing your organization's data protection and availability.

NOTE: This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas.  This course is for 19c.

Learning Objectives

Working in a hands-on learning environment led by our expert facilitator, you’ll explore:

  • Understand the concepts of Oracle Data Guard architecture
  • Create, manage, and monitor Physical and Logical Standby databases
  • Implement and manage Data Guard Broker
  • Perform Role Transitions: Switchover and Failover
  • Implement Fast-Start Failover
  • Implement Oracle Active Data Guard
  • Create and manage Snapshot Standby database
  • Implement client failover in a Data Guard Configuration
  • Use RMAN in a Data Guard environment
  • Understand the advanced options in Oracle Data Guard

Course Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, you’ll explore:

  • Understand the concepts of Oracle Data Guard architecture
  • Create, manage, and monitor Physical and Logical Standby databases
  • Implement and manage Data Guard Broker
  • Perform Role Transitions: Switchover and Failover
  • Implement Fast-Start Failover
  • Implement Oracle Active Data Guard
  • Create and manage Snapshot Standby database
  • Implement client failover in a Data Guard Configuration
  • Use RMAN in a Data Guard environment
  • Understand the advanced options in Oracle Data Guard

Need different skills or topics?  If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate.  We offer additional Oracle, database, scripting, administration and other related topics that may be blended with this course for a track that best suits your needs.

Course Prerequisites

Audience

This course is designed to introduce Oracle Data Guard to experience attendees who are new to Data Guard. Attendees would include experienced:

  • Database Administrators (DBAs) who are responsible for managing and maintaining Oracle databases and seeking to enhance their knowledge of data protection and disaster recovery solutions.
  • IT professionals working in the areas of data management, data protection, and disaster recovery who want to gain a solid understanding of Oracle Data Guard and its applications.
  • System administrators and architects responsible for designing, implementing, and managing high availability and disaster recovery solutions for Oracle databases.
  • IT managers and decision-makers who want to learn about Oracle Data Guard to make informed choices when implementing data protection and disaster recovery strategies in their organizations.

Pre-Requisites

In order to gain the most from this hands-on course, you should have:

  • Basic understanding of Oracle database concepts: Participants should have a foundational knowledge of Oracle databases, including database architecture, storage structures, and SQL.
  • Familiarity with database administration tasks: Prior experience or understanding of essential database administration tasks, such as backup and recovery, performance tuning, and security management, will be beneficial for grasping the course content.
  • Experience with Oracle Database environment: It is helpful if participants have some hands-on experience with Oracle Database, particularly in creating and managing databases, as it will enable them to better understand the concepts and practices discussed in the course.
  • Knowledge of the Linux operating system

Take Before: To be successful in the course, you should have skills equivalent to the topics in the course below or should have attended it as a pre-requisite:

  • TTOR20519 Oracle 19c Database Administration I (Oracle 19c DBA I)

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience needs and skill-level.

  1. Introduction to Oracle Data Guard
  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Types of Data Guard Services
  • Data Protection Modes
  • Benefits of Implementing Oracle Data Guard
  1. Oracle Net Services in a Data Guard Environment
  • Oracle Net Services Overview
  • Local Naming Configuration Files
  • Connect-Time Failover
  • Dynamic Service Registration
  1. Creating a Physical Standby Database
  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • Database Nologging Enhancements
  • Using SQL to Create Standby Redo Logs
  • Specifying Role-Based Destinations
  • Creating Directories for the Physical Standby Database
  • Real-Time Apply
  • Creating a Physical Standby by Using SQL
  1. Managing Physical Standby Files
  • Action Required on Physical Standby
  • Using Transportable Tablespaces 
  • Renaming a Data File in the Primary Database
  • Adding or Dropping a Redo File Group
  • Refreshing the Password File
  • Controlling PDB Replication
  1. Using Oracle Active Data Guard
  • Oracle Active Data Guard
  • Enabling and Disabling Real-Time Query
  • Monitoring Apply Lag
  • Forcing Redo Apply Synchronization
  • DDL on Global Temporary Tables
  • Support for Session Sequences
  • Example: Performing DML on a Physical Standby
  1. Using Oracle Active Data Guard
  • Far Sync: Redo Transport
  • Far Sync Instance Creation by Using RMAN
  • Benefits: Far Sync
  • Far Sync: Alternate Design
  • Real-Time Cascade and benefits
  1. Creating and Managing a Snapshot Standby Database
  • Issues and Cautions
  • Target Restrictions
  • Viewing Snapshot Standby Database Information
  • Snapshot Standby Space Requirements
  1. Creating a Logical Standby Database
  • SQL Apply Architecture
  • SQL Apply Process: Architecture
  • Unsupported Objects
  • Identifying Internal Schemas
  • Checking for Tables with Unsupported Data Types
  • Ensuring Unique Row Identifiers
  • Creating a Logical Standby Database by Using SQL Commands
  • Creating SQL Apply Filtering Rules
  • Viewing SQL Apply Filtering Settings
  1. Oracle Data Guard Broker
  • Data Guard Broker: Components
  • Management Model
  • DMON Process
  • Data Guard Broker Interfaces
  • Data Guard Overview Page
  • Benefits of Using Enterprise Manager
  1. Creating a Data Guard Broker Configuration
  • Data Guard Broker: Requirements
  • Data Guard Broker and the SPFILE
  • Log Files
  • Creating a Broker Configuration
  • Adding a Far Sync to the Configuration
  • Far Sync Example with RedoRoutes
  • Setting LogXptMode to SYNC
  • Example: SET TRACE_LEVEL command
  • Export/Import Broker Configuration
  1. Monitoring a Data Guard Broker Configuration
  • Monitoring Data Guard Performance
  • Viewing Log File Details
  • Data Guard Metrics
  • Viewing Metric Value History
  • The VALIDATE DATABASE DATAFILE Command
  • New Data Guard Broker Commands
  • Identifying Destination Settings
  1. Configuring Data Protection Modes
  • Data Protection Modes
  • Maximum Availability Mode
  • Comparing Data Protection Modes
  • Setting the Data Protection Mode by Using DGMGRL
  • Setting the Data Protection Mode by Using SQL
  1. Optimizing and Tuning a Data Guard Configuration
  • Optimizing Redo Transport Services
  • Delaying the Application of Redo
  • Optimizing SQL Apply
  • Adjusting the Number of PREPARER Processes
  • Diagnostic Tools in Active Data Guard
  1. Performing Role Transitions
  • Role Management Services
  • Switchover
  • Performing a Switchover by Using Enterprise Manager
  • Performing a Switchover by Using DGMGRL
  • Situations That Prevent a Switchover 
  • Failover and types
  • Performing a Failover to a Physical Standby Database
  1. Using Flashback Database in a Data Guard Configuration
  • Configuring Flashback Database
  • Using Flashback Database and Real-Time Apply
  • Using Flashback Database After Failover
  • Automatic Flashback on Physical Standby Databases
  1. Enabling Fast-Start Failover
  • When Does Fast-Start Failover Occur?
  • Installing the Observer Software
  • Configuring Fast-Start Failover
  • Specify the Target Standby Databases
  • Set the Protection Mode
  • Set the Fast-Start Failover Threshold
  • Setting the Lag-Time Limit
  • Configure Additional Fast-Start Failover Conditions
  • Enable Fast-Start Failover
  • Enable Fast-Start Failover
  • Verify the Configuration
  • Disabling Fast-Start Failover
  • Using Enterprise Manager to Enable Fast-Start Failover
  1. Backup and Recovery Considerations
  • Offloading Backups to a Physical Standby
  • Restrictions and Usage Notes
  • Creating the Recovery Catalog
  • Configuring Daily Incremental Backups 
  • Enhancements to Block Media Recovery
  • Excluding the Standby Database
  1. Enhanced Client Connectivity
  • Connecting to the Appropriate Environment
  • Managing Services
  • Connecting Clients to the Correct Database
  • Example: Configuring Role-Based Services
  • Client Failover: Components
  • What Is Application Continuity?
  • Configuring Client
  1. Patching and Upgrading Databases
  • Data Guard Standby-First Patch Apply
  • Using SQL Apply to Upgrade the Oracle Database
  • Identifying Unsupported Data Types
  • Cases
  • DBMS_ROLLING: Concepts
  • Examples
  • Rolling Upgrade Support for Multitenant Databases

Course Materials

Setup Made Simple with our robust Learning Experience Platform (LXP)

All course software (limited versions, for course use only), knowledge checks, digital courseware files or course notes, labs / data sets and solutions, live coaching support channels (as applicable) and rich extended learning / post training resources are provided for you in our “easy access / no install required” high-speed Learning Experience Platform (LXP) remote lab and content environment. Our tech team works with every student to ensure everyone is set up with working access and ready to go prior to every course start date, ensuring a smooth delivery and great hands-on experience.

Every-Course Extras = High-Value & Long-Term Learning Support! All Public Schedule courses include our unique EveryCourse Extras package (Course Recordings, Live Instructor Follow-on Support, Free *Live* Course Refresh Re-Takes, early access to Special Offers, Free Courses & more). Please inquire for details.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Mix, Match & Master!
2FOR1: Two Courses, One Price!

Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price!  Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More