Oracle database 19c: RAC Administration Workshop
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
Học trực tuyến
Học tại Hồ Chí Minh
Học tại Hà Nội