Section I : RAC Administration
RAC Installation
- Install and configure Automatic Storage Management (ASM)
- Install the Oracle database software
- Perform pre database creation tasks
Database Creation
- Install the Enterprise Manager agent on each cluster node
- Create a cluster database
- Perform post database creation tasks
RAC DB Administration
- Use Enterprise Manager cluster database pages
- Define and manage redo log files in a RAC environment
- Define and manage undo tablespaces in a RAC environment
- Start and stop RAC databases and instances
- Modify initialization parameters in a RAC environment
- Create and manage ASM instances in a RAC environment
- Create and manage ASM Disk Groups and ASM Files
Backup and Recover a RAC DB
- Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
- Configure RMAN for the RAC environment
- Explain the implications of OracleNet for connecting RMAN for parallel backups
|
RAC DB Monitoring and Tuning
- Explain RAC-specific tuning considerations and techniques in an environment involving mixed workloads
- Tune instance recovery in RAC
- Determine RAC-specific wait events, global enqueues, and system statistics
- Diagnose and improve common RAC-specific performance problems involving indexes, sequences and undo
- 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
- Connect your client to a RAC database using services
- Use services with the Database Resource Manager
- Use services with the Scheduler
- Set performance-metric thresholds on services
- Configure services aggregation and tracing
High Availability of Connections
- Configure client-side connect-time load balancing
- Configure client-side connect-time failover
- Configure server-side connect-time load balancing
- Use the Load Balancing Advisory (LBA)
- Describe the uses of Fast Application Notification
- Describe the uses of server-side callouts
- Describe the purposes of server- and client-side ONS
- Configure Transparent Application Failover (TAF)
Design for HA
- Design a Maximum Availability Architecture in your environment
- Determine the best RAC and Data Guard topologies for your environment
- Explain Data Guard Broker configuration files in a RAC environment
- Decide on the best ASM configuration to use
- Patch your RAC system in a rolling fashion
RAC Technology Overview
- Recommend appropriate use and possible application of RAC technology to address scalability, high availability and grid provisioning requirements.
|
Section II : Cluster Management
Oracle Clusterware Installation
- Describe the capabilities and features of Oracle Clusterware
- Perform preinstallation and cluster setup tasks
- Install Oracle Clusterware
- Describe the different storage options and their implications (OCFS, raw disks, ASM)
Oracle Clusterware Administration
- Manually control the Oracle Clusterware stack
- Change voting disk configuration
- Back up and recover your voting disks
- Manually back up and recover the OCR, and repair the OCR configuration
- Explain application VIPs and change VIP addresses
- Use Clusterware to protect non-Oracle applications
- Prevent automatic instance restarts
Diagnosing the Oracle Clusterware components
- Enable and collect diagnostics for Oracle Clusterware
- Set debugging flags for OCR-related tools
- Enable Oracle Clusterware debugging
- Enable tracing for Java-based tools
- Use Cluster Verify
Node Addition and Removal
- Add a new node to your cluster database
- Remove a node from your cluster database
|
