OD-AI-HANF: Oracle AI Database: High Availability New Features

Module 1: Oracle Clusterware

• Objectives
• Improve Monitoring and Auto-Correct Resource States
• Typical Problems Applicable and Remedies
• Primary CRSD Hang: Example
• Unmounted OCR Disk Group: Example
• ASM Listener Issue Affecting Flex ASM Functionality: Example
• Detecting and Resolving Memory Leaks: Example
• New crsctl Commands: Example
• CVU Enhancements: Diagnostics
• CVU Enhancements: Fixups
• CVU Enhancements: Error Reporting
• Autonomous Health Framework (AHF) Repository
• Review of CHM and CHA
• CHM Improved Diagnosability
• New oclumon Commands: Example
• Fleet Patching and Provisioning (FPP) Overview: Background
• High-Level FPP Architecture
• FPP Archiving of Gold Images
• Summary

Module 2: Oracle ASM

• Objectives
• On-Demand Scrubbing: Background
• Extent-Based Scrubbing
• Summary

Module 3: Oracle RAC

• Objectives
• Simplified Database Deployment
• Automatic PDB Resource Management
• PDB Placement Choice: Fill or Spread
• Ranking and CPU
• Rank and CPU: Startup Order
• Failure Handling
• Last Node Standing
• Configuring a PDB with Cardinality and Rank: Example
• Oracle RAC Connection Management: Overview
• Distribute Connections Based on Service Attributes
• Load Balancing Options in Oracle RAC: Example
• Performance Considerations
• Smart Connection Rebalance
• Testing Smart Connection Rebalance: Example
• Outcome Without Smart Connection Rebalance: Example
• Outcome With Smart Connection Rebalance: Example
• Index Block Contention: Background
• Sequence Usage in Oracle RAC
• Right-Growing Index Optimizations
• Ordered Sequence Enhancement in Oracle RAC
• Ordered Sequence Optimization in Oracle RAC: Example
• Review of Buddy Recovery for Reconfiguration
• Smooth Reconfiguration
• Single-Server Rolling Database Maintenance: Overview
• Local Rolling Database Maintenance: Overview
• Patching Oracle RAC Database in Local Rolling Mode: Example
• Oracle RAC Two-Stage Rolling Patches: Overview
• Summary

Module 4: Oracle Data Guard – Part 1

• Objectives
• Oracle Active Data Guard
• Automatic Primary Database Preparation
• Creating a Temporary File After PDB Creation
• Automatic Temporary File Creation on the Standby Database
• DML on Active Data Guard
• Improved Performance of Redirected Transactions
• PL/SQL API for Data Guard Broker Management
• ORDS REST API for Data Guard Management
• Easier Checking of Data Guard Configurations
• Easier Checking of Fast-Start Failover Configurations
• Easier Tracking of Role Transitions
• Fast-Start Failover Lag Histogram
• Enhanced Observer Diagnostics
• Remote Snapshot Configuration for Active Data Guard Database
• Simplified AWR Snapshots on Active Data Guard
• Maximum Performance Without Fast-Start Failover
• Maximum Performance With Fast-Start Failover
• Automatic Failover with Maximum Performance
• Minimized Stall in Fast-Start Failover Maximum Performance
• Choosing the Lag Type for Maximum Performance Mode
• Strict Validation of Switchover Readiness
• New Command: VALIDATE DGConnectIdentifier
• New Commands: SHOW | EDIT ALL MEMBERS
• Summary

Module 5: Oracle Data Guard Part 2

• Objectives
• Traditional Per-CDB Data Guard Architecture
• Oracle Data Guard for Container Databases
• Data Guard per PDB (DGPDB)
• DGPDB Integration Enhancements
• Current Limitations in DGPDB
• DGPDB Implementation: Overview
• Two Primary CDBs
• Preparing Both CDBs for Data Guard
• Setting Up Passwords in the Wallet
• Two Data Guard Configurations
• Adding Broker Configurations
• Internal Communication Between CDBs
• Preparing the Configuration for DGPDB
• Adding Target Pluggable Databases to Data Guard
• Checking the PDBs Before Adding Them
• Adding the PDBs to DGPDB
• Target Pluggable Databases Require Manual Copy
• Manual Copy: Example Using SCP on File System
• Manual Copy: Example Using RMAN and ASM
• Transport Architecture
• Adding Standby Redo Logs to Target PDBs
• The Apply Architecture
• Starting the Redo Apply
• Showing the Status of the PDBs
• PDB Switchover
• DGPDB and Transparent Data Encryption
• Copying the TDE Encryption Keys
• Application Continuity: Overview
• Use Cases
• What Is Hybrid Data Guard?
• Hybrid DR Configurations: Challenges
• Possible Solutions
• How to Use It: Examples
• Summary