Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 5 - Preparing Shared Storage

Failure Groups

Each set of failure groups is site-specific. This is because failure group decisions are based on how your system tolerates the failure of specific components. For example, suppose you have ten disks and one SCSI controller. The failure of the one SCSI controller makes all ten disks unavailable. In this scenario, you should put each SCSI disk in its own failure group.

Each disk is assigned to its one failure group in ASM by default. However, this assignment of failure groups can be over-ridden by the administrator when creating a disk group or adding a disk to a disk group. The layout of data is then optimized by ASM to reduce the unavailability of data due to failures.

A failure group is maintained in a disk group, and multiple failure groups can exist within any given disk group. However, changing a disk's failure group requires dropping the disk from the disk group and then adding the disk back to the disk group under the new failure group name.

ASM Instances

The Oracle Database 10g introduces the ASM instance, a special Oracle instance that manages the disks in disk groups. The ASM instance must be configured and running for the database instance to access, Automated Storage Management files.

Remote DBA Services

Burleson Consulting can offer world-class remote Oracle database support at super-affordable prices.

Our remote Oracle DBA service provides 100% of the remote Oracle database administration needs for your company, and includes 24x7 access to our staff of 100% OCP Certified Oracle DBAs. 

We require a 12 month service commitment and include the following services:

• Initial configuration review and problem identification
• Installation of Oracle statistics collection mechanisms and quarterly database growth summaries
• Hourly monitoring of your Oracle database for pending problems
• Periodic performance analysis & identification of tuning activities
• Twenty Four hour Oracle emergency support
• Reporting and resolving all serious Oracle alert log messages
• Free use of the BC TablePack, ServerPack and AuditPack services
• Quick response emergency support for production database outages
• Four hours of free remote DBA support every month. You can use these free hours for any DBA activity, including database analysis, system design, production migrations or personal mentoring.

For more information, please visit www.dba-oracle.com or email info@remote-dba.net.