Oracle Database 12c Data Guard Administration Course

Oracle Database 12c:Data Guard Administration Training

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.

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, ebay, GE, ING, Intuit, PayPal, Splunk, Uber & other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Oracle Database12c UpComing Batches

Nov-29 - Jan-10

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-22 - Jan-03

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Jan-01 - Feb-12

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.

Course Curriculum

Oracle Database 12c:Training

SELF PACED

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.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Course Content


Topics:
  • 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.


Topics:
  • 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.


Topics:
  • 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.


Topics:
  • 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.


Topics:
  • Standby Database Creation: Progress.
  • Creating a Configuration.
  • Adding a Standby Database to an Existing Configuration.
  • Using the Add Standby Database Wizard.
  • Using Oracle Enterprise Manager to Create a Broker Configuration.
  • Creating a New Configuration.
  • Verifying a Data Guard Configuration.


Topics:
  • 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.


Topics:
  • Using SQL IDENTITY Column.
  • Increased Length Limits of Data Types.
  • ANYDATA Type Enhancements.
  • SQL Column Enhancements.
  • GATEWAY Enhancements.


Topics:
  • 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.
  • Understanding Lag in an Active Data Guard Configuration.
  • Monitoring Apply Lag: V$STANDBY_EVENT_HISTOGRAM.


Topics:
  • 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.


Topics:
  • 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.


Topics:
  • 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.
  • Using Flashback Database and Real-Time Apply
  • Using Flashback Database Instead of Apply Delay.


Topics:
  • 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.


Topics:
  • 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.


Topics:
  • 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.


Topics:
  • 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.
  • 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.



Topics:
  • 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.
  • Enterprise Manager Metrics and Alerts.
  • Viewing Log File Details.



Topics:
  • 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.
  • Monitoring Configuration Performance by Using Enterprise Manager Cloud Control.
  • Optimizing Redo Transport Services.


Topics:
  • 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.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers