• Image

Welcome to RAC Administration

This Oracle Database 12c R2: RAC Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Why RAC Administration ?

Ensure fast

Reliable Secure

Secure

Easy to Manage

Grid Infrastructure

  • Explain the principles and purposes of clusters
  • Describe the Oracle Clusterware architecture
  • Describe how Grid Plug and Play affects Clusterware

RAC Databases and Architecture

  • Describe the benefits of Oracle RAC
  • Explain the necessity of global resources
  • Describe global cache coordination

Installing and Configuring Oracle RAC

  • Install the Oracle database software
  • Create a cluster database
  • Perform post
  • database
  • creation tasks
  • Convert a single instance Oracle database to RAC

Administering Oracle RAC

  • Use Enterprise Manager Cluster Database pages
  • Define redo log files in a RAC environment
  • Define undo tablespaces in a RAC environment
  • Start and stop RAC databases and instances
  • Modify initialization parameters in a RAC environment

Managing Backup and Recovery for RAC

  • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
  • Configure RMAN for the RAC environment

Managing Global Resources

  • Explain the need for global concurrency control
  • Describe the Global Resource Directory
  • Explain how global resources are managed
  • Explain global enqueue and instance lock management
  • Explain global buffer cache management

RAC Database Monitoring and Tuning

  • Identify RAC
  • specific tuning components
  • Determine RAC
  • specific wait
  • events, global enqueues and system statistics
  • Implement the most common RAC tuning practices
  • Use the Cluster Database Performance pages
  • Use the Automatic Workload Repository (AWR) in RAC
  • Use Automatic Database Diagnostic Monitor (ADDM) in RAC

Managing High Availability of Services

  • Configure and manage services in a RAC environment
  • Use services with client applications
  • Use services with the Database Resource Manager
  • Use services with the Scheduler
  • Configure services aggregation and tracing

Managing High Availability for Connections and Applications

  • Configure client
  • side connect
  • time load balancing and failover
  • Configure server
  • side connect
  • time load balancing
  • Use the Load Balancing Advisory (LBA)
  • Explain the benefits of Fast Application Notification (FAN)
  • Configure server
  • side callouts
  • Configure the server
  • and client
  • side ONS
  • Configure Transparent Application Failover (TAF)

Upgrading and Patching Oracle RAC

  • Describe the different types of patches
  • Plan for rolling patches and rolling updates
  • Install a patchset with the Oracle Universal Installer (OUI) utility
  • Install a patch with the opatch utility

Managing Oracle RAC One Node

  • Perform an online database migration
  • Add an Oracle RAC One Node database to an existing cluster
  • Convert an Oracle RAC One Node database to a RAC database Use DBCA to convert a single
  • instance database to a RAC One Node database Using Oracle Database Quality of Service Management (QoS)
  • Explain the purpose and benefits of using QoS
  • Describe the components of QoS
  • Explain the operation of QoS

Using Multitenant Architecture in a RAC Environment

  • Describe the multitenant architecture in RAC and non
  • RAC environments
  • Create a RAC multitenant container database (CDB)
  • Create a pluggable database (PDB) in a RAC CDB
  • Use the default CDB and PDB services
  • Create PDB services to associate PDB services with server pools
  • Drop a PDB from a RAC CDB