Operating System - HP-UX
1748226 Members
4563 Online
108759 Solutions
New Discussion юеВ

Re: Choosing the volume manager for Oracle database

 
Bachur
Occasional Advisor

Choosing the volume manager for Oracle database

Hi,

I need to decide which Volume manager is better for Oracle database.

VxVM or LVM?

Regards,
Bachur

10 REPLIES 10
inventsekar_1
Respected Contributor

Re: Choosing the volume manager for Oracle database

refer this thread for VxVM or LVM comparison:

http://forums1.itrc.hp.com/service/forums/bizsupport/questionanswer.do?threadId=147857
Be Tomorrow, Today.
inventsekar_1
Respected Contributor

Re: Choosing the volume manager for Oracle database

this i copied from that thread:

There are some features in VxVM that are not available from LVM that should be the points for consideration when you decide to move. This is from some text that I saved up early this year. I particularly liked the DMP feature in VxVM that allows you to do load balancing (this feature has to be purchased separately) that LVM does not provide.
- A JAVA-based administrative GUI. The Storage Administrator can run either as a system application or from a web browser.
- Provides simple, goal-based storage allocation.
- Tracks progress of system recovery operations by monitoring task creation, maintenance, and completion. The Task Monitor allows you to pause, resume, and stop as desired to adjust the impact on system performance.
- Dynamic Multipathing (DMP) for Active/Active Devices. Provides high availability to data on disks with multiple host-to-device pathways by providing a disk/device path failover mechanism and by providing load balancing. (LVM supports path failover but does not support I/O balancing.)
- Multiple mirroring allows up to 32 mirror copies of a volume.
- Mirrored stripes (RAID-1 + RAID-0) and striped mirrors (RAID-0 + RAID-1).VxVM both support the combination of mirroring and striping.
- The hot relocation process, vxrelocd(1M), automatically moves failed subdisks to available disk space within the same disk group. This allows a system to react automatically to I/O failures on redundant (mirrored or RAID-5) VxVM objects, restoring redundancy and access to those objects without administrative intervention.
- Online Data Migration allows storage regions on physical media to be dynamically moved to other physical devices.
- Online Relayout allows you to change logical data configuration while online; for example, you can change a RAID-5 layout to a mirrored layout if you have enough disk space. The volume data remains available during the relayout operation.
Be Tomorrow, Today.
Steven E. Protter
Exalted Contributor

Re: Choosing the volume manager for Oracle database

Shalom Bachur,

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1033544

It doesn't matter. I like LVM merely because I know it.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Srikanth Arunachalam
Trusted Contributor

Re: Choosing the volume manager for Oracle database

Hi Bachur,

This was the hot discussion even we had yesterday. I will go for VxVM, the reason is as below.

(1) VxVM is better performing in terms of performance and mirroring. Please refer to the following thread raised by me and answered well by Nelson.
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1027529&admit=-682735245+1149841005182+28353475

(2) VxVM is supportive on any platform, that we can safely migrate the configuration at any latter stage, provided you have the volume, plexes and sub-disk been scripted.





Thomas J. Harrold
Trusted Contributor

Re: Choosing the volume manager for Oracle database

I prefer LVM solutions, due to the simple fact that it is not nearly as complex as VXVM.

Keep it simple. If your storage is sized approprately, and if you are using the proper *hardware* raid protection for your critical data, then you won't see any performance benefit from vxvm. Nor will you need any of the more advanced vxvm features.

-tjh
I learn something new everyday. (usually because I break something new everyday)
Zinky
Honored Contributor

Re: Choosing the volume manager for Oracle database

If you do not want vendor lock-in in your storage management processes and infrastructure - VxVM.

If you want your DBAs to effectively manage Storage themselves - choose VxVM.

If you want Oracle to have a much more closer affinity with the storage subsystem - choose LVM.

If you believe the future of IT infrastructure is the OS/hardware will not matter - choose VxVM.

If you want your storage management processes to be uniform accross platforms and storage arrays - choose VxVM.

If you want your backup/restore processes to remain unchanged EVEN if you change your SAN/Storage/Disk array infrastructure - choose VxVM.

If you want the ability to build better performing storage volumes AND have the ability to tweak those storage volumes online - choose VxVM.

If you are an Admin who wants to stay in the business and survive the upcoming norm that you need to know more and have the ability to do more with less - choose VxVM.

If you believe HP's direction to dump the Compaq/Tru64 features and instead adopt Veritas technologies in the OS and its seamless integration with HP-UX 11i since 2002 - choose VxVM.


The final decision is yours though based on your current and future requirements. Plus of course that "it depends" rationale.


Hope this helps.

;^)
Hakuna Matata

Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
Zinky
Honored Contributor

Re: Choosing the volume manager for Oracle database

Correction:

If you want Oracle to have a much more closer affinity with the storage subsystem - choose VxVM (via ODM baby - oracle disk manager or whatever it is called nowadays...)
Hakuna Matata

Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
Srikanth Arunachalam
Trusted Contributor

Re: Choosing the volume manager for Oracle database

Hi Nelson,

You were speaking about ODM. I believe this will be more suitable for the Oracle RAC installation. Is it possible for non-oracle installations as well.

Thanks,
Srikanth
Srikanth Arunachalam
Trusted Contributor

Re: Choosing the volume manager for Oracle database

Hi Nelson,

You were speaking about ODM. I believe this will be more suitable for the Oracle RAC installation. Is it possible for non-RAC database installations as well.

Thanks,
Srikanth