Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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)