HP StorageWorks Guidelines for using Oracle® 11g with HP StorageWorks Storage Mirroring 5.
Legal and notice information © Copyright 2009 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents About this guide ................................................................................... 5 Intended audience ...................................................................................................................... Prerequisites ............................................................................................................................... Related documentation ...................................................................................................
Tables 1 Document conventions ...............................................................................................
About this guide This document is a HP StorageWorks Storage Mirroring application note. An application note provides guidelines on the use of Storage Mirroring in a specific environment. This document contains: Document Overview: Explains what an application note contains, how it should be used, what you need to know before trying to use the application note, and where you can go for more information.
Related documentation Before you begin to configure your solution, make sure that you have complete documentation for your operating system, application, and Storage Mirroring. This application note does not provide step-by-step instructions for using standard operating system, application, and Storage Mirroring functionality.
CAUTION: Indicates that failure to follow directions could result in damage to equipment or data. IMPORTANT: Provides clarifying information or specific instructions. NOTE: Provides additional information. TIP: Provides helpful hints and shortcuts. HP technical support For worldwide technical support information, see the HP support website: http://www.hp.
Documentation feedback HP welcomes your feedback. To make comments and suggestions about product documentation, please send a message to storagedocsFeedback@hp.com. All submissions become the property of HP.
1 Solution Overview Oracle is a scalable, reliable, flexible, and high-performance relational database management system for many server-based operating systems. Storage Mirroring Availability provides real-time enterprise data protection and replication. Storage Mirroring Availability can be used to provide high availability for Oracle. This document describes the steps necessary to configure Storage Mirroring Availability to provide high availability for Windows® servers running Oracle 11g.
• Two licensed copies of Storage Mirroring Availability 5.0 or later • Two licensed copies of Oracle 11g for Windows (x64) • In addition, the system hardware must support 64-bit applications Modifying the sample script files Sample batch files are available at http://support.hp.com. 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 Availability is installed.
2 Sample Implementation This section describes an example of how to configure Storage Mirroring Availability 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 here in order to make the solution work in your environment. Install software on the source 1. 2.
3. In the tree under the replication set name, select the Oracle data you wish to protect. The following table will help you verify that you have selected all pertinent Oracle files necessary to enable high availability on your target machine. • File Name—This column lists each file name you need to select for replication. These files are assigned names during your initial Oracle installation and configuration causing some of these files to be unique to your environment.
File Name File Description Default Location Table to Query listener.ora Listener File Drive letter:\app\\product\<11.1.0>\db_1\network\admin N/A tnsnames.ora Service Configuration FIle Drive letter:\app\\product\<11.1.0>\db_1\network\admin N/A pwd*.ora Password Information File Drive letter:\app\\product\<11.1.0>\db_1\network\admin N/A spfile*.ora Server Parameter File Drive letter:\app\\product\<11.1.0>\db_1\network\admin N/A emkey.
9. Select One to One to map the replication set data from the source to an identical volume/directory structure on the target. 10. 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.
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. Guidelines for using Oracle® 11g with HP StorageWorks Storage Mirroring 5.
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. Save the batch file to the same directory where your Storage Mirroring Availability files are installed. The following example illustrates the DB_STOP.SQL script used in the pre-failback script. 3. 4. 5.
6. 7. 8. 9. Select a source machine to monitor by clicking Add Monitor. Type the name of the source machine and click OK. The Monitor Settings window will open. In the Monitor Settings window, select the checkbox for the IP address that is going to failover. Highlight an IP address that you have selected for monitoring and select a Target Adapter that will assume that IP address during failover. Repeat this process for each IP address that is being monitored.
3. If you must rebuild your hard drive, complete the following. If you do not need to rebuild your hard drive, skip this step and continue with step 4. a. Install Windows. Since your source machine is not connected to the network, use the source’s original name and IP address. b. Install Storage Mirroring Availability using the installation defaults. c. Install Oracle using the installation settings previously used. 4. 5. 6. Disable all of the NICs on the source.
• Restore To—The name of the machine where the data will be restored. This is your temporary source that has the unique IP address. 14. Identify the correct drive mappings for the data and any other restoration options necessary. For detailed information on the restoration options, see the HP StorageWorks Storage Mirroring user's guide. 15. Verify that the selections you have made are correct and click Restore to begin the restoration.
At this time, your data is restored back to your source machine, the source machine is again the primary Oracle server, and, if you selected to continue failover monitoring, the target is available to stand in for the source in the event of a failure.