Oracle Database 12c Data Guard Administration

Duration: 
4 days
Codes: 
12C

Overview

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.

Audience

Each participant will leave with a recognised certificate

Course Outline

  • Introduction to Oracle Data Guard
  • What Is Oracle Data Guard?
  • Types of Standby Databases
  • Types of Data Guard Services
  • Role Transitions: Switchover and Failover
  • Oracle Data Guard Broker Framework
  • Choosing an Interface for Administering a Data Guard Configuration
  • Oracle Data Guard: Architecture(Overview)
  • Primary Database Processes
  • Networking for Oracle Data Guard
  • Networking Overview
  • Listener.ora Configuration
  • Statics vs. Dynamic Registration
  • Static Entries for Database Duplication and SQL Maintenence
  • Static Entries for Broker Operations
  • Oracle Network Configuration Tuning
  • Tnsnames.ora Configuration
  • Creating a Physical Standby Database by Using SQL and RMAN Commands
  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • FORCE LOGGING Mode
  • Configuring Standby Redo Logs
  • Creating Standby Redo Logs
  • Using SQL to Create Standby Redo Logs
  • Viewing Standby Redo Log Information
  • Setting Initialization Parameters on the Primary Database to Control Redo Transport
  • Oracle Data Guard Broker: Overview
  • Oracle Data Guard Broker: Features
  • Data Guard Broker: Components
  • Data Guard Broker: Configurations
  • Data Guard Broker: Management Model
  • Data Guard Broker: Architecture
  • Data Guard Monitor: DMON Process
  • Benefits of Using the Data Guard Broker
  • Comparing Configuration Management With and Without the Data Guard Broker
  • Creating a Data Guard Broker Configuration
  • Data Guard Broker: Requirements
  • Data Guard Broker and the SPFILE
  • Data Guard Monitor: Configuration File
  • Data Guard Broker: Log Files
  • Creating a Broker Configuration
  • Defining the Broker Configuration and the Primary Database Profile
  • Adding a Standby Database to the Configuration
  • Enabling the Configuration
  • Creating a Physical Standby Database by Using Enterprise Manager Cloud Control
  • Using Oracle Enterprise Manager to Create a Broker Configuration
  • Creating a Configuration
  • Creating a New Configuration
  • Adding a Standby Database to an Existing Configuration
  • Using the Add Standby Database Wizard
  • Standby Database Creation: Processing
  • Standby Database Creation: Progress
  • Verifying a Data Guard Configuration
  • Creating a Logical Standby Database
  • Benefits of Implementing a Logical Standby Database
  • Logical Standby Database: SQL Apply Architecture
  • SQL Apply Process: Architecture
  • Preparing to Create a Logical Standby Database
  • Unsupported Objects
  • Unsupported Data Types
  • Checking for Unsupported Tables
  • Checking for Tables with Unsupported Data Types
  • Creating and Managing a Snapshot Standby Database
  • Snapshot Standby Databases: Overview
  • Snapshot Standby Database: Architecture
  • Converting a Physical Standby Database to a Snapshot Standby Database
  • Activating a Snapshot Standby Database: Issues and Cautions
  • Snapshot Standby Database: Target Restrictions
  • Viewing Snapshot Standby Database Information
  • Using DGMGRL to View Snapshot Standby Database Information
  • Converting a Snapshot Standby Database to a Physical Standby Database
  • Using Oracle Active Data Guard
  • Oracle Active Data Guard
  • Using Real-Time Query
  • Checking the Standby's Open Mode
  • Understanding Lag in an Active Data Guard Configuration
  • Monitoring Apply Lag: V$DATAGUARD_STATS
  • Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM
  • Setting a Predetermined Service Level for Currency of Standby Queries
  • Configuring Zero Lag Between the Primary and Standby Databases
  • Configuring Data Protection Modes
  • Data Protection Modes and Redo Transport Modes
  • Maximum Protection Mode
  • Maximum Availability Mode
  • Maximum Performance Mode
  • Comparing Data Protection Modes
  • Setting the Data Protection Mode by Using DGMGRL
  • Setting the Data Protection Mode
  • Performing Role Transitions
  • Role Management Services
  • Switchover
  • Preparing for a Switchover
  • Performing a Switchover by Using DGMGRL
  • Performing a Switchover by Using Enterprise Manager
  • Considerations When Performing a Switchover to a Logical Standby Database
  • Situations That Prevent a Switchover
  • Using Flashback Database in a Data Guard Configuration
  • Using Flashback Database i

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA, ATO of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London London4 2400 £2400 2019-10-01
Bristol Bristol4 2400 £2400 2019-10-01
Devon Exeter4 2400 £2400 2019-10-01
London London4 2400 £2400 2019-10-01
Midlands Birmingham4 2400 £2400 2019-10-01
Edinburgh Edinburgh4 2400 £2400 2019-10-01
London London4 2400 £2400 2019-10-21
Bristol Bristol4 2400 £2400 2019-12-03
Devon Exeter4 2400 £2400 2019-12-03
Midlands Birmingham4 2400 £2400 2019-12-03
Edinburgh Edinburgh4 2400 £2400 2019-12-03
London London4 2400 £2400 2019-12-09
London London4 2400 £2400 2019-12-09