HP StorageWorks Storage Mirroring application notes - High availability for Oracle 10g (T2558-88088, April 2008)

Sample implementation

This section described an example of how to configure Storage Mirroring and Oracle.

Use these procedures as a guideline for creating your own implementation.

Because no two environments or configurations are exactly the same, you will probably

need to implement additional or different steps than what is documented in order to

Install software on the source.

Install software on the source

1. Install Oracle on the source, if it is not already installed.

2. Create the Oracle database instance(s), if they are not already created.

3. Install Storage Mirroring on the source using the installation defaults. See the HP

StorageWorks Storage Mirroring getting started guide for details.

Install and configure software on the target

1. Install Oracle on the target using the same installation options used on the source

machine.

2. Create the Oracle database instance(s), using the same parameters as on the source

server.

NOTE: Creating the Oracle database instance on the target using the same

name and parameters as used to create the source (production) database

instance will ensure that the necessary instance and services are available

on the target at failover time and would only need to be started.

If, however, the instance is not created on the target prior to creating the

Storage Mirroring connection, you will have to create the instance during

failover. The command is included as a remark in the sample post-failover

script provided with this application note.

3. Set the Oracle service to manual startup so that the failover and failback scripts that

you will be creating will control the stopping and starting of the Oracle service.

a. In Control Panel, Administrative Tools, Services, double-click the Oracle service.

b. Click the General tab.

c. Select Manual from the Startup type drop-down list and click OK.

4. Install Storage Mirroring on the target using the installation defaults. See the HP

StorageWorks Storage Mirroring getting started guide for details.

Configure Storage Mirroring and begin mirroring and

replication

1. Select Start, Programs, Storage Mirroring, Management Console.

2. Double-click your source machine to log on.

3. Right-click your source machine and select New, Replication Set and enter the

desired name for the replication set.

4. Select the Oracle data you wish to protect. The table below will help you verify that

you have selected all pertinent Oracle files necessary to enable high availability on

your target machine.