Advice on allocating SAN storage to a virtual database server on VMware Post: 303027927

Sponsored Content

Operating Systems Linux Red Hat Advice on allocating SAN storage to a virtual database server on VMware Post 303027927 by Scrutinizer on Friday 28th of December 2018 09:23:31 AM

12-28-2018

Moderator

For both performance and availability reasons I would keep tend the setup of different luns for different part of the database , data, redo, archive, duplex, unless there are small database and/or only crash recovery is required.. You can create different Volume groups for each set of disks.. Definitely also a different VG for OS data.
It may be beneficial to spread the date over several LUNS in the data VG, with or without a small stripe, that depends on your workload and underlying SAN storage, to overcome bottlenecks due to the sequential nature of SAN connectivity (Fibre Channel, iSCSI). An alternative to the latter may be to enlarge the queuing depth, it all depends. The other Oracle VG's require sequential access, where a single disk (two lun paths) will probably suffice..

If you don't use ASM, you would need to determine if you want to use raw or cooked logical volumes within the VG's.
You need to set multipathing, and then there is the backup and recovery method you need to choose, etc..

Last edited by Scrutinizer; 12-28-2018 at 10:31 AM..

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

5 More Discussions You Might Find Interesting

1. Solaris

Using San storage - advice needed

Thinking of using our San for network backups.. Have a Netra 240 being installed and planning to get some space on our San. Do you know what software is used to access the San from my server or what I would need to do? I know how to connect to local storage, disk arrays etc but not sure what...

2. Solaris

SAN Storage to solaris 10 server

Hi, I have configured our SAN Storage to be connected to our new SUN T5220. On the SAn it looks all fine on the server I do not see any connection: cfgadm -al Ap_Id Type Receptacle Occupant Condition c1 scsi-bus connected ...

3. SuSE

Hot-add memory to SuSE / VMware virtual server

Hi, Here is the issue. Some more memory has been added from vCenter to the virtual machine. From the virtual machine running SuSE 11 SP3. # modprobe acpiphp # modprobe acpi-memhotplug # grep -v online /sys/devices/system/memory/*/state # It looks like there is no offline memory, but free...

4. UNIX for Dummies Questions & Answers

Allocating Unallocated Drive Space from a SAN to a filesystem

Good Morning everyone, I want to know how to allocate unallocated drive space from a SAN to a file system that desperately needs the drive space. Does anyone have any documentation or tips on how to accomplish this? I am running on AIX version 6.1.

5. Homework & Coursework Questions

How to mount a 79TB SAN storage to another server?

Hi Team, How do i mount or connect the SAN storage to a specific folder. I have tried to mount it but each time i can only mount 900GB of the storage to the folder: ipmi1 ~]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-root_vol ...

LEARN ABOUT HPUX

vxdmp

vxdmp(7)						 Miscellaneous Information Manual						  vxdmp(7)

NAME

       vxdmp - Veritas Volume Manager multipathing disk devices

DESCRIPTION

       Multipathed  disk  devices  in Veritas Volume Manager (VxVM) represent virtual devices with one or more physical access paths to a physical
       disk.  The Multipathing feature provides disk access reliability by dynamically switching to another physical path if there is a path fail-
       ure.

       Every disk that is visible to VxVM is represented by a multipath device node in the /dev/vx/dmp and /dev/vx/rdmp directories for block type
       and character type interfaces.  A simple disk is represented by a multipath device having one physical path, whereas a disk that is part of
       a multiported disk array is represented by a multipath device with many device access paths depending upon the type of the disk array.

       VxVM  uses  standard  disk  device  naming conventions to name multipath devices.  For example, if there is a disk device with two physical
       access paths such as c1t0d0 and c2t0d0, the multipathing device node for this particular disk is created under /dev/vx/dmp and /dev/vx/rdmp
       as c1t0d0 or c2t0d0.

       To  provide  multipathing,  VxVM  maintains an internal database of all the multipathed devices detected by the system and their respective
       paths.  The database is created at system boot time.  When disks are added or removed from the system, VxVM provides support to reconfigure
       the multipath device database to reflect new states of the hardware, while the system is online.

       To reconfigure the DMP database, run ioscan followed by insf, and then invoke vxdctl enable (see vxdctl(1M)).

       The  various  access  paths to a multipathed device can be seen by using a vxdisk command (see vxdisk(1M)).  These commands open the multi-
       pathing configuration device /dev/vx/dmpconfig to obtain the required information about the various paths to a multipathed device and their
       states.

       VxVM also provides the facility to enable or disable a disk controller. This feature can be used to stop all I/Os through a particular con-
       troller to perform maintenance operations on it.  Use the vxdmpadm command to do this and also perform other operations	on  the  multipath
       device database.

       VxVM  can  provide notification about events that occur in the DMP database due to a change in hardware.  See the vxnotify(1M) man page for
       more information.

       VxVM is capable of multipathing both Active/Active and Active/Passive disk arrays.

FILES

       /dev/vx/dmp		     Multipathing block devices.

       /dev/vx/rdmp		     Multipathing character devices.

SEE ALSO

       ioctl(2), vxdctl(1M), vxdisk(1M), vxdmpadm(1M), vxnotify(1M)

VxVM 5.0.31.1							    24 Mar 2008 							  vxdmp(7)