Now that I have the 11G DBA OCP, I am pursuing the Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator certification. I need to pass the 1Z0-058 Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration Exam.

NOTE: I am not intending to complete the topics below. These topics are left incomplete.

Section 1 - 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

Section 2 - 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 (Appendix-D)

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

  • Configure server-side, connect-time load balancing

  • Use the Load Balancing Advisory (LBA)

  • Describe the benefits of Fast Application Notification (FAN)

  • Configure server-side callouts

  • Configure Transparent Application Failover (TAF)

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