Oracle RAC 19c
Course Duration: 40 Hours
Required Prerequisites
- Basic Knowledge of Unix.
- Oracle Database: Introduction to SQL
- Good knowledge of Oracle DBA
Target Audience
- Oracle DBA who want to learn Oracle Real Application Cluster (RAC) which provide solution for High Availability and better Performance.
Students Enquiry Form
Course Highlights
- About Oracle Grid Infrastructure
- Setup two node RAC enviroment with ASM on virtual box
- SRVCTL and CRSCTL tools
- ASM (Automatic Storage Management)
- Global resources in RAC
- Managing Backup and Recovery for RAC
- Client connectivity in Oracle RAC Database
- OCR , OLR and voting Disk
- Adding a node to cluster
- Deleting a node from cluster
- Patching Activity in Oracle RAC
- Single Instance to RAC migration
- Oracle RAC upgrade from 12c to 19c
Course Content
Section 1: Introduction
- What Is a Cluster
- What is Oracle Real Application Clusters
- Benefits of Using RAC
Section 2: Grid Infrastructure: Overview
- Oracle Grid Infrastructure
- Oracle Clusterware Architecture
- Oracle RAC Software Storage
- Oracle Clusterware Networking
- Types of IPs – Public IP,Private IP, Vritual IP,SCAN IP
Section 3: Oracle RAC Installation
- Oracle RAC 19c Installation Process
- Pre-installation Tasks
- Network Requirements
- Install VirtualBox and OEL 7.2 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
- Copy GRID software to Node 1 and install on both nodes
- Check cluster and ASM disks on both the servers
- Install database software on both the servers from Node 1
- Create diskgroups in ASM for database
- Create database using DBCA
- Check all cluster resources and database status
Section 4: SRVCTL and CRSCTL tools
- Check Cluster health
- SRVCTL commands
- Start/Stop DB using SRVCTL
- CRSCTL commands
- Start/Stop cluster using CRSCTL
- Global Dynamic Performance View
Section 5: Background processes
- Background process and Components of cluster (Upper/Lower stack)
- Database Background Processes
- Oracle Clusterware Initialization
- Startup process of cluster
Section 6:RAC Database Administration
- Redolog files in RAC
- Automatic Undo Management in RAC
- Start Stop RAC instances with SQLplus
- Initialization parameters in RAC
- SPFILE Parameter Values and RAC
- Identical parameters between nodes
- Distinct parameters between nodes
- Terminate sessions in RAC
Section 7:ASM (Automatic Storage Management)
- Basis of ASM
- Administering ASM Disk Groups
- Rebalancing in ASM
- ASM Instance Background Process
- ASM Mirroring
- How to start and stop ASM Instance
- How to Add disk to DIskgroup
- How to change power limit
- How to Drop specific Disk from Diskgroup
- Create a new ASM diskgroup with normal redundancy
- SPFILE Parameter Values and RAC
- ASM initialization parameters
Section 8: Global Resource Management Concepts
- Necessity of Global Resources
- Global Resources Coordination
- Global Cache coordination
- Write to Disk Coordination
- Dynamic Reconfiguration and re-mastering
- Efficient Internode Row-Level Locking
- Global Resource Directory (GRD)
- Global Enqueues
- Split Brain and I/O Fencing
- Functions of I/O fencing
- Why Node Eviction?
- Who evicts/reboot the node?
- When Node Eviction?
Section 9:Managing Backup and Recovery for RAC
- RAC and Instance Recovery
- Instance Recovery and Database Availability
- Instance Recovery and RAC
- Protecting Against Media Failure
- Media Recovery in Oracle RAC
- Archived Log File Configurations
- Archived Redo File Conventions in RAC
- Oracle Recovery Manager (RMAN)
- Shared Storage Backup Scheme: One Local Drive
- Shared Storage Backup Scheme: Multiple Drives
- Configure FRA to ASM disk group
- Enable and disable archivelog mode in RAC
- Configure proper snapshot control file location
- Configure AUTOBACKUP SPFILE and controlfile backups
- Full database backup (No parallel slaves)
- Channel Connections to Cluster Instances
- Full database backup with parallel slaves on same node
- Full database backup with parallel slaves on other nodes(In run block)
- Restore and recover a lost datafile
- Restore and recover database (already SPFILE available )
- Restore and recover database – With LOST SPFILE
Section 10:High Availability of Connections
- Client Connectivity to RAC Database
- Configure TNSNAMES.ORA File
- Connect with Public IP, Virtual IP
- Connect with SCAN IP
- Oracle RAC Services for Client Connectivity
- Admin Managed And Policy Managed Database in RAC
- Convert RAC Database from Admin to Policy Manage
- Create Service in RAC Database using SRVCTL
- Start/Stop Service in RAC Database using SRVCTL
- Relocate Service in RAC Database using SRVCTL
- Transparent Application Failover ( TAF )
- TAF Basic and Preconnect
- Create Service with TAF
- Fast Application Notification ( FAN ): Overview
Section 11:RAC Administration Activities 1
- Monitoring blocks, LOCKS, DEADLOCKS
- View number of nodes in cluster
- Oracle Cluster Registry (OCR) File in RAC
- OCR file Backup and Recovery
- Oracle Local Registry (OLR) file in RAC
- OLR file Backup and Recovery
- Determining the Current Network Settings
- Voting Disk
- Check the location of voting disk
- Backup and Restore Voting Disk
Section 12:RAC Administration Activities 2
- Patching Activity in RAC
- Grid HOME and Databse HOME Patching
- Adding a Node to RAC – 2 Node to 3 Node
- Deleting a Node from RAC – 3 Node to 2 Node
Section 13: RAC database Monitoring and Tuning
- RAC-Specific Tuning
- Analyzing Cache Fusion Impact in RAC
- Wait Events in RAC
- Wait Event Views
- AWR Snapshots in RAC
- Generate AWR Report in RAC
- Analysis of AWR Report
- Analysis of ADDM Report
- Generate ASH Report
Section 14:Single Instance to RAC migration
- Methods of migrating single instance database to RAC.
- Migrate a single Instance to 2 node RAC setup.
- Configuration Changes During Oracle RAC Conversion Using rconfig
- Prerequisites for Converting to Oracle RAC Databases
- Converting non-RAC database files to ASM
- Converting Databases to Oracle RAC Using rconfig
Section 15:Upgrade Oracle RAC From 12c to 19c
- Perform pre-requisites steps for 19c
- Upgrade with Dry-run
- Actual upgrade