HP StorageWorks Storage Mirroring application notes - High availability for Oracle 9i (T2558-88087, April 2008)

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 10g. 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

NOTE: The two servers should both be running the same operating system. Although cross-platform

mirroring and replication are available, Storage Mirroring software recommends that the two servers be

the same platform for effective failover and failback.

• 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.)

• Two licensed copies of Oracle 9i

• Two licensed copies of Storage Mirroring version 4.5 or later

Modifying the sample script files

After you modify the sample scripts, save them with a new name to remove the SAMPLE_ prefix. Copy the

scripts to the directory where Storage Mirroring is installed.

The sample batch files provided are only examples. Because no two environments or configurations are

exactly the same, you MUST modify the sample scripts in order to make the solution work in your

environment.