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

10
rem ## The following line starts the Oracle Listener service. The outcome is redirected to
rem ## the failover directory where a log file is created. Check this log file for errors.
NET START OracleOraHomeTNSListener >>%ORACLE_FO%\start_services.log
NOTE: After failover is complete, users will need to log back into the Oracle database. You may want to
devise an automatic process to notify the users of this information and include it at the end of the
post-failover script.
The following example shows the DB_START.SQL script used in the post-failover script.
Sample_dbx_start.sql
## *** SAMPLE*** db_start.sql script called during the Storage Mirroring post-failover
sequence.
## This sample batch file is provided as an example only. Because no two
## environments or configurations are exactly the same, you MUST modify
## this script in order to make the solution work in your environment.
## The following line identifies the Oracle instance to start.
## Replace instance_name with the name of the instance. Make sure to update the path for
## your version of Oracle.
startup pfile=G:\oracle\product\10.x.x\admin\Instance_name\pfile\init.ora.7242004184845
exit
2. After a failure is resolved, you will be ready to bring your source back online. At this time, you will
want to stop the Oracle services on the target automatically. To do this, create a batch file called
preback.bat using the sample batch file below. Save the batch file to the same directory where your
Storage Mirroring files are installed.