HP StorageWorks Storage Mirroring application notes - High availability for Oracle 9i (T2558-88087, April 2008)

Storage Mirroring High availability for Oracle 9i application notes 7
NOTE: 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.
7. 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.
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 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 installed9
xdb#.dbf XML data
and
metadata
oracle\oradata\instance_name V_$DATAFILE
listener.or
a
Service
Configurati
on File
oracle\ora90\network\admin N/A
tnsnames.or
a
Client
Configurati
on File
oracle\ora90\network\admin N/A
pwd*.ora Password
Informatio
n File
\oracle\ora90\database N/A
File Name File
Description
Default Location Table to Query