Oracle Database 12c: RAC and Data Guard Integration
In the Oracle Database 12c: Real Application Cluster (RAC) and Data Guard Integration Workshop, you'll learn how to practice deploying, configuring, administering, maintaining, and using noteworthy features associated with Oracle Database 12c RAC and Data Guard.
Description
In the Oracle Database 12c: Real Application Cluster (RAC) and Data Guard Integration Workshop, you'll learn how to practice deploying, configuring, administering, maintaining, and using noteworthy features associated with Oracle Database 12c RAC and Data Guard.
What You'll Learn
- Understand High Availability Best Practices.
- Perform RAC and Data Guard Deployment.
- Perform RAC and Data Guard Configuration.
- Implement Effective Client Failover and Workload in a RAC/Data Guard environment.
- Perform Recovery in a RAC/Data Guard environment.
- Perform Planned Maintenance in a RAC/Data Guard environment.
Prerequisites
- Practical understanding of Oracle Database 11gR2 or 12c including Grid Infrastructure, ASM, RAC and Data Guard
- Practical understanding of database replication
- Rolling Upgrade Using Transient Logical Standby Database
Outline
12 modules
•
5 Days total
- Understand Oracle Clusterware
- Understand Oracle ASM
- Understand Oracle RAC
- Understand Oracle Data Guard
- Design a Maximum Availability Architecture in your environment
- 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
- Review of Oracle Net Services
- Configuring Oracle Net Services in a Data Guard Environment
- 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
- Data Guard Broker Configuration
- Redo Transport and Apply Services
- Data Guard Deployment Options
- Role Transition Services
- Flashback Database
- Fast-Start Failover
- 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
- 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
- Concept Review
- Global Data Services Overview
- Global Service Overview
- Client Connectivity in GDS
- Global Data Services Deployment
- Basic concept of the Oracle Database Recovery
- Recovery Considerations in Oracle Data Guard (Media Failures)
- Recovery Considerations in Oracle Data Guard (Logical Failures)
- Background: Data Guard Support for Heterogeneous Configuration
- Phases of Data Guard Standby-First Patch Apply
- Snapshot Standby Databases Overview
- Disassociating a Snapshot Standby from a Data Guard Configuration
- 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