Talk:Oracle database FAQ

From Oracle FAQ
Jump to: navigation, search

a good way to eliminate usage of meta devices is to add data files via SQL. For example, typically the hardware RAID is already there on the storage side, most of the times what we need is to add space to the database and people tend to use a software RAID to concat the same. MySQL used to have this via innodb and oracle has this for ages. so it is easier to simply ad a new lun, give the lun to the end DBA and add a datafile to a tablespace pointing to the new LUN mount point. This is easier than ASM etc

And when you want to resize? Ask the DBA to give back part of the disk? When the project wants to spend less money on storage and give back part of the disk space?
When you want to add disk and rebalance the io across the LUN?
How do you do it?
With ASM you just have to add or drop the "disk" (LUN) to/from the diskgroup and all is done, rebalancing included.
Michel Cadot 15:15, 20 July 2011 (UTC)