Oracle Database 19c: RAC Administration Workshop

Descripción

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.

Objetivos

• 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

Contenidos del curso

1. Grid Infrastructure:Overview

• Grid Infrastructure:Overview
• Clusterware Architecture and Cluster Services
• Oracle Clusterware Initialization
• Grid Naming Service (GNS)
• Course Practice Environment:Security Credentials

2. RAC Databases Overview and Architecture

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

3. Installing with Configuring Oracle RAC

• Installing with Configuring Oracle RAC
• Installing the Oracle Database Software
• Database Content
• Background Processes Specific to Oracle RAC

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

5. Upgrading and Patching Oracle RAC

• Upgrading and Patching Oracle RAC
• OPatch:Overview

6. Managing Backup and Recovery for RAC

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

7. Global Resource Management Concepts

• Global Resource Management Concepts
• Global Resource Access Coordination

8. RAC Database Monitoring and Tuning

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

9. Managing High Availability of Services

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

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 ?

11. Oracle RAC One Node

• Oracle RAC One Node
• Online Relocation Illustration

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

13. Multitenant Architecture and RAC

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

14. Quality of Service Management

• Quality of Service Management
• Qos Management Policy Sets
• Performance Objectives