Oracle RAC and Grid Infrastructure Administration Fast Track Training

Clusterware Topics

 

Grid Infrastructure Concepts

• What is a Cluster
• Grid Infrastructure Components
• Oracle Clusterware Architecture
• Oracle Clusterware Software and Storage
• Describe ASM Architecture
• ASM Disk Groups
• ASM Cluster File systems

Grid Infrastructure Installation and Configuration

• Hardware Requirements and Configuration
• OS Requirements and Prerequisites
• Storage Options
• Network Requirements
• The cluster interconnect
• GNS, DNS and DHCP Configuration
• Grid Plug and Play Considerations
• The Grid Naming Service
• Single Client Access Names

The Database Listener Model

• The SCAN listeners and the node listeners
• Database session connect time fault tolerance
• Session load balancing
• Runtime load balancing and fault tolerance

Administering Oracle Clusterware

• Adding, Deleting, or Migrating Voting Disks
• The Oracle Cluster Registry (OCR)
• OCR Mirroring and Backups
• The Oracle Local Registry
• Migrating voting file and OCR to ASM
• Managing Network Settings

Managing cluster resources

• Stopping, starting, and relocating  resources
• Registering third party applications
• Configuring dependencies between resources
• Writing event handler scripts

Oracle Clusterware High Availability

• Oracle Clusterware high availability components
• Contrasting policy-managed and administration managed databases
• Server pool functionality
• The Generic and Free Server Pools
• Application placement policies
• Application Virtual IPs
• Managing application resources

Troubleshooting Oracle Clusterware

• Oracle Clusterware Log Files
• Gathering Log Files Using diagcollection.pl
• Resource Debugging
• Component-level Debugging
• Troubleshooting the Oracle Cluster Registry

Database Topics

 

RAC and Grid Infrastructure

• Architectural summary
• ASM and share storage
• The SCAN and node listener model
• RAC solutions

Real Application Clusters Database Installation

• Installing The Oracle Database Software
• Single Instance to RAC conversion
• Creating A Clustered Database

Oracle RAC Administration

• Redo Log Files In A RAC Environment
• ndo Tablespaces In A RAC Environment
• Starting And Stopping RAC Databases And Instances
• Initialization Parameters In A RAC Environment

Managing Backup and Recovery for RAC

• Protecting Against Media Failure
• Archived Log File Configurations
• Database Backup and Recovery with RMAN
• Recovery following instance failure

Performance Tuning

• The Tuning Methodology
• The global cache and the global enqueue service
• RAC Specific Statistics and Wait Events
• Tuning Parallel Processing
• RAC Specific Performance Issues
• AWR and Statspack in a clustered environment

High availability and services

• RAC Service Architecture
• Configure and Manage Services in a RAC environment
• Using Services with Client Applications
• The fault tolerant architecture
• Instance evictions
• Policy managed databases and services
• Stretched clusters
• Maximum availability Architecture: RAC plus Data Guard

ASM Topics

 

Administering ASM Instances

• The ASM bootstrap
• Administration privileges and the password file
• ASM Initialization Parameters
• Adjusting ASM Instance Parameters in SPFILEs
• Starting and Stopping ASM Instances Using srvctl and other tools
• Tuning and monitoring the ASM instance

Administering ASM Disks

• Disk storage options: LUNs, directly attached storage, network attached storage
• Using the ASMLib and the ASM Filter Driver
• Using the udev facility

Administering ASM Disk Groups

• Creating And Deleting ASM Disk Groups
• The importance of the RDBMS, ASM, and ACFS compatibilities
• Placing the OCR and voting files on ASM devices
• ASM Disk Group Maintenance Tasks
• The various levels of redundancy
• Templates for striping and mirroring
• Hot and cold areas: exploit the geometry of the disks
• Fast mirror resynch
• choosing an allocation unit  size and a sector size
• Preferred Read Failure Groups
• Metadata backup and restore
• Performance And Scalability Considerations For ASM Disk Groups

ASM Files, Directories, and Templates

• Using Different Client Tools to Access ASM Files
• Creating and Managing ASM files, Directories and Aliases
• Applying templates to files
• File extents, segment extents, and allocation units
• Techniques for moving files within, into, and out of ASM
• Security and Access Control Lists

Administering ASM Cluster File Systems

• The ASM Dynamic Volume Manager
• The ACFS file system driver
• The ACFS bootstrap
• Managing ASM Volumes: striping and mirroring
• ACFS file system snapshots
• ACFS  file system replication
• ACFS file system encrption
• The administration tools: srvctl, asmca, acfsutil, Unix utilities

Flex ASM

• Conversion from standard ASM to Flex ASM
• Conversion from standard cluster to flex cluster
• Configuring and using Flex ASM
• The ASM network
• The ASM listeners
• Set the ASM instance cardinality
• Relocate ASM instances and clients
• The ADVM proxy service for ACFS in a Flex ASM environment

ASM, ACFS, and the database

• Defining dependencies between a database and diskgroups
• Defining dependencies between a database and file systems
• Using ACFS for the database Oracle Home
• Using ACFS to store database files