Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
OR2403 Oracle 11g Real Application Clusters (RAC) for Administrators on your request on your request Contact Us

Oracle 11g Real Application Clusters (RAC) for Administrators

Oracle 11g Real Application Clusters (RAC) for Administrators

Overview

Course code: 
OR2403
Duration: 
5
Time Unit: 
Day(s)
Overview: 

This hands-on course teaches students all aspects of Oracle® 11g RAC administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and backup and recovery are all covered in detail. Students will get hands-on experience with Automatic Storage Management. The course ends with troubleshooting and tuning a RAC system.
Audience: Database

Topics

Topics: 

1. Cluster Architecture
Cluster Architecture
Shared Storage
Nodes and Interconnects
Oracle Cluster Registry (OCR)
The RAC Voting Disk
Virtual IP Addresses
SCAN Addresses and GNS
Oracle Software

2. Oracle Clusterware
What is Oracle Clusterware?
Oracle Clusterware Files
Oracle Clusterware Processes
The Grid Home
Oracle Clusterware Preinstallation Steps
Node Preparation
Configuring SSH User Equivalency
cluvfy – The Cluster Verification Utility
Installing the Grid Infrastructure
Oracle Clusterware Postinstallation Steps

3. Installing DB Software and Creating a RAC Database
Installation Overview
Configuring the OS Environment
Verifying System Readiness with the CVU
Installing the Database Software
Troubleshooting Installation Setup
Recommended Postinstallation Tasks
Database Pre-Creation Tasks
Creating a Cluster Database Using DBCA
Initialization Parameters
ORACLE_SID in a RAC Environment

4. RAC Database Architecture
Overview of RAC
Oracle Single-Instance Architecture
RAC Architecture
RAC Instances and Parameter Files
RAC Database Components
RAC Instance Background Processes
Global Resource Directory
Overview of Cache Fusion
Cache Fusion Components – GES and GCS
Cache Fusion Components – Resource Master and GRD
Application Connection to RAC

5. RAC Instance Management
Overview of RAC Instance Management
Starting and Stopping RAC Database
Starting and Stopping a RAC Instance
RAC Database Identical Parameters
RAC Database Unique Parameters
Changing Parameter Values
Administering Undo Tablespaces in RAC
Administering Redo Logs in RAC

6. Managing Oracle Clusterware
About Oracle Clusterware
Adding and Removing Voting Disks
Backing Up and Recovering Voting Disks
The OCR
Changing the OCR Configuration
Adding and Removing an OCR Location
Backing Up and Recovering the OCR
Restoring from Automatic OCR Backups
Moving or Replacing the OCR
Repairing the OCR Configuration
Troubleshooting the OCR

7. RAC Utilities
The olsnodes Utility
The ocrcheck Utility
The ocrdump Utility
Querying Clusterware Resource Status
The crsctl Utility
The Server Control (SRVCTL) Utility
SRVCTL ADD
SRVCTL CONFIG
SRVCTL ENABLE and DISABLE
SRVCTL GETENV
SRVCTL MODIFY
SRVCTL RELOCATE
SRVCTL STATUS
SRVCTL REMOVE
SRVCTL START
SRVCTL STOP

8. Services
Overview of Services
Types of Services
Creating Services with srvctl
Preferred and Available Instances for Services
Using Services
Managing Services
Service Views
Tracing with Services

9. Failover
Transparent Application Failover (TAF)
Client-Side vs. Server-Side TAF
Configuring TAF on the Client
Using OEM to Configure TAF
Using srvctl to Configure TAF
The DMBS_SERVICE Package
Connecting to the Database with TAF
Monitoring TAF Connections

10. RAC Backup and Recovery
Overview of RAC Backup and Recovery
Log Archiving in RAC
Undo Tablespaces in RAC
Using Flashback Features in RAC
Deploying a Fast Recovery Area in RAC
Performing RMAN Backups of a RAC Database
Performing Non-RMAN Backups
Preparing to Restore and Recover with RMAN
Recover the RAC Database with RMAN
Recovering Without RMAN

11. Cluster Management
Overview of Cluster Management Tasks
Extending the Clusterware Home Directory
Extending the Database Software Home Directory
Creating the New Instance
Verifying the New Instance
Removing a Node

12. Automatic Storage Management
ASM Overview
ASMLib
Installing ASM
Creating an ASM Instance
ASM Initialization Parameters
Accessing an ASM Instance
ASM Startup and Shutdown
Creating a Disk Group
Dynamic Perfomance Views for ASM
Changing a Disk Group
Oracle-Managed Files
Creating and Managing a Database
Creating and Managing a Tablespace
Creating and Managing Redo Logs
Creating and Copying Control Files
Backing up and Restoring Control Files
Creating and Managing Archive Logs
ASMCMD

13. ASM Backup, Recovery, and Migration
Overview of ASM Backup and Recovery
Overview of Recovery Manager (RMAN) and ASM
Migrating a Database to ASM
Migrating the Control File
Migrating the Database Files
Migrating the Online Redo Logs
Migrating SPFILEs

14. Clusterware and RAC Troubleshooting
The Oracle Clusterware Alert Log
Clusterware Component Log Files
Automatic Diagnostic Repository and ADRCI
Using crsctl to Diagnose Cluster Issues
Using diagcollection.pl
Checking Interconnect Settings
cluvfy – Verifying Clusterware Component Integrity
cluvfy – Verifying Cluster Registry Integrity
cluvfy – Verifying Cluster Integrity
ocrcheck – Verifying the Oracle Cluster Repository
RAC Database Alerts
Cluster Health Monitor (CHM)
The racdiag.sql Script
The oradebug Utility

15. RAC Tuning
RAC Tuning Methodology
Using Performance Views in RAC
Monitoring Cache Fusion
Global Cache Latencies
Monitoring Cache Transfers
OEM – Cluster Database Performance
OEM – RAC-Related Reports
Using AWR in the RAC Environment
Generating AWR Reports
Analyzing AWR Reports
Using ADDM in the RAC Environment
Analyzing ADDM Reports
RAC Tuning Tips and Best Practices

16. Appendix – Preparing a RAC Node
Checking the Hardware Requirements
Identifying Network Requirements
Configuring Operating System Users and Groups
Generating RSA and DSA Keys
Adding the Keys to an Authorized Key File
Configuring SSH User Equivalency
Configuring the Operating System Environment
Configuring the Network
Verifying the Network Configuration
Preparing the Operating System and Software
Configuring Installation Directories and Shared Storage
Choosing Directories

Prerequisites

Prerequisites: 

Oracle 11g Database Administration and at least 6 months of administration experience recommended.

Audience

Audience: 

Database administrators new to the RAC environment