HP StorageWorks Storage Mirroring 5.0 application notes - High availability for Oracle 10g (T2558-88089, 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.

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

• Two licensed copies of Storage Mirroring 5.0 or later

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

• Two servers running Microsoft Windows Server 2003 x64 Edition

• Two licensed copies of Storage Mirroring version 5.0 or later

• Two licensed copies of Oracle 10g for Windows (x64)

• In addition, the system hardware must support 64-bit applications