Oracle Database 12c: Data Guard Administration Training

This course will teach students how to develop the best disaster recovery solution using the new Oracle Data Guard 12c features and architecture. Students will get a chance 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 you will Learn

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
Describe the Architecture of Oracle Data Guard
Explain the applicability between physical and logical standby and snapshot databases
Explain the benefits of implementing Oracle Data Guard
Explain Data Guard use with the Oracle Multi-tennant databases
Configure client connectivity in a Data Guard configuration
Implement failover procedures to automatically redirect clients to a new primary database
Use Application Continuity in a Data Guard Environment

PREREQUISITES

Good knowledge of Oracle Database
Oracle Database 12c: Administration Workshop

CURRICULUM

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

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

Learning Objectives:

Role Management Services
Role Transitions: Switchover and Failover
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

Learning Objectives:

Using Flashback Database in a Data Guard Configuration
Overview of Flashback Database
Configuring Flashback Database
Configuring Flashback Database by Using Enterprise Manager
Using Flashback Database Instead of Apply Delay
Using Flashback Database and Real-Time Apply
Using Flashback Database After RESETLOGS
Flashback Through Standby Database Role Transitions

Learning Objectives:

Fast-Start Failover: Overview
When Does Fast-Start Failover Occur?
Installing the Observer Software
Fast-Start Failover Prerequisites
Configuring Fast-Start Failover
Setting the Lag-Time Limit
Configuring the Primary Database to Shut Down Automatically
Automatic Reinstatement After Fast-Start Failover

Learning Objectives:

Understanding Client Connectivity in a Data Guard Configuration
Understanding Client Connectivity: Using Local Naming
Preventing Clients from Connecting to the Wrong Database
Managing Services
Understanding Client Connectivity: Using a Database Service
Creating Services for the Data Guard Configuration Databases
Configuring Role-Based Services
Adding Standby Databases to Oracle Restart Configuration

Learning Objectives:

Using RMAN to Back Up and Restore Files in a Data Guard Configuration
Offloading Backups to a Physical Standby
Restrictions and Usage Notes
Backup and Recovery of a Logical Standby Database
Using the RMAN Recovery Catalog in a Data Guard Configuration
Creating the Recovery Catalog
Registering a Database in the Recovery Catalog
Setting Persistent Configuration Settings

Learning Objectives:

Upgrading an Oracle Data Guard Broker Configuration
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
Using DBMS_ROLLING to Upgrade the Oracle Database
Requirements for Using DBMS_ROLLING to Perform a Rolling Upgrade
Leading Group Databases and Leading Group Master
Trailing Group Databases and Trailing Group Master
Performing a Rolling Upgrade by Using DBMS_ROLLING

Learning Objectives:

Monitoring the Data Guard Configuration by Using Enterprise Manager Cloud Control
Viewing the Data Guard Configuration Status
Monitoring Data Guard Performance
Viewing Log File Details
Enterprise Manager Metrics and Alerts
Data Guard Metrics
Managing Data Guard Metrics
Viewing Metric Value History

Learning Objectives:

Monitoring Configuration Performance by Using Enterprise Manager Cloud Control
Optimizing Redo Transport Services
Setting the ReopenSecs Database Property
Setting the NetTimeout Database Property
Optimizing Redo Transmission by Setting MaxConnections
Setting the MaxConnections Database Property
Compressing Redo Data by Setting the RedoCompression Property
Delaying the Application of Redo

Learning Objectives:

Introducing Exadata Cloud Service
Service Configuration, Connection, Architecture & Availability
Data Security & Management Responsibilities
Storage Configuration & Management Details
Simple Web-Based Provisioning & Management
REST APIs
Backup and Recovery
Migrating to Exadata Cloud Service

FAQs

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.
1. Online ,By deposit the mildain bank account
2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.

Contact us using the form on the right of any page on the mildaintrainings website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

You will never miss a lecture at Mildaintrainigs! You can choose either of the two options: View the recorded session of the class available in your LMS. You can attend the missed session, in any other live batch.

We have a limited number of participants in a live session to maintain the Quality Standards. So, unfortunately, participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

Yes, you can cancel your enrollment if necessary prior to 3rd session i.e first two sessions will be for your evaluation. We will refund the full amount without deducting any fee for more details check our Refund Policy

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

Just give us a CALL at +91 8447121833 OR email at info@mildaintrainings.com

Call us At