Upgrading Oracle DBA skills with RAC – Real Application Clusters is vital to handle critical environments where High Availability is a major requirement. We will make it easy for you to learn, implement and achieve High Availability, Load Balancing, Performance improvement in your environment with this course.

Get hands-on real time activities experience on standalone Oracle Database environment now.

  • Covers concepts and Real-Time activities
  • Install and Implement yourself.
  • Simple and easy to understand.
  • Align with industry standards.

System requirements:

  • Laptop/Desktop with at least 6GB RAM.
  • Minimum of Dual Core processor + Hyper threading.
  • 100 GB of disk space.

Training details:

  • 34 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

Demo Video:

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

  1. Introduction
  • Softwares list we use
  • What Is a Cluster
  • What is Oracle Real Application Clusters
  • Benefits of Using RAC
  • Levels of Scalability
  • Scaleup and Speedup
  • Complete Integrated Clusterware
  • Necessity of Global Resources
  • Global Resources Coordination
  • Global Cache cordination
  • Write to Disk Coordination
  • Dynamic Reconfiguration
  • Dynamic Remastering
  • Global Dynamic Performance Views
  • Additional Memory Requirement for RAC
  • Efficient Internode Row-Level Locking
  • Parallel Execution with RAC
  • RAC Software Principles
  • RAC Software Storage Principles
  • RAC Database Storage Principles
  • RAC and Shared Storage Technologies
  • Oracle Cluster File System
  • Automatic Storage Management
  • ASM Key Features and Benefits
  • ASM and Grid Infrastructure in 11gR2
  • CFS or Raw?
  • RAC and Services
  • RAC One Node Single-Instance High Availability on 11gR2.
  1. Grid Infrastructure: Overview
  • Oracle Clusterware
  • Oracle Clusterware Architecture and Services
  • Goals for Oracle Clusterware
  • Oracle Clusterware Networking
  • Oracle Grid Infrastructure for a Cluster
  • Grid Plug and Play
  • Grid Naming Service
  • Single Client Access Name
  1. Oracle RAC Installation
  • Oracle RAC 11g incorporates a two-phase installation process:
  • Oracle RAC 11g Installation: Outline
  • Pre installation Tasks
  • Network Requirements
  • Virtual IP Addresses and RAC
  • SCAN from 11gR2
  • Install VMware and one OEL server(Node 1)
  • Install OS pre-requisites
  • Add ASM disks to Node 1
  • Add two network adaptors
  • Complete the setup on Node 1
  • Clone Node 1 to Node 2
  • Modify the configuration on Node 2
  • Disable NTPD and test the setup(Network and ASM disks)
  • Copy GRID software to Node 1 and install CLUSTER on both nodes
  • Check cluster and ASM disks on both the servers
  • Install database software on both the servers from Node 1
  1. SRVCTL and CRSCTL tools
  • SRVCTL commands
  • SRVCTL RAC administration
  • CRSCTL commands
  • CRSCTL RAC administration
  1. Single Instance to RAC migration
  • Methods of migrating single instance database to RAC.
  • Choose a single instance environment. Else create one.
  • Migrate a single Instance to 2 node RAC setup.
  1. Background processes
  • Background process in Cluster
  • Understand Cluster resources
  • Understand Cluster components
  • Background Processes Specific to OracleCluster
  • Oracle Clusterware Initialization
  • Startup process of cluster
  • Understand all background daemons of cluster
  1. RAC Database Administration
  • Find the Thread numbers of instances:
  • Redolog files in RAC
  • Automatic Undo Management in RAC
  • Start Stop RAC instances with SQLplus
  • Start Stop RAC instances with SRVCTL
  • Initialization parameters in RAC
  • SPFILE Parameter Values and RAC
  • Identical parameters between nodes
  • Distinct parameters between nodes
  • Quiecing RAC databases
  • Terminate sessions in RAC
  • SQLplus commands and Instances
  1. ASM (Automatic Storage Management)
  • ASM general architecture
  • ASM instance and crash recovery in RAC
  • ASM initialization parameters
  • ASM and SRVCTL with RAC
  1. Global Resource Management Concepts
  • Need for Global Concurrency Control
  • Global Resource Directory (GRD)
  • Global Resource Management
  • Global Resource Remastering
  • Global Resource Recovery
  • Global Resource Background Processes
  • Global Resource Access Coordination
  • Global Enqueues
  • Instance Locks
  • Global Cache Management: Overview
  • Global Cache Management Components
  • Global Cache Buffer States
  • Global Cache Management Scenarios :for Single Block Reads
  • Scenario 1: Read From Disk
  • Scenario 2: Read-Write Cache Fusion
  • Scenario 3: Write-Write Cache Fusion
  • Scenario 4: Write-Read Cache Fusion
  • Global Cache Management Scenarios for Multi-Block Reads
  • Useful Global Resource Management Views
  1. Managing Backup and Recovery for RAC
  • RAC and Instance Recovery
  • Instance Recovery and Database Availability
  • Instance Recovery and RAC
  • Instance Recovery and RAC
  • Protecting Against Media Failure
  • Media Recovery in Oracle RAC
  • Parallel Recovery in RAC
  • Archived Log File Configurations
  • RAC and the Fast Recovery Area
  • Archived Redo File Conventions in RAC
  • Oracle Recovery Manager
  • Configuring RMAN Snapshot Control File Location
  • Configuring Control File and SPFILE Autobackup
  • Crosschecking on Multiple RAC Clusters Nodes
  • Channel Connections to Cluster Instances
  • RMAN Channel Support for the Grid
  • RMAN Default Autolocation
  • Distribution of Backups
  • Shared Storage Backup Scheme: One Local Drive
  • Shared Storage Backup Scheme: Multiple Drives
  • Restoring and Recovering
  1. Administration Activities 1
  • Crash Node 1/Node 2 and check the availability of database
  • Setting Parallel_min_servers parameter
  • Enable and disable archivelog mode in RAC
  • Configure FRA to ASM disk group
  • Configure FRA to generate Archive logs
  • Configure proper naming convention to archive log files
  • Configure proper snapshot control file location
  • Configure Snapshot control file location
  • Configure AUTOBACKUP SPFILE and controlfile backups
  • Full database backup (No parallel slaves)
  • Full database backup with parallel slaves on same node
  • Full database backup with parallel slaves on other nodes(In run block)
  • Full database backup with parallel slaves on same node(Configured RMAN)
  • Full database backup with parallel slaves on other nodes(Configured RMAN)
  • Restore and recover a lost datafile.
  • Restore and recover databaseWith SPFILE
  1. Managing High Availability of Services
  • Exercise demonstrating connection using service from windows
  • Check the status of all listerners(scan) on all nodes
  • Oracle Services
  • Services for Policy- and Administrator-Managed Databases
  • Default Service Connections
  • Creating Services with SRVCTL
  • Managing Services with srvctl
  • Demonstrate how connection establishes with created service
  • Using Services with Client Applications
  • Services and Connection Load Balancing
  • Services and Transparent Application Failover
  1. High Availability of Connections
  • Client-Side Connect-Time Load Balancing
  • Client-Side Connect-Time failover
  • Server-Side Connect-Time Load Balancing
  • Fast Application Notification: Overview
  • Fast Application Notification: Benefits
  • FAN-Supported Event Types
  • FAN Event Status
  • FAN Event Reasons
  • FAN Event Format
  • Connection Load Balancing in RAC
  • Transparent Application Failover: Overview
  • Example connection without TAF:
  • TAF Basic Configuration Without FAN: Example
  1. Administration Activities 2
  • Relocating services
  • Starting cluster
  • Bringing cluster down
  • deleting services
  • Modifying services
  • Killing sessions
  • Monitoring blocks,LOCKS, DEADLOCKS
  • Starting cluster components
  • View number of nodes in cluster:
  • Check Cluster status:
  • identify OCR
  • Identify location of voting disk
  • OCR backups
  • adding additional voting disk
  • Shutting down all oracle services for any maintenance
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Changing the Automatic OCR Backup Location
  • Adding, Replacing, and Repairing OCR Locations
  • Removing an Oracle Cluster Registry Location
  • Performing Manual OCR Backups
  • Recovering the OCR by Using Physical Backups
  • Recovering the OCR by Using Logical Backups
  • Oracle Local Registry
  • Determining the Current Network Settings
  • Recovering the OCR by Using Physical Backups
  1. RAC database Monitoring and Tuning
  • CPU and Wait Time Tuning Dimensions
  • RAC-Specific Tuning
  • Analyzing Cache Fusion Impact in RAC
  • Wait Events for RAC
  • Wait Event Views
  • Session and System Statistics
  • Most Common RAC Tuning Tips
  • Monitoring RAC Database and Cluster Performance
  • AWR Snapshots in RAC
  • Active Session History Reports for RAC
  • Automatic Database Diagnostic Monitor for RAC
  1. Administration activities 3
  • Adding node to the cluster
  • Deleting node from the cluster
  • PSU patch 11.2.0.3.8
  • ASM storage administration