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

Storage Mirroring Guidelines for using Oracle 10g with Storage Mirroring Linux application notes 7
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 shell script file called
POST_FAILOVER.SH and save the file to the /usr/bin/
directory where the Storage Mirroring commands are installed. The
POST_FAILOVER.SH script should
include the following contents
********************************************************
#!/bin/bash
/etc/init.d/oracle start
********************************************************
2. The following example shows the
/etc/init.d/oracle script and SQL script to start and stop Oracle
services.
Sample_Init.d