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

NOTE: There is a unique numeric identifier at the end of the init.ora file (xxxxx) that uniquely

identifies initialization files when there is more than one installed.

Besides the initialization parameter file (init.ora), which is stored in a text format, administrators can

choose to maintain the initialization parameters in a binary server parameter file (spfile.ora). This is

installed by default

The Listener service will not start on the target if listener.ora is replicated from the source, but the

target is not in a failed over state. This file contains configuration information that is not valid on the target

unless it is in a failed over state. If you need to start Oracle on the target server without failing over, do not

include listener.ora in the replication set.

5. After you have selected all of the Oracle data you wish to protect, right-click the replication set name

and select Save to save the replication set.

6. Right-click on the source and select Properties.

7. On the Source tab, enable Block Checksum All Files on a Difference Mirror and click OK.

8. Drag and drop the replication set onto the target. The Connection Manager dialog box opens.

9. The Source Server, Target Server, Replication Set, and Route fields will automatically be populated. If

you have multiple IP addresses on your target, verify the Route field is set to the correct network path.

(For detailed information on connecting a source and target, see the HP StorageWorks Storage

Mirroring user's guide.)

10. Select One to One to map the replication set data from the source to an identical volume/directory

structure on the target.

11. Click Connect to start the mirror and replication processes.

NOTE: If you start Oracle and mount the replicated databases on the target, or if the data on the target

is otherwise modified, the data on the source and target will no longer match. If the updated data on the

target is not needed, perform a full or difference with block checksum mirror from the source to the target.

If the updated data on the target is needed, restore the data from the target to the source.

Configure failover and begin failure monitoring

1. If a failure occurs, you will want to have the Oracle services start on the target machine automatically.

To do this, create a batch file called POSTOVER.BAT using the sample batch file below. Save the

batch file to the same directory where your Storage Mirroring files are installed.

NOTE: 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.