Creating additional LV's online

[musaddaq_2]

My query:
We have Oracle 9i RAC on HP-UX (11i) on 2 database server with EVA disk array clustered with M/c service guard.
3 shared VG's are created initially and all datafiles are residing on these 3 vg's in its respective LV's.

Now if we want to add datafile for any tablespace (Online)
what will be the procedure ?

At present we are assigning the raw volume which is been created initially as a dummy raw volume by our implementers to add any additional datafile .
Now we are about to finish all the dummy raw volumes assigned during last one year for various tablespaces.
We would like to now with above setup what will be the steps to be carried out for

1. Creating New LV's and assigning it to any datafile online (i.e.without database shutdown)

2.How to rename the LV's as we have assigned many dummy LV's for various tablespaces.(Dummy LV's are not having proper naming).

[Steven E. Protter]

Shalom,

If this is a LVM question, and I'm not exactly certain, here is how I handle it.

1.
lvcreate the new LV (lvcreate -C y -n name /dev/vg##)
lvextend the new LV (lvextend -L 2048 name of lv)

chown the new lv to oracle user in /dev/vg##

2. You can rename the lv's using the mv command.

cd /dev/vg## (use a real vg)

each lv will have two files one starts with an r

exmaple

roradata
oradata

mv roradata roradatanew
mv oradata oradatanew

SEP

[Geoff Wild]

For SG - all you do is add to running node, update the control script with the new lvols to mount/umount, copy control script to rest of nodes in cluster, vgexport a new map file of vg, vgexport vg on other nodes and vgimport using new map file...

Full steps here:

http://docs.hp.com/en/T1859-90017/ch03s02.html#cegbaeff

Rgds...Geoff