Course Details

Oracle RAC Online Training

Contact Details

Oracle Real Application Cluster Course Overview:

Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering.

In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files, control files, and redo logs located on disk. The instance comprises the collection of Oracle-related memory and operating system processes that run on a computer system.

In an Oracle RAC environment, 2 or more computers (each with an Oracle RDBMS instance) concurrently access a single database. This allows an application or user to connect to either computer and have access to a single coordinated set of data.
  • Introduction to Real Application Clusters
  • What is Cluster
  • Types of Cluster & Cluster products
  • Oracle Grid Infrastructure principles and Purpose
  • Differences between single instance database and RAC database

Oracle RAC  Course Content:

Oracle Clusterware Architecture
  • Global Resource Coordination in RAC
  • Cache Fusion & Data Coherency Concepts
  • RAC Background Processes & Daemons
  • Different Layers of RAC
Shared Storage Configuration for Grid Infrastructure Installation
  • Introduction to ASM and OCFS2 Cluster File system
  • Creating OCFS2 File system
  • Creating and Administering ASM Instances
  • Manage ASM instances and associated processes
  • Monitor ASM using the V$ASM dynamic performance views
  • Create and delete ASM disks & disk groups
  • Administering ASM Files, Directories
  • Use different client tools to access ASM files(asmcmd)
  • Describe the format of a fully qualified ASM filename
  • Explain how ASM files, directories and aliases are
  • created and managed
Grid Infrastructure Installation
  • Perform pre-install tasks for Grid Infrastructure
  • Install Grid Infrastructure & Verify
  • Real Application Clusters Database Installation
  • Install the Oracle database software
  • Create a cluster database
  • Perform post-database creation tasks
RAC Database Administration
  • Using Common Pfile and Spfile
  • Global Parameters & RAC-Specific Parameters
  • Database Creation in RAC
  • Managing Redo Logs
  • Managing Undo Table spaces
  • Using GV$ views
Administering Oracle Clusterware
  • Using Server Control Utility(SRVCTL)
  • Using Cluster Ready Services Control(CRSCTL)
  • Creating and Administering ACFS
  • Administer ASM Dynamic Volume Manager
  • Implement ASM Cluster File System
  • Manage ASM Cluster File System (ACFS)
  • Using command line tools to Manage ACFS
Services & Workload Management
  • Configure client-side,
  • Connect-time load balancing and connect-time failover
  • Configure server-side, connect-time load balancing
  • Use the Load Balancing Advisory (LBA)
  • Describe the benefits of Fast Application Notification (FAN)
  • Configure Transparent Application Failover (TAF)
Applying Patch and Clusterware Upgrade
  • CPU and PSU patches
  • In place and Out of place upgrades
  • Rolling Patching
  • Applying Opatch
Managing Backup and Recovery for RAC
  • OCR & Voting disk Backup & Restoration
  • Managing Backup and Recovery for RAC Database
  • Configure the RAC database to use Archive log mode and the flash recovery area
  • Recover from media failure and instance failures
  • Configure RMAN for the RAC environment
  • Converting Database from Non-RAC to RAC
  • Adding and Deleting Cluster nodes
Troubleshooting Oracle Clusterware
  • Locate Oracle Clusterware log files
  • Gather all log files using diagcollection.pl
  • Enable resource debugging
  • Enable component-level debugging
  • Enable tracing for Java-based tools
  • Troubleshoot the Oracle Cluster Registry(OCR) file
RAC DB Monitoring and Tuning
  • Automated Workload Management (AWR)
  • Automatic Database Diagnostic Management (ADDM)
  • Determine RAC-specific tuning components

Post a Comment


Home static_page

Popular Posts

Random Posts

Flickr Photo