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


Các khóa học khác