1748140 Members
3660 Online
108758 Solutions
New Discussion юеВ

RAW files for database

 
Galal
Advisor

RAW files for database

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
7 REPLIES 7
Hasan  Atasoy
Honored Contributor

Re: RAW files for database

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.
Hasan  Atasoy
Honored Contributor

Re: RAW files for database

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.
Galal
Advisor

Re: RAW files for database

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

Re: RAW files for database

hi galal ;

vgdisplay vgora

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


Hasan.
Galal
Advisor

Re: RAW files for database

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

Re: RAW files for database

exactly :)

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

Re: RAW files for database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)