Course Content
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
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
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)
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)
Design for high availability
- Adding Node and deleting nodes in existing RAC
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
