Oracle DataGuard

Reading Time: 4 minutes

Oracle Dataguard

    Module 1 : Introduction to Oracle Data Guard

    • Describe the basic components of Oracle Data Guard
    • Explain the differences between physical and logical standby databases
    • Explain the benefits of implementing Oracle Data Guard

    Module 2 : Creating a Physical Standby Database by Using Enterprise Manager Cloud Control

    • Create a Data Guard broker configuration
    • Create a physical standby database
    • Verify a Data Guard configuration
    • Edit database properties related to Data Guard
    • Test a Data Guard configuration

    Module 3 : Oracle Net Services in a Data Guard Environment

    • Understand the basics of Oracle Net Services
    • Configure client connectivity in a Data Guard configuration
    • Implement Data Guard best practice solutions in networking setup

    Module 4 : Creating a Physical Standby Database by Using SQL and RMAN Commands

    • Configure the primary database and Oracle Net Services to support the creation of the physical standby database and role transition
    • Create a physical standby database by using the

    Module 5 : Using Oracle Active Data Guard

    • Use real-time query to access data on a physical standby database
    • Enable RMAN block change tracking for a physical standby database
    • Use Far Sync to extend zero data loss protection for intercontinental configurations

    Module 6 : Creating and Managing a Snapshot Standby Database

    • Create a snapshot standby database to meet the requirement for a temporary, updatable snapshot of a physical standby database
    • Convert a snapshot standby database back to a physical standby database

    Module 7 : Creating a Logical Standby Database

    • Determine when to create a logical standby database
    • Create a logical standby database
    • Manage SQL Apply filtering

    Module 8 : Oracle Data Guard Broker: Overview

    • The Data Guard broker architecture
    • Data Guard broker components
    • Benefits of the Data Guard broker
    • Data Guard broker configurations
    • How to use Enterprise Manager to manage your Data Guard configuration
    • How to invoke DGMGRL to manage your Data Guard configuration

    Module 9 : Creating a Data Guard Broker Configuration

    • Create a Data Guard broker configuration
    • Manage the Data Guard broker configuration

    Module 10 : Monitoring a Data Guard Broker Configuration

    • Use Enterprise Manager Cloud Control to monitor the configuration
    • Use DGMGRL to monitor the configuration
    • Use SQL to monitor the configuration

    Module 11 : Configuring Data Protection Modes

    • Describe the data protection modes
    • Change the data protection mode of your configuration
    • Using Enterprise Manager Cloud Control
    • Using DGMGRL
    • Using SQL

    Moudle 12 : Performing Role Transitions

    • Explain the database roles
    • Perform a switchover
    • Perform a failover

    Module 13 : Using Flashback Database in a Data Guard Configuration

    • Explain the advantages of using Flashback Database in a Data Guard configuration
    • Configure Flashback Database

    Module 14 : Enabling Fast-Start Failover

    • Configure fast-start failover
    • View information about the fast-start failover configuration
    • Manage the observer
    • Perform role changes in a fast-start failover configuration
    • Manually reinstate the primary database

    Module 15 : Backup and Recovery Considerations in an Oracle Data Guard Configuration

    • Use Recovery Manager (RMAN) to back up and restore files in a Data Guard configuration
    • Offload backups to a physical standby database
    • Recover your primary database by using a file from the physical standby database

    Module 16 : Enhanced Client Connectivity in a Data Guard Environment

    • Configure client connectivity in a Data Guard configuration
    • Implement failover procedures to automatically redirect clients to a new primary database

    Module 17 : Patching and Upgrading Databases in a Data Guard Configuration

    • By using Standby-First Patch Apply technique
    • By using traditional upgrade methods
    • By performing rolling upgrades
    • By using the DBMS_ROLLING package with Active Data Guard

    Module 18 : Optimizing a Data Guard Configuration

    • Monitor configuration performance
    • Optimize redo transport for best performance
    • Optimize SQL Apply

    Module 19 : Oracle Database Exadata Cloud Service Overview

    • Describe the architecture and capabilities of Exadata Cloud Service
    • Compare and contrast between Exadata Cloud Service and an on-premise Exadata implementation