mail info@ascendinfosolutions.com    phn 732- 645-7910

 

Oracle RAC 11g R2 and 12c Contents

Introduction and RAC overview

11gR2 RAC architecture and components
Cache coherency, Cache fusion
Cluster Reconfigurations
DRM,IMR

Installing Oracle RAC

Pre Installation tasks

OS preparation, network configuration
DNS configuration
Network Bonding
Attaching shared storage and Multipathing
Preparation of ASM Disks
Kernel parameters,groups and users

RAC installation

Pre installation checks
Fixing missing pre installation configurations
Installing Grid Infrastructure
Oracle 11g R2 RAC Installation
11g R2 RAC issues during installation

Advanced installations

Installing in silent mode (without GUI)
GNS Implementation

Clusterware Admin

11g R2 clusterware admin commands and new features
11g R2 RAC startup issues
Troubleshooting ASM issues
Enabling and Disabling CRS
Startup and Shutdown of CRS
Cluster verification utility
Checking cluster integrity
Important log files and monitoring
Management of OCR and Voting disks
Adding more OCR and Votingdisks
Backup of OCR ,voting disks and OLR
Restoring OCR and voting disks
OCR and OLR integrity checks
Changing the Virtual IP Addresses
changing SCAN IP and port numbers
Missing OCR scenario

RAC Database Creation

Storage options for RAC Database
Creating Disk groups for Database, FRA and archive log
Creating RAC Database using DBCA
Creating RAC Database manually
Understanding Parameters

Administering Database Instances and Cluster Databases

Tools for Administering Oracle RAC
Enabling and Disabling Databases
Starting and Stopping Instances and Oracle RAC Databases
Verifying That Instances are Running
Some differences between single instance and RAC DB
Terminating Sessions On a Specific Cluster Instance
Working with parameters
Administrator Managed and Policy-Managed Database

Administering ASM 11g R2

Using ASMCA and ASMCMD
ASM spfile backup
ASM Disk groups metadata backups and restore
Configuring ACFS, ACFS snapshots

Managing Services and TAF, Load Balancing

                Introductions to services
Creating different services
Startup and shutdown of services
Understanding and Configuring TAF
Configuring Oracle Net services
Configuring Load Balancing
relocating services

Managing Backup and Recovery

                Configuring Archivelog
Configuring archive log parameters
Configuring storage for archive log
Configuring FRA
Configuring RMAN for oracle RAC
Configuring Recovery Catalog
Performing Hot Backups uing RMAN
Recovery Using RMAN
RMAN recovery scenarios

Database Cloning

                Cloning RAC DB to Single Instance DB using RMAN
Cloning standalone DB to RAC using DBCA

Adding and Deleting Nodes

Patching and Upgradation

    Applying Rolling patches
Upgrading 10g RAC to 11g R2 RAC

Migrating Non RAC DB to RAC DB

Assuming non RAC DB using File System and
RAC DB using ASM storage

  1. manual migration
  2. using rconfig tool

Implementing standby for RAC database

Diagnostic tools

   Wait events,Performance Tuning
Troubleshooting
Diag collection
Configuring and using Cluster Health Monitor
Using OS watcher
Cluster verification utility

Node Eviction Issues
Troubleshooting Interconnect
Grid Plug and Play

Configuring Application Vips
Configuring application resources and
Managing Application high availability

Oracle 12C RAC new features

Faculty : (18 yrs exp)