HP StorageWorks Storage Mirroring 5.0 application notes - High availability for Oracle 11g (T2558-88090, April 2008)

Getting help

Hewlett-Packard has application notes that describe how to configure Storage Mirroring with a variety of

popular third-party applications. These application notes are available on the Storage Mirroring web site:

http://h18006.www1.hp.com/products/storage/software/sm/index.html

For help using Storage Mirroring, refer to the Storage Mirroring online manual or online help.

Solution Overview

Oracle is a scalable, reliable, flexible, and high-performance relational database management system for

many server-based operating systems. Storage Mirroring provides real-time enterprise data protection and

replication. Storage Mirroring can be used to provide high availability for Oracle.

This document describes the steps necessary to configure Storage Mirroring to provide high availability for

Windows servers running Oracle 11g. These procedures allow a secondary server to assume the identity

and role of a failed primary Oracle server while maintaining the availability of Oracle services with

minimal disruption or data loss.

To complete these instructions, you will install Oracle and Storage Mirroring, and configure Storage

Mirroring for replication and failover. Due to the complexities of these applications, this document is

intended for network administrators with experience installing, configuring, and maintaining network

applications including Storage Mirroring and Oracle

NOTE: Storage Mirroring allows you to configure one target to monitor and failover for one or more

source machines. In a one-to-one configuration, you will want to replicate your Oracle data to the same

location on the target so that failover is automatic. In a many-to-one configuration, the data will need to be

replicated to a unique location and then renamed to the corresponding Oracle directory on the source

before failover occurs.

This application note focuses on a single Oracle server being replicated to a single target.

Requirements

• Two servers that meet one of the following operating system requirements:

• Microsoft Windows 2000 with Service Pack 4 or later

•Microsoft Windows 2003

•Microsoft Windows 2003 R2

NOTE: The two servers should both be running the same operating system.

• It is recommended that both source and target servers be member servers. (You may experience

problems with promotion and demotion during failover if either of the machines are Primary or Backup

Domain Controllers.)

• Both servers must be connected to the same physical network

• Two licensed copies of Oracle 11g

• Two licensed copies of Storage Mirroring 5.0 or later

If you are using Oracle 11g for Windows (x64), the following minimum versions are required: