Overview

This Oracle Database 19c: RAC Administration Workshop course will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion

Learn to:            

• Install and configure RAC
• Manage RAC Database
• Upgrade and patch RAC Database
• Manage backup and recovery for RAC
• Monitor and tune RAC Database
• Manage high availability of services
• Implement High Availability for connections and applications
• Configure RAC One Node Database
• Implement In-Memory Column Store in RAC
• Configure Multitenant Architecture in RAC
• Manage Quality of Service in RAC

Duration

40 hours

Objectives

Upon completion of this course, you should be able to:

• Install and configure RAC
• Manage RAC Database
• Upgrade and patch RAC Database
• Manage backup and recovery for RAC
• Monitor and tune RAC Database
• Manage high availability of services
• Implement High Availability for connections and applications
• Configure RAC One Node Database
• Implement In-Memory Column Store in RAC
• Configure Multitenant Architecture in RAC
• Manage Quality of Service in RAC

Course Outline

Module 1: Grid Infrastructure:Overview

• Grid Infrastructure Overview
• Clusterware Architecture and Cluster Services
• Oracle Clusterware Initialization
• Grid Naming Service (GNS)

Module 2: RAC Database Overview and Architecture

• RAC Databases Overview and Architecture
• Cluster-Aware Storage Solutions
• Level of Scalability
• Parallel Execution with RAC

Module 3: Installing with Configuring Oracle RAC

• Installing with Configuring Oracle RAC
• Installing the Oracle Database Software
• Database Content
• Background Process specific to Oracle RAC

Module 4: Oracle RAC Administration

• Oracle RAC Administration
• Redo Log Files and RAC
• Local Temporary Tablespaces
• Switch between Automatic and Manual Policies
• Parameters That Require Unique Settings

Module 5: Upgrading and Patching Oracle RAC

• Upgrading and Patching Oracle RAC
• OPatch: Overview

Module 6: Managing Backup and Recovery for RAC

• Managing Backup and Recovery for RAC
• Media Recovery in Oracle RAC
• Oracle Recovery Manager
• Distribution of Backups
• Overview of Practice

Module 7: Global Resource Management Concepts

• Global Resource Management Concepts
• Global Resource Access Coordination
• Scenario 2: Read – Write Cache Fusion

Module 8: RAC Database Monitoring and Tuning

• RAC Database Monitoring and Tuning
• Global Enqueue Waits
• High-Water Mark Considerations
• AWR Snapshots in RAC

Module 9: Managing High A of Services

• Managing High Availability of Services
• Default Service Connections
• Using Services with Client Applications
• Using Services with Resource Manager
• Service Aggregation and Tracing

Module 10: High Availability for Connections and Applications

• High Availability for Connections and Applications
• Implementing FAN Events
• Server-Side Callout Filter: Example
• TAF Basic Configuration on Server-Slide: example
• What is Application Continuity?

Module 11: Oracle RAC One Node

• Oracle RAC One Node
• Online Relocation Illustration

Module 12: Oracle Database In-Memory in RAC

• Oracle Database In-Memory in RAC
• In-Memory Column Store and Oracle RAC
• How the Database Reads from the FastStart Area

Module 13: Multitenant Architecture and RAC

• Multitenant Architecture and RAC
• Containers
• Connection to Non-RAC CDB
• Creating a RAC CDB
• Adding a PDB to RAC CDB