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
System Builds
The build journals for the systems used are gathered in System Builds.