Oracle RAC DBA Training

Oracle RAC Introduction

Grid Infrastructure: Clusterware and ASM

Oracle Grid Infrastructure

Explain the principles and purposes of clusters

Describe Cluster hardware best practices

Understand Oracle Clusterware Architecture

Describe how Grid Plug and Play affects Clusterware

Describe ASM architecture and components

Grid Infrastructure Installation

Perform pre-install tasks for Grid Infrastructure

Install Grid Infrastructure

Verify the installation

Configure ASM disk groups

Configure ASM volumes

Make ASM cluster file system

Mount ACFS volumes

Administering Oracle Clusterware

Display Clusterware management proficiency

Demonstrate OCR backup and recovery techniques

Managing Network Settings

Managing Clusterware

Perform prerequisite steps for extending a cluster

Use Oracle Universal Installer (OUI) to add a node to an Oracle Clusterware home

Use OUI to remove a node from an Oracle Clusterware home

Making Applications Highly Available With Oracle Clusterware

Describe the High Availability components of Oracle Clusterware

Contrast Policy-Managed and Administration Managed databases

Describe the functionality of server pools

Describe application placement policies

Create an application Virtual IP (VIP)

Manage application resources

Troubleshooting Oracle Clusterware

Locate Oracle Clusterware log files

Gather all log files using diagcollection.pl

Enable resource debugging

Enable component-level debugging

Enable tracing for Java-based tools

Troubleshoot the Oracle Cluster Registry (OCR) file

Administering ASM Instances

Understand and apply ASM initialization parameters

Manage ASM instances and associated processes

Monitor ASM using the V$ASM dynamic performance views

Administering ASM Disk Groups

Create and delete ASM disk groups

Set the attributes of an existing ASM disk group

Perform ongoing maintenance tasks on ASM disk groups

Explain key performance and scalability considerations for ASM disk groups

Administering ASM Files, Directories, and Templates

Use different client tools to access ASM files

Describe the format of a fully qualified ASM file name

Explain how ASM files, directories and aliases are created and managed

Understand and manage disk group templates

Administering ASM Cluster File Systems

Administer ASM Dynamic Volume Manager

Manage ASM volumes

Implement ASM Cluster File System

Manage ASM Cluster File System (ACFS)

Use ACFS Snapshots

Using command line tools to Manage ACFS

Real Application Clusters

Real Application Clusters Database Installation

Install the Oracle database software

Create a cluster database

Perform post-database creation tasks

Perform a single instance to RAC conversion

RAC Database Administration

Use Enterprise Manager cluster database pages

Define redo log files in a RAC environment

Define undo tablespaces in a RAC environment

Start and stop RAC databases and instances

Modify initialization parameters in a RAC environment

Managing Backup and Recovery for RAC

Configure the RAC database to use ARCHIVELOG mode and the flash recovery area

Recover from media failure and instance failures

Tune instance recovery in RAC

Configure RMAN for the RAC environment

RAC DB Monitoring and Tuning

Determine RAC-specific tuning components

Determine RAC-specific wait events, global enqueues, and system statistics

Implement the most common RAC tuning tips

Use the Cluster Database Performance pages

Use the Automatic Workload Repository (AWR) in RAC

Use Automatic Database Diagnostic Monitor (ADDM) in RAC

Services

Configure and manage services in a RAC environment

Use Services with client applications

Use services with the Database Resource Manager and scheduler

Configure services aggregation and tracing

High Availability Connections

Configure client-side, connect-time load balancing and connect-time failover

Configure server-side, connect-time load balancing

Use the Load Balancing Advisory

Describe the benefits of Fast Application Notification

Configure server-side callouts

Configure Transparent Application Failover

Design for High Availability

Design a Maximum Availability Architecture in your environment

Determine the best RAC and Data Guard topologies for your environment

Configure the Data Guard Broker configuration files in a RAC environment

Patch your RAC system in a rolling fashion