Simpler Navigation for Servers and Operating Systems
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.
Showing results for 
Search instead for 
Did you mean: 

add raw device for oracle 10g r2

Occasional Visitor

add raw device for oracle 10g r2

Hi,we have a problem,a tablesapce has not enough spaces.I want to add a datafile,but the tablespace be created on raw device.
How to add a datafile for oralce on raw device?
HP-UX 11i V3 ia 64
MC/cluster service guard

VG info:
--- Volume groups ---
VG Name /dev/VG_QDB_ORA02
VG Write Access read/write
VG Status available, exclusive
Max LV 511
Cur LV 61
Open LV 61
Max PV 511
Cur PV 1
Act PV 1
Max PE per PV 65536
PE Size (Mbytes) 32
Total PE 31999
Alloc PE 31504
Free PE 495
Total PVG 0
Total Spare PVs 0
Total Spare PVs in use 0
VG Version 2.0
VG Max Size 2t
VG Max Extents 65536

SIZE: 31504*32/1024=984.5GB

select sum(bytes/1024/1024/1024) as datafile_GB
from v$datafile
where name like '/dev/VG_QDB_ORA02/%'

SIZE: 881.5234375GB
Valued Contributor

Re: add raw device for oracle 10g r2

At a high level and with no consideration to SG and other cluster constraints:

8GB addition...
lvcreate -L 8192M -n lv_new VG_QDB_ORA02
chown oracle: /dev/VG_QDB_ORA02/rlv_new

... then in oracle ...

alter tablespace add datafile
'/dev/VG_QDB_ORA02/rlv_new' size 8192M;
-- may need to decrease the size here by 4k or so.

Have a look at your current datafiles and duplicate what you see there in terms of naming and placement ( Oracle may be using links to the raw device file ):

select file_name from dba_data_files;