background image

White Paper

December 1998
ECG001/1298

Prepared by High Availability
Products Group

Compaq Computer Corporation

Contents

Managing Changes to Drive
Ordering .....................................3

Symptoms ................................3
When does this situation
occur? ......................................3
Preventing the Issue .................4
Simplifying Detection of the
Issue ........................................4
What Oracle Component is
Affected? ..................................4

Removing a Shared Storage
Array ...........................................8
Adding a Shared Storage
Array ...........................................9
Adding or Removing Drives
from a Shared Storage Array ...11

Replacing a Failed Drive .........11
Adding a Drive to Increase
Storage Capacity ....................12

Modifying Physical Cluster

Resources in a Compaq Parallel

Database Cluster

Abstract:

  At some time during the life of a Compaq Parallel

Database Cluster it is likely that some modifications to the physical
resources of the cluster will be required. This paper describes how to
perform some of the more likely modifications, such as:

 

Managing Changes to Drive Ordering

 

Removing a Shared Storage Array

 

Adding a Shared Storage Array

 

Adding or Removing Shared Storage Drives

Additional scenarios are described in Chapter 5 of the 

Compaq

Parallel Database Cluster Administrator Guide

.

Summary of Contents for 1850R - ProLiant - 128 MB RAM

Page 1: ...ailed Drive 11 Adding a Drive to Increase Storage Capacity 12 Modifying Physical Cluster Resources in a Compaq Parallel Database Cluster Abstract At some time during the life of a Compaq Parallel Database Cluster it is likely that some modifications to the physical resources of the cluster will be required This paper describes how to perform some of the more likely modifications such as Managing C...

Page 2: ...ive companies Compaq Contura Deskpro Fastart Compaq Insight Manager LTE PageMarq Systempro Systempro LT ProLiant TwinTray ROMPaq LicensePaq QVision SLT ProLinea SmartStart NetFlex DirectPlus QuickFind RemotePaq BackPaq TechPaq SpeedPaq QuickBack PaqFax Presario SilentCool CompaqCare design Aero SmartStation MiniStation and PaqRap registered United States Patent and Trademark Office Netelligent Arm...

Page 3: ...the disks will be shown in the wrong order When does this situation occur The situation occurs when the order in which the database s drives are brought online is different than the order in which the drives were brought online when the database cluster was originally set up Following are some specific examples When more than one shared storage array exists if the arrays are powered on in a differ...

Page 4: ...shared disks associated with the database could have a small unused partition as the first partition on the disk Assuming there are three disks associated with the database a sample configuration might be Harddisk1 Partition1 is sized to 11 MB Harddisk2 Partition1 is sized to 12 MB Harddisk3 Partition1 is sized to 13 MB When the cluster is powered on if disk administrator shows harddisk1 partition...

Page 5: ...et corresponding to the above configuration is in the following table Note that paritition1 on each disk is used for the small identifiable partitions discussed in the Simplifying Detection of the Issue section above and therefore partititon1 is not shown in the symbolic links worksheet Table 1 Original Oracle Symbolic Links Worksheet Symbolic Link Node1 Node2 OPS_log1t1 Harddisk2 Partition2 Hardd...

Page 6: ...ast 3 partitions In disk administrator the ordering of the disks in the second array changes The symbolic link table file must be changed Note If the cluster consists of more than two nodes the other symbolic link table files need to be modified as well Thus the new configuration of the cluster as seen by disk administrator is Node1 Disk 0 An internal disk Disk 1 An internal disk Disk 2 Shared sto...

Page 7: ...k1 Partition4 OPS_usr01 Harddisk3 Partition2 Harddisk2 Partition2 OPS_rbs01 Harddisk3 Partition3 Harddisk2 Partition3 OPS_tmp01 Harddisk3 Partition4 Harddisk2 Partition4 OPS_log1t2 Harddisk4 Partition2 Harddisk3 Partition2 OPS_log2t2 Harddisk4 Partition3 Harddisk3 Partition3 OPS_log1t3 new volume Harddisk5 Partition2 Harddisk4 Partition2 OPS_log2t3 new volume Harddisk5 Partition3 Harddisk4 Partiti...

Page 8: ...nt application As well it can be accomplished using an Oracle database administration tool SVRMGR Using SRVMGR from the command line enter the following commands 1 C SVRMGR30 2 SVRMGR connect internal password 3 SVRMGR shutdown 4 SVRMGR exit 2 Next stop the oracle service with the following command C Net stop oracleservice ops_instance_sid 3 Shutdown Windows NT Server and power off all the cluster...

Page 9: ...em See the Compaq Fibre Channel Storage System User Guide for details on how to install cables and shortwave Gigabit Interface Converters 6 Restart the fibre channel arrays To avoid the drive ordering issue explained in the Managing Changes to Drive Ordering section above restart the original arrays first in the same order they were started when the cluster was originally configured Then power on ...

Page 10: ... assignments as seen by disk administrator have changed Note The number of symbolic link table files depends on the number of nodes in the cluster All symbolic link table files must be modified 13 Power on each cluster node 14 Use the disk administrator remove the driver letters to the newly added partitions and to verify that the order of the disks is the order that is expected If not you will ne...

Page 11: ...nel array must follow certain rules that are interpreted by reading the LEDs on each drive within the storage array Be sure to read the Fibre Channel Storage System User Guide to understand these rules Failure to follow these rules may result in loss of data Replacing a Failed Drive The procedure for replacing a failed drive is completed totally within the fibre channel storage system Neither Orac...

Page 12: ...ion on each of the newly configured drive volumes 4 Using disk administrator create logical partitions within the newly created extended partitions IMPORTANT Do not format the drives Oracle8 Parallel Server uses RAW partitions which requires that the drive not be formatted with any file system 5 Use disk administrator to remove the drive letters that may be assigned to the newly created logical pa...

Reviews: