Extending a oracle File system running out of space

[Sakui]

hi

I have a rx 2620 with hpux 11.23 installed and connected to a MSA 30 with smart array card.Oracle 10g is presently installed on it But the oracle file system is running out of space. Can i create a new logical volume and extend the volume group of the oracle file system. I hope it will not adversely affect the oracle database. Can i also use lvextend the extend the oracle file system that is running out of disk space.

[Ivan Krastev]

Yes, it is simple, but for doing it online you need OnlineJFS installed:

1. Add new disk(s) to VG - vgextend VG
2. lvextend logical volume
3. increase file system size

For example:

1. vgextend /dev/vg_ora1 /dev/dsk/c1d1t2 ....

2. lvexend -L 10000M /dev/vg_ora1/lvol1 (this will increase logical volume up to 10GB).

3. fsadm -F vxfs -b 10000M /oracle/.... (mount point of /dev/vg_ora1/lvol1)

regards,
ivan

[Steven E. Protter]

Shalom,

Item three of the very good recommendations above requires Online JFS be installed. This product, a pay for add in will let you extend a filesystem without umounting it.

Otherwise stop oracle production, umount the filesystem and use extendfs to extend the filesystem.

SEP

[TwoProc]

Well, I guess it depends on what you're doing.

Are you running the "Oracle File System" ? Or, were you generically talking about the HPUX file system that happens to have Oracle on it?

If you're using the "Oracle File System" then, to HPUX, they are just raw data volumes. This means that you could just add more disk to the volume group, and then just add the disk to the logical volume of the raw volume that's holding the "Oracle File System", as it were. Then, extend your "Oracle File System" over this new raw disk.

Or, if this is an HPUX file system which is just holding the Oracle data files, (and you know its just using raw logical volumes even without "Oracle File System") - AND you know you don't have Online JFS - then your solution would be to use the new disk as new logical volumes, and then just create new files for the tablespace that's filling up, and put the new files in the new HPUX file system on the logical volume that you created from the new hard disks.

In any case, you really don't need to add more space to the same logical volume (though it's nice when you can with Online JFS) - you can just make the new disk on a new logical volume, and add your new files for your Oracle tablespace there.

Likewise if you're using raw volumes for Oracle space, then just add the new lv as raw volume space for the tablespace that's filling up.

Anyways, this is something you can easily handle, and you don't absolutely have to have Online JFS for all approaches, though it would be nicer.

As they say, lots of ways to skin that cat.

[Nuwan Alwis]

Hi Sakui,
I totally Agree with MR. TwoProc, and this is the whole point of maintaining vol groups. Guss your oradata on MSA. If your oradata file is on your local disk and free disk space is available. you can do a ignite restore with partition modification. But this takes time and effort. If that your requirement is i maybe able to help you further.