Oracle Database 12c: Data Guard Administration Training Logo

Oracle Database 12c: Data Guard Administration Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Learn how it protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is 12c: Data Guard Administration Certification Training about?

This Oracle Database 12c: Data Guard Administration Ed 1 training teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtimes. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

You'll walk away from this course with an understanding of how Data Guard standby databases can be used to support various production functions. These functions include reporting, querying and testing, while in a standby role.

This course will also teach you about the new Oracle Data Guard 12c features and architecture. You'll get a chance to explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.

What are the objectives of 12c: Data Guard Administration Certification Training ?

  • 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

Who is 12c: Data Guard Administration Certification Training for?

  • Database Administrators
  • Support Engineer
  • Technical Consultant

What are the prerequisites for 12c: Data Guard Administration Certification Training?

Suggested Prerequisite

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

Required Prerequisite

  • Oracle Database 11g: Administration Workshop I Release 2
  • Oracle Database 11g: Administration Workshop II Release 2

Available Training Modes

Live Online Training

32 Hours

Classroom Training

4 Days

Course Outline Expand All

Expand All

  • Oracle Data Guard: Architecture(Overview)
  • Types of Data Guard Services
  • Role Transitions: Switchover and Failover
  • What Is Oracle Data Guard?
  • Choosing an Interface for Administering a Data Guard Configuration
  • Types of Standby Databases
  • Primary Database Processes
  • Oracle Data Guard Broker Framework
  • Listener.ora Configuration
  • Statics vs. Dynamic Registration
  • Static Entries for Broker Operations
  • Tnsnames.ora Configuration
  • Static Entries for Database Duplication and SQL Maintenence
  • Oracle Network Configuration Tuning
  • Networking Overview
  • Steps to Create a Physical Standby Database
  • Configuring Standby Redo Logs
  • Viewing Standby Redo Log Information
  • Creating Standby Redo Logs
  • FORCE LOGGING Mode
  • Using SQL to Create Standby Redo Logs
  • Setting Initialization Parameters on the Primary Database to Control Redo Transport
  • Preparing the Primary Database
  • Data Guard Broker: Components
  • Data Guard Broker: Configurations
  • Data Guard Monitor: DMON Process
  • Benefits of Using the Data Guard Broker
  • Oracle Data Guard Broker: Features
  • Comparing Configuration Management With and Without the Data Guard Broker
  • Data Guard Broker: Management Model
  • Data Guard Broker: Architecture
  • Data Guard Broker: Log Files
  • Creating a Broker Configuration
  • Data Guard Monitor: Configuration File
  • Data Guard Broker and the SPFILE
  • Adding a Standby Database to the Configuration
  • Data Guard Broker: Requirements
  • Defining the Broker Configuration and the Primary Database Profile
  • Enabling the Configuration
  • Standby Database Creation: Progress
  • Creating a Configuration
  • Adding a Standby Database to an Existing Configuration
  • Standby Database Creation: Processing
  • Using the Add Standby Database Wizard
  • Using Oracle Enterprise Manager to Create a Broker Configuration
  • Creating a New Configuration
  • Verifying a Data Guard Configuration
  • Benefits of Implementing a Logical Standby Database
  • Checking for Tables with Unsupported Data Types
  • Unsupported Objects
  • Preparing to Create a Logical Standby Database
  • Unsupported Data Types
  • Logical Standby Database: SQL Apply Architecture
  • SQL Apply Process: Architecture
  • Checking for Unsupported Tables
  • Snapshot Standby Database: Architecture
  • Converting a Physical Standby Database to a Snapshot Standby Database
  • Activating a Snapshot Standby Database: Issues and Cautions
  • Converting a Snapshot Standby Database to a Physical Standby Database
  • Viewing Snapshot Standby Database Information
  • Snapshot Standby Database: Target Restrictions
  • Using DGMGRL to View Snapshot Standby Database Information
  • Snapshot Standby Databases: Overview
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Configuring Zero Lag Between the Primary and Standby Databases
  • Using Real-Time Query
  • Oracle Active Data Guard
  • Setting a Predetermined Service Level for Currency of Standby Queries
  • Checking the Standby’s Open Mode
  • Understanding Lag in an Active Data Guard Configuration
  • Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
  • Maximum Availability Mode
  • Maximum Performance Mode
  • Maximum Protection Mode
  • Setting the Data Protection Mode
  • Data Protection Modes and Redo Transport Modes
  • Comparing Data Protection Modes
  • Setting the Data Protection Mode by Using DGMGRL
  • Switchover
  • Considerations When Performing a Switchover to a Logical Standby Database
  • Situations That Prevent a Switchover
  • Performing a Switchover by Using Enterprise Manager
  • Preparing for a Switchover
  • Role Transitions: Switchover and Failover
  • Performing a Switchover by Using DGMGRL
  • Role Management Services
  • Configuring Flashback Database by Using Enterprise Manager
  • Overview of Flashback Database
  • Using Flashback Database in a Data Guard Configuration
  • Flashback Through Standby Database Role Transitions
  • Using Flashback Database After RESETLOGS
  • Configuring Flashback Database
  • Using Flashback Database and Real-Time Apply
  • Using Flashback Database Instead of Apply Delay
  • Configuring Fast-Start Failover
  • Fast-Start Failover: Overview
  • Fast-Start Failover Prerequisites
  • Installing the Observer Software
  • Configuring the Primary Database to Shut Down Automatically
  • When Does Fast-Start Failover Occur?
  • Setting the Lag-Time Limit
  • Automatic Reinstatement After Fast-Start Failover
  • Creating Services for the Data Guard Configuration Databases
  • Understanding Client Connectivity: Using a Database Service
  • Adding Standby Databases to Oracle Restart Configuration
  • Managing Services
  • Understanding Client Connectivity: Using Local Naming
  • Preventing Clients from Connecting to the Wrong Database
  • Understanding Client Connectivity in a Data Guard Configuration
  • Configuring Role-Based Services
  • Setting Persistent Configuration Settings
  • Creating the Recovery Catalog
  • Offloading Backups to a Physical Standby
  • Registering a Database in the Recovery Catalog
  • Using RMAN to Back Up and Restore Files in a Data Guard Configuration
  • Restrictions and Usage Notes
  • Using the RMAN Recovery Catalog in a Data Guard Configuration
  • Backup and Recovery of a Logical Standby Database
  • Upgrading Oracle Database in a Data Guard Configuration with a Physical Standby Database
  • Upgrading Oracle Database in a Data Guard Configuration with a Logical Standby Database
  • Upgrading an Oracle Data Guard Broker Configuration
  • Performing a Rolling Upgrade by Using DBMS_ROLLING
  • Trailing Group Databases and Trailing Group Master
  • Leading Group Databases and Leading Group Master
  • Requirements for Using DBMS_ROLLING to Perform a Rolling Upgrade
  • Using DBMS_ROLLING to Upgrade the Oracle Database
  • Monitoring the Data Guard Configuration by Using Enterprise Manager Cloud Control
  • Data Guard Metrics
  • Managing Data Guard Metrics
  • Viewing Metric Value History
  • Viewing the Data Guard Configuration Status
  • Monitoring Data Guard Performance
  • Viewing Log File Details
  • Enterprise Manager Metrics and Alerts
  • Optimizing Redo Transmission by Setting MaxConnections
  • Setting the MaxConnections Database Property
  • Setting the ReopenSecs Database Property
  • Compressing Redo Data by Setting the RedoCompression Property
  • Delaying the Application of Redo
  • Setting the NetTimeout Database Property
  • Monitoring Configuration Performance by Using Enterprise Manager Cloud Control
  • Optimizing Redo Transport Services
  • Migrating to Exadata Cloud Service
  • Data Security & Management Responsibilities
  • Simple Web-Based Provisioning & Management
  • Introducing Exadata Cloud Service
  • Service Configuration, Connection, Architecture & Availability
  • Backup and Recovery
  • REST APIs
  • Storage Configuration & Management Details

Who is the instructor for this training?

https://www.springpeople.com/oracle-weblogic-server-11g-administration-essentials-training

Course Logo

12c: Data Guard Administration Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews