Oracle Database 12c Data Guard

Oracle Database 12c Data Guard

4 days @ £1,895.00 exc. VAT 

Course Code: O12CDG

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 24 Oct 2017 Spaces StayAhead - Course Running Book
London 15 Jan 2018 Filling StayAhead - Course Running Book
London 26 Mar 2018 Spaces StayAhead - Course Running Book
London 29 May 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 30 Jul 2018 Spaces StayAhead - Course Running Book
London 09 Oct 2018 Spaces StayAhead - Course Running Book

S10

Oracle Database 12c Data Guard Course Overview

This course introduces the delegate to the main architectural concepts of Data Guard. Delegates will learn how to use Oracle Data Guard to protect Oracle Databases against planned and unplanned downtime. They will learn how to create and manage physical, logical and snapshot standby databases. They will also learn how to use standby databases in a standby role for reporting, querying and testing purposes.

The Oracle Database 12c Data Guard course is also suitable for users of Oracle Database 11gR2 Data Guard.

Skills Gained

The delegate will practise:

  • Preparing a Primary Database for a Data Guard Configuration
  • Creating a Physical Standby Database
  • Creating a Logical Standby Database
  • Creating a Snapshot Standby Database
  • Monitoring a Standby Database Configuration
  • Managing a Data Guard Configuration
  • Troubleshooting Standby Database Configurations
  • Tuning a Standby Database
  • Backing up and Recovering a Data Guard Configuration
  • Using Flashback in a Data Guard Configuration
  • Using the Data Guard Broker
  • Managing a Configuration using the Broker
  • Overview of Patching and Upgrading

Who will the Course Benefit?

The Oracle Database 12c Data Guard course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations.

Course Objectives

The Oracle Database 12c Data Guard course aims to provide the skills needed to plan, implement, manage and troubleshoot Oracle Data Guard standby database configurations.

Requirements

A working knowledge of Oracle Database Administration is required. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended. These skills can be obtained by attending the pre-requisite courses.


Oracle Database 12c Data Guard Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: DATA GUARD OVERVIEW

  • Overview of Data Guard
  • Requirements for Maintaining a Standby Database
  • Data Guard Terminology
  • Types of Standby Databases
  • Levels of Protection
  • Physical, Logical and Snapshot Standby Databases
  • Role Transition Management Services
  • Data Guard Interfaces
  • Standby Database Creation
  • Data Guard Installation
  • SYSDG Administrative Privilege for Data Guard Operations

Session 2: DATA GUARD ARCHITECTURE

  • Data Guard Architecture
  • Processes Active on the Primary Database
  • Processes Active on the Standby Database
  • Data Guard Architecture and Initialization Parameters
  • Data Guard usage with a Multitenant Database
  • PDB Creation and Cloning in a Multitenant Architecture Environment

Session 3: CREATE A PHYSICAL STANDBY DATABASE WITH SQL COMMANDS

  • Prepare the Primary Database for Data Guard
  • Initialization Parameters for the Standby Database
  • Datafile and Controlfile Duplication
  • Create the Standby Instance
  • Network Files Configuration
  • Activate the Standby Database
  • Verify Primary and Standby Databases are Working
  • Archive Log Loss
  • Open the Standby Database
  • Shut Down and Start Up the Data Guard Environment
  • Active Data Guard
  • Far Sync Instance
  • Monitor the Primary and Standby Databases

Session 4: REDO TRANSPORT SERVICES

  • Overview of Redo Transport Services
  • How Data Guard Sends Redo Data
  • Control when Redo Data is Sent with the VALID_FOR Option
  • Handle Transmission Errors
  • Manage Archive Gaps
  • Levels of Protection
  • Fast-Sync Mode

Oracle Database 12c Data Guard Training Course

Session 5: REDO APPLY SERVICES

  • Overview of Log Apply Services
  • Apply Redo Data Immediately
  • Delay Redo Data Application
  • Terminate Redo Apply Services
  • Configure a Cascading Standby Database
  • Create a Snapshot Standby Database

Session 6: ROLE TRANSITION USING SQL COMMANDS

  • Role Transition Overview
  • Prepare the Primary Database
  • Prepare the Standby Database
  • Perform a Switchover
  • Perform a Failover
  • Reinstate the Failed Primary
  • Overview of Application Continuity in a Data Guard Environment

Session 7: CHANGE MANAGEMENT

  • Change Management Overview
  • Add Datafiles or Tablespaces
  • Drop Tablespaces and Delete Datafiles
  • Transportable Tablespaces
  • Rename Datafiles
  • Add or Drop Redo Log Files
  • Nologging Operations
  • Lost Write Detection

Session 8: CREATE A STANDBY DATABASE WITH RECOVERY MANAGER

  • Overview of Standby Database Creation with RMAN
  • Create a Suitable Backup with RMAN
  • Standby Path and File Names
  • Build the Standby Instance
  • Create a Standby Database with RMAN

Session 9: CREATING A LOGICAL STANDBY USING SQL COMMANDS

  • Overview of Creating a Logical Standby Database using SQL Commands
  • Prepare the Primary Database
  • Prepare the Standby Database
  • Transition a Physical Standby to a Logical Standby
  • Start the Standby Instance
  • Real Time Apply
  • Delete Archives
  • Dictionary Views Containing useful Standby Information
  • Monitor the SQL Apply Progress

Oracle Database 12c Data Guard Training Course

Session 10: MANAGING A LOGICAL STANDBY DATABASE

  • Overview of SQL Apply Architecture
  • Transaction Size Considerations
  • DML and DDL Apply Considerations
  • Intercept DDL Statements
  • Skip DML and DDL on the Standby Database
  • Modify a Logical Standby Database
  • Materialized Views on the Primary Database
  • Table Instantiation
  • Restart SQL Apply
  • Customize DBA_LOGSTDBY_EVENTS
  • Rolling Upgrades using Logical Standby
  • Rolling Upgrades on a Physical Standby
  • Job Scheduling on a Logical Standby

Session 11: TUNING A STANDBY DATABASE

  • Overview of Tuning a Physical Standby Database
  • Temporary Undo, Global and Session Variables
  • The Significance of Tables without Primary Keys
  • Statistics on the Logical Standby
  • Transaction Consistency
  • Adjusting the Number of Applier Processes
  • Adjusting the Number of Preparer Processes
  • Tune the Memory for the LCR Cache
  • Set the ReopenSecs and NetTimeout Database Properties
  • Compress Redo Transmission
  • Optimize SQL Apply
  • Optimize Redo Apply

Session 12: BACKUP AND RECOVERY CONSIDERATIONS IN AN ORACLE DATA GUARD CONFIGURATION

  • Implement a Backup and Recovery Strategy
  • The Usage of RMAN in a Data Guard Configuration
  • Backup and Recovery of a Primary Database with a Physical Standby Database
  • Backup and Recovery of a Logical Standby Database
  • Use a RMAN Recovery Catalog in a Data Guard Configuration
  • Create the Recovery Catalog
  • Register a Database in the Catalog
  • Configure Daily Incremental Backups
  • Recover a Datafile on the Primary Database
  • Recover a Datafile on the Standby Database
  • Restore and Recover Datafiles across the Network
  • Enable Block Change Tracking for a Physical Standby Database

Session 13: USE FLASHBACK DATABASE IN A DATA GUARD CONFIGURATION

  • Overview of Flashback Database Usage in a Data Guard Configuration
  • Configure Flashback Database
  • Use Flashback Database Instead of Apply Data
  • Use Flashback Database and Real Time Apply
  • Flashback through Standby Database Role Transitions
  • Use Flashback Database after Failover

Oracle Database 12c Data Guard Training Course

Session 14: DATA GUARD BROKER OVERVIEW

  • Overview of Oracle Data Guard Broker
  • Oracle Enterprise Manager
  • The DGMGRL Command Line Interface
  • Data Guard Monitor
  • Install Oracle Data Guard
  • Start up the Data Guard Broker

Session 15: BUILD A CONFIGURATION USING THE BROKER

  • Prepare for a Configuration Build
  • Configure the Primary Database
  • Configure the Standby Database
  • Validate a Database
  • Show, Enable and Disable the Configuration

Session 16: MANAGE A CONFIGURATION USING THE BROKER

  • Display and Edit Database Properties
  • Set the Configuration Protection Mode
  • Configure Fast Start Failover
  • Execute a Switchover
  • Execute a Failover
  • Alter the state of a Database
  • Monitor the Configuration

Session 17: OVERVIEW OF PATCHING AND UPGRADING DATABASES IN A DATA GUARD CONFIGURATION

  • Upgrade the Oracle Data Guard Broker Configuration
  • Upgrade the Oracle Database in a Data Guard Configuration with a Physical Standby Database
  • Upgrade the Oracle Database in a Data Guard Configuration with a Logical Standby Database
  • Use DBMS_ROLLING to Upgrade a Database
  • Leading Group Databases and Leading Group Master
  • Trailing Group Databases and Trailing Group Master
  • Use DBMS_ROLLING to Carry out a Rolling Database Upgrade
Home Let Us Call You Enquiry

Place A booking





Print Friendly





StayAhead Promo 4


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

UNIX 
AIX 
HP-UX 

GDPR, Business Analysis, ITIL & Prince2

See what our clients say . . .

Having previously undertaken a similar course in the past I expected this course to not be especially beneficial, however this was not the case at all. I have garnered some very useful new skills and knowledge. The trainer's subject knowledge and delivery are a credit to himself and Stayahead. I was constantly engaged and rarely found myself requiring a repeat of the coursework but when needed he was more than helpful in explaining where I was struggling.

Laurence - Operations Support - Finance - September 2017

More Reviews

+44 (0)20 7600 6116
Cookies Policy
Copyright © 2017 StayAhead Training Ltd
sales@stayahead.com