Oracle RAC DBA 12c Training
ORACLE RAC DBA 12c Course Brief
Online RAC 12c DBA Training is unique @ DBA Technologies which is a blend of Indepth study of
concepts with special reference to real world scenarios and practical live demos. All sessions are handled
by Mr. Prasad Mynumpati and are highly interactive.
You will be proficient in the successful installation and configuration of Real Application Clusters (grid
infrastructure) along with in-depth knowledge on Virtualization setups, managing cluster services, cache
fusion concepts, past image, Global Resource Directory (GRD), SCAN Listener concepts, Voting Disks
(why odd number?), OCR, tools (crsctl, srvctl), converting non RAC to RAC, Add Node, TAF setup,
RMAN Backups using multiple server resources and many more.
Week 1:
Session 1:
Introduction & Course details
What is an Instance and Database
Database storage options(Core & Cluster)
Availability (HA,MA,LA & MAA)
Non RAC DB Vs RAC DB
Storage options Core DB vs. RAC DB
Files system files / RAW Partitions / ASM
What is ASM?
ASM Architecture
Benefits of ASM
What is Cluster?
What is Clusterware?
Software requirements and download locations
ORACLE VM BOX Environment setup details
Session 2:
Quick review
What is GRID Infrastructure (ASM andClusterware)
Clusterware Concepts and Architecture
Clusterware startup sequence
Clusterware startup processes
Oracle Clusterware stack
Cluster ready service stack
Oracle High availability services stack
Grid Plug and Play architecture
CSS and Voting Disk Functionality
CRS and OCR
Node eviction (Inter connect ,VD)
Networking in RAC concepts
Networking in RAC configuration topology
Week 2:
Session 3:
ORACLE VM Box setup
OS Installation for RAC Node1
OS Configuration (rpms, config)
Creating Users and Groups
Creating Virtual Disks
Adding disks to Virtual Node1
Network configuration Public & Interconnect
Configuring oracleasm
Cloning Virtual Disk
Preparing Virtual Node2 from Node1
Configuring Node2
Session 4:
Pre Installation Verification
Network verification (Private and Public)
Completing Grid Installation
Understanding warning messages
Concepts of VIP and SCAN IP
Verifying the services with crsctl
Clusterware proc. stop/stop on single / all node(s)
High availability services stop and start
Week 3:
Session 5:
Creating ASM Disks (DATA&FRA) using shared disks
Installating 12cR1 RDBMS software on Cluster
Creating 12cR1 NCDB database on rac1 and rac2
Concepts of Cache fusion
GCS and GES Concepts
Global Resource Directory (GRD)
What is Past Image? And concepts
Past Image vs. CR Image
Read-Read/Read-Write/Write-Write contention
Stoping cluster ready services and resources
Crsctl and Srvctl commands
Session 6:
ASM & ASM cluster file system
ASM Key features and benefits
ASM Instance designs
ASM components
ASM disk groups and fail groups
ASM Scalability
RAC Database Management
Database startup and shutdown
Server Parameters in RAC environment
Enabling Archivelog mode in RAC
Terminating sessions in RAC
Enterprise Manager
Week 4:
Session 7:
RAC Databse Backup Recovery using RMAN
With Catalog and No Catalog
Snapshot Control file purpose and location
Auto backup of Control file and spfile
Archvie log location for RAC DB
RAMN Backup schedules in crontab
Perform Backup and recovery RAC DB
Finding OCR and VD file locations
Backup and Recovery of OCR,VD
Migrating VD and OCR files to different diskgroup
Managing Oracle Clusterware using crsctl & srvctl
OLR purpose and location
OCR and VD auto & manual backups
crsctl & srvctl commands
difference between srvctl and crsctl
disabling and enabling clusterware startup
Session 8:
Create Database Service
TAF from Client and Server side
TAF with LBA enable and with LBA disable
Database Service reloaction
Preconnect Service Configuration
Week 5:
Session 9:
Patching methodology in 12c RAC using opatchauto
Applyin PSU in rolling method
Upgrade 12.1.0.2.0 to 12.2.0.1.0
Upgrade database after GI and RDBMS upgrade
Perform post upgrade steps and verify the upgrade
Session 10:
Create CDB and PDB using dbca in Cluster environment
Create services to start and stop PDBs automatically with restart
Quick review on Multitenant Architecture on RAC environment
Configure TAF service at server level for a PDB
Perform TAF in RAC
