Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

Oracle 12c - RAC & Data Guard Integration

( Duration: 5 Days )

In Oracle 12c - RAC & Data Guard Integration training course, you will learn to practice deploying, configuring, administering, maintaining, and using noteworthy features associated with Oracle Database 12c RAC and Data Guard.

By attending Oracle 12c - RAC & Data Guard Integration workshop, delegates will learn to:

  • Convert a single instance to an Oracle RAC Database
  • Configure Oracle Net Services in a Data Guard Environment with RAC
  • Deploy a Physical Standby Database in an Oracle RAC environment using SQL and RMAN Commands
  • Configure Oracle Data Guard in an Oracle RAC environment
  • Manage physical Standby Files After structural changes on the Primary Database
  • Perform Effective Client Failover using Application Continuity
  • Perform Effective Service Failover and Workload Management Using Global Data Services
  • Perform Database Recovery in an Oracle Data Guard environment
  • Perform Data Guard Standby First Rolling Patch Apply
  • Disassociate a Snapshot Standby Database from a Data Guard Configuration
  • Perform Database Rolling Upgrade Using Transient Logical Standby Database

The Oracle 12c - RAC & Data Guard Integration class is ideal for:

  • Administrators
  • Database Administrators
  • Implementers

COURSE AGENDA

1

Introduction to High Availability Best Practices

  • Understand Oracle Clusterware
  • Understand Oracle ASM
  • Understand Oracle RAC
  • Understand Oracle Data Guard
  • Design a Maximum Availability Architecture in your environment
2

Converting a Single Instance to an Oracle RAC Database

  • Scenario 1: Convert a single instance on a non-clustered enviornment to RAC
  • Scenario 2: Convert a single instance on a clustered environment to RAC
3

Configuring Oracle Net Services in a Data Guard Environment with RAC

  • Review of Oracle Net Services
  • Configuring Oracle Net Services in a Data Guard Environment
4

Deploying a Physical Standby Database in an Oracle RAC environment Using SQL and RMAN Commands

  • Preparing the Primary Database
  • Configuring Oracle Net Services
  • Preparing the Standby Hosts
  • Starting the standby database instance
  • Executing the DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command
  • Completing the RAC Configuration
  • Starting the transport and application of redo
5

Configuring Oracle Data Guard in an Oracle RAC environment

  • Data Guard Broker Configuration
  • Redo Transport and Apply Services
  • Data Guard Deployment Options
  • Role Transition Services
  • Flashback Database
  • Fast-Start Failover
6

Managing Physical Standby Files After Structural Changes on the Primary Database

  • Scenario 1: Creating a tablespace
  • Scenario 2: Dropping or deleting a tablespace or data file
  • Scenario 3: Using Transportable Tablespaces
  • Scenario 4: Moving an Online Data File
  • Scenario 5: Adding or Dropping a redo log file group
  • Scenario 6: NOLOGGING Operations
  • Scenario 7: Refreshing the Password File
  • Scenario 8: Resetting the TDE Master Encryption Key
7

Effective Client Failover Using Application Continuity

  • Connecting to the appropriate environment
  • Fast Notification of Clients
  • Automatic Client Failover
  • Handling In-Flight Transactions
  • Replaying Incomplete Requests
  • RAC and Application Continuity
  • Data Guard and Application Continuity
8

Effective Service Failover and Workload Management Using Global Data Services

  • Concept Review
  • Global Data Services Overview
  • Global Service Overview
  • Client Connectivity in GDS
  • Global Data Services Deployment
9

Performing Database Recovery in an Oracle Data Guard environment

  • Basic concept of the Oracle Database Recovery
  • Recovery Considerations in Oracle Data Guard (Media Failures)
  • Recovery Considerations in Oracle Data Guard (Logical Failures)
10

Performing Data Guard Standby-First Patch Apply

  • Background: Data Guard Support for Heterogeneous Configuration
  • Phases of Data Guard Standby-First Patch Apply
11

Disassociating a Snapshot Standby Database from a Data Guard Configuration

  • Snapshot Standby Databases Overview
  • Disassociating a Snapshot Standby from a Data Guard Configuration
12

Rolling Database Upgrade Using Transient Logical Standby

  • Phase 1: Completing Prerequisites
  • Phase 2: Preparing for Upgrade
  • Phase 3: Performing Pre-Upgrade Tasks
  • Phase 4: Upgrading Transient Logical Standby
  • Phase 5: Performing Post-Upgrade Tasks
  • Phase 6: Preparing Original Primary Database for Upgrade
  • Phase 7: Performing the Final Upgrade Tasks

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top