- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- how to manage raw volume ???
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
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
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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-10-2004 09:02 AM
тАО05-10-2004 09:02 AM
how to manage raw volume ???
Running HP-UX with Oracle. Some Database are on RAW LV.
How i can manage RAW LV ? (ex : show how space are used on raw device...)
i can do an lvdisplay but that don't give me space used... :
LV Name /dev/vgoracle/lvora1
VG Name /dev/vgoracle
LV Permission read/write
LV Status available/syncd
Mirror copies 0
Consistency Recovery MWC
Schedule parallel
LV Size (Mbytes) 300000
Current LE 9375
Allocated PE 9375
Stripes 0
Stripe Size (Kbytes) 0
Bad block on
Allocation strict
IO Timeout (Seconds) default
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 09:06 AM
тАО05-10-2004 09:06 AM
Re: how to manage raw volume ???
I would look for usage within Oracle management tools. I do not think it is possible to view using a UNIX command, May be a backup tool?
HTH,
Gideon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 09:08 AM
тАО05-10-2004 09:08 AM
Re: how to manage raw volume ???
VERY VERY CAREFULLY!!!!
There is no way that I know of for you to see the space used on a raw LV at the unix level. That's what oracle tools are for.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 09:11 AM
тАО05-10-2004 09:11 AM
Re: how to manage raw volume ???
You can start by doing a "select * from dba_data_files". The "bytes" column will indicate the total size of the tablespace which must be be less than or equal to the LV Size returned by lvdisplay.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 09:13 AM
тАО05-10-2004 09:13 AM
Re: how to manage raw volume ???
Make sure the oracle user owns the special device files.
All other management of this raw space must be done with sqlplus or tools provided by oracle.
I manage Software AG databases raw.
All I can do in the OS is create the logical volumes, change the ownership and then start using the SAG tools.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 09:52 AM
тАО05-10-2004 09:52 AM
Re: how to manage raw volume ???
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 10:38 AM
тАО05-10-2004 10:38 AM
Re: how to manage raw volume ???
db_studio is a nice graphical Oracle tool.
You need to have an oracle login (diffenrent to the Unix login).
the set your enviroment correctly (su - oracle) does this normaly.
... and try "oemapp dba_studio".
If it is installed on that Unix box you'll get a GUI where you have to connect to the required instance and then you should look under Storage / Datafiles ......
But from pure SYSTEM Admin view I guess you dont need care about that. DBAs should :-)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 11:01 AM
тАО05-10-2004 11:01 AM
Re: how to manage raw volume ???
- Carefull naming
- Carefull sizing
- Carefull ownership settings
Clay wrote: "You can start by doing a "select * from dba_data_files". "
Right. But is only a start.Besides datafile Oracle also has temp files, redo logs, control files.
Here is a procedure I use. You would need to run it once for every instance you manage.
column status format a8
column member format a55
column file_name format a45
column Tablespace format a15
column segment_name format a15
column extent_name format a15
column owner format a10
column file format a45
column id format 99
set pages 9999
set heading off
set FEEDBACK off
select 'redo_'||l.group# "Tablespace", l.group# "Id", l.bytes/(1024*1024) "MB",
MEMBER "File" from v$logfile f, v$log l where l.group# = f.group#
union
select tablespace_name "Tablespace", FILE_ID "Id", bytes/(1024*1024) "MB",
file_name "File" from dba_data_files
union
select tablespace_name "Tablespace", FILE_ID "Id", bytes/(1024*1024) "MB",
file_name "File" from dba_temp_files
union
select 'Control_file' "Tablespace", rownum "Id", 0 "MB",
name "File" from v$controlfile
order by 1
/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2004 02:23 PM
тАО05-10-2004 02:23 PM
Re: how to manage raw volume ???
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2004 01:02 AM
тАО05-11-2004 01:02 AM
Re: how to manage raw volume ???
By the way :
I have found Oracle doc about using RAW volume with oracle. But not exactly for HP-UX... Here what i have made on the server :
1. Give ownership to oracle user on the raw disk (/dev/vgoracle/rlvora1)
2. chmod 600 on the raw disk
3. Using ln -sf to create symbolic file (.dbf that point on the raw disk)
4. Used Enteprise manager to create new tablespace that point on .dbf (with reuse option)
Somebody can tell me if this procedure are OK ? If optimisatioon configuration or tool exist for RAW volume...
thanks