- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- add raw device for oracle 10g r2
Operating System - HP-UX
1753971
Members
8869
Online
108811
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-19-2011 09:32 PM
05-19-2011 09:32 PM
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?
THX!!!
software:
HP-UX 11i V3 ia 64
ORACLE 10.2.0.4.0
MC/cluster service guard
PS:
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
VGDA 2
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
DATAFILE info:
select sum(bytes/1024/1024/1024) as datafile_GB
from v$datafile
where name like '/dev/VG_QDB_ORA02/%'
SIZE: 881.5234375GB
How to add a datafile for oralce on raw device?
THX!!!
software:
HP-UX 11i V3 ia 64
ORACLE 10.2.0.4.0
MC/cluster service guard
PS:
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
VGDA 2
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
DATAFILE info:
select sum(bytes/1024/1024/1024) as datafile_GB
from v$datafile
where name like '/dev/VG_QDB_ORA02/%'
SIZE: 881.5234375GB
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-20-2011 07:23 AM
05-20-2011 07:23 AM
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;
Hth,
-klb
8GB addition...
lvcreate -L 8192M -n lv_new VG_QDB_ORA02
chown oracle:
... then in oracle ...
alter tablespace
'/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;
Hth,
-klb
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP