Oracle Database 12c: RAC and Data Guard Integration Workshop (D94430) – Outline

Detailed Course Outline

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
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
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
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
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
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
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
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
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)
Performing Data Guard Standby-First Patch Apply
  • Background: Data Guard Support for Heterogeneous Configuration
  • Phases of Data Guard Standby-First Patch Apply
Disassociating a Snapshot Standby Database from a Data Guard Configuration
  • Snapshot Standby Databases Overview
  • Disassociating a Snapshot Standby from a Data Guard Configuration
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