topic Re: RAW files for database in Operating System - HP-UX

RAW files for database

Galal — Sun, 02 Dec 2007 18:33:42 GMT

hp-ux problem
Please I want to create the following raw files to be added into database.
We are at 80% mark for the some of our tablespaces, this issue must be addressed quickly otherwise it may stop the application

/dev/vgora/rmosa_raw_ac_i_2_2gb size=2048 MB
/dev/vgora/rmosa_raw_sa_2_3gb size= 3072MB

Re: RAW files for database

Hasan Atasoy — Sun, 02 Dec 2007 19:23:46 GMT

hi;

lvcreate -n rmosa_raw_ac_i_2_2gb -L 2048 vgora
lvcreate -n rmosa_raw_ac_i_2_3gb -L 3072 vgora

chown oracle:dba /dev/vgora/rmosa_raw_ac_i_2_2gb

chown oracle:dba /dev/vgora/rmosa_raw_ac_i_2_3gb

assuming there is enough space ( 5GB ) in vgora
Hasan.

Re: RAW files for database

Hasan Atasoy — Sun, 02 Dec 2007 19:30:16 GMT

ignore previous one ..

lvcreate -n mosa_raw_ac_i_2_2gb -L 2048 vgora
lvcreate -n mosa_raw_ac_i_2_3gb -L 3072 vgora

chown oracle:dba /dev/vgora/rmosa_raw_ac_i_2_2gb

chown oracle:dba /dev/vgora/rmosa_raw_ac_i_2_3gb

assuming there is enough space ( 5GB ) in vgora
Hasan.

Re: RAW files for database

Galal — Sun, 02 Dec 2007 19:35:58 GMT

how I can know there is 5GB?
and if there is not enough space (<5GB)

Re: RAW files for database

Hasan Atasoy — Sun, 02 Dec 2007 19:37:22 GMT

hi galal ;

vgdisplay vgora

(pe size) * ( freep pe) = free space in mb.

Hasan.

Re: RAW files for database

Galal — Sun, 02 Dec 2007 19:47:56 GMT

if there is not free space!!!!
what i can do for this?
maybe I need another disks!!!!

Re: RAW files for database

Hasan Atasoy — Sun, 02 Dec 2007 19:50:42 GMT

exactly :)

assign a disk from strage.
pvcreate on the new disk
vgextend volume group by this disk.
and previous steps.
also assign points :)
Hasan

Re: RAW files for database

Yogeeraj_1 — Mon, 03 Dec 2007 08:48:56 GMT

hi,

Which version of Oracle are you using?

If the need for additional disk space is immediate, you may wish to use file sizes which are smaller?

If you calculate the tablespace growth-rate, you will know when you will be running our of space and which tablespace requires more space...

Also, it is recommended to use Locally managed tablespace with Uniform extent sizes.

hope this helps too!
kind regards
yogeeraj