Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure Administration (1Z0-058)

Exam Topics
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

Summary Notes

Starting with Oracle Database 11g Release 2, Oracle Clusterware and Oracle ASM are installed into a single home directory, which is called the Grid home.

Oracle Clusterware enables servers, referred to as hosts or nodes, to operate as if they are one server, commonly referred to as a cluster. Although the servers are standalone servers, each server has additional processes that communicate with other servers. In this way the separate servers appear as if they are one server to applications and end users. Oracle Clusterware provides the infrastructure necessary to run Oracle RAC. The combined processing power of the multiple servers provides greater availability, throughput, and scalability than is available from a single server.

The nodes in a cluster can be organized into a server pool for better resource management. Each server pool has the following properties:

  • The minimum number of nodes that should be in the server pool
  • The maximum number of nodes that can be in the server pool
  • The relative importance of this server pool to other server pools

Upon installation of Oracle Grid Infrastructure for a cluster, a default server pool, called the Free pool, is created automatically. All servers in a new installation are assigned to the Free server pool, initially. If you create a new server pool, then the servers move from the Free pool to the new server pool automatically.

When you create an Oracle RAC database that is a policy-managed database, you specify the number of servers that are needed for the database, and a server pool is automatically created for the database.Oracle Clusterware populates the server pool with the servers it has available.

If you do not use server pools, then you create an administrator-managed database. For the purposes of this guide, we use an administrator-managed Oracle RAC database.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s