HP StorageWorks Storage Mirroring application notes Guidelines for using Oracle 10g with Storage Mirroring Linux (T2558-96087, February 2008)

HP StorageWorks offers professional services on a fee basis to assist you in identifying the best practices

for implementing a solution in your environment. Visit

http://www.doubletake.com/what-we-offer/services/

for more information.

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

Linux

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 running Red Hat

Enterprise Linux

version 4.2 through 4.5

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

• Both servers must be connected to the same physical network

• Two licensed copies of Oracle 10g (the number of licenses required may vary based on your individual

Oracle license agreement)

• Two licensed copies of Storage Mirroring for Linux

• If you are using Oracle 10g for Linux servers (64Bit), the following minimum versions are required:

• Two servers running Red Hat Enterprise Linux 4.2 through 4.5 (64-bit)

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

• Both servers must be connected to the same physical network

• Two licensed copies of Storage Mirroring for Linux

• Two licensed copies of Oracle 10g for Linux (x64) (the number of licenses required may vary based on

your individual Oracle license agreement)

• The system hardware must support 64-bit applications

Permissions

The source and target machines must share the same user accounts that have the same GUID. HP

StorageWorks strongly recommends that customers use unified network accounts in order to facilitate

transferring the database from the source to the target.