Oracle RAC database administration training will help you to explore the Oracle Grid Infrastructure environment. Our expert apps2fusion instructors will help you master on the skills to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL and SQL*Plus. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.
Preview
By the end of this training you will learn to:
- Install Oracle Clusterware and Real Application Clusters.
- Administer a RAC Database.
- Administer database services in an RAC environment.
- Administer Oracle Clusterware.
- Add/Remove a node to/from a cluster.
- Patch Oracle Clusterware and RAC software.
- Upgrade and path Oracle RAC databases.
- Study the new connection architecture and how to make those connections highly available.
Course Contents
Day 1
Introduction
Introduction of Clusters
Types of Clusters
Components of Clusters
Hardware Requirements of Clusters
Define Oracle Real Application Clusters
List the Advantages of Using RAC
RAC Architecture And Concepts
SGA Structures
Background Processes
Oracle 11g RAC Overview
Operating System preparation for RAC
Introduction to Network Hardware
Private and Public Network configuration
SHMMAX and Semaphores for Oracle 11g RAC
Groups and Users for Oracle Software
Cluster Setup Tasks
Introduction to 11g RAC daemons
Storage Options for RAC Database files
Introduction to ASM
Advantages of ASM
Parameters used to configure ASM
Parameters used for RAC database
RAC Initialization Paramater Files
Day 2
RAC Installations
Installing Cluster Ready Services
Install Database Software
RAC Database Creation
Creating the Cluster Database
Manage redo log groups in a RAC environment
Manage undo tablespaces in a RAC environment
Archiving schemes in RAC
Day 3
OCFS [Oracle Cluster File System]
Introduction to OCFS2 File system
Advantages of OCFS2
RAC Database creation of OCFS
Enterprise Manager requirement in RAC
Enterprise manager configuration for RAC
Administrating Services with EM
Administering Alerts with EM
RAC Administration
SRVCTL necessity in RAC
Starting and Stopping instances and database
Enabling and Disabling services
Working with spfile in RAC environment
Management of OCR and Voting Disk. (Addin, Removing, Backup)
Day 4
Managing Backup and Recovery in RAC
Consideration for Logical Backups in RAC
Physical Backup and Recovery in RAC through RMAN
Migration to RAC (single instance to multi-instance)
Day 6
High availability connections configuration and Services in RAC
Configure server side connect -time load balancing
Configure client side connect -time load balancing
Configure and manage services with srvctl commands
RAC performance tuning aspects
Determine RAC specific tuning components
Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC
EM Cluster Database Performance pages
Apps2Fusion Articles 