Why bother migrating to ASM ?
Q1. What would be the benefits of migrating from a SAN based, file system storage for Databases to ASM ? What would outweigh the effort in doing this - i.e. why bother ?
I know Oracle literature gives some benefits but they all look rather weak to me when trying to justify the effort in migrating ( and subsequent effort in changing the backup and standby solution ) -
- Performance Optimization ( any better than well tuned SAN/RAID ? )
- Redundancy Protection ( any better than RAID ? )
- No need for 3rd party LVM’s ( most OS / hardware vendors supply some sort of free LVM anyway )
- It provides shared storage for RAC - actually is it not Grid Infrastructure which does this by supplying the ACFS file system, as opposed to ASM itself ( besides all your basically needing is some sort of shared / clustered storage eg NFS/dNFS or is the likes of OCFS2, GFS etc not free anyway ? )