topic Re: Oracle raw device in Operating System - HP-UX

Oracle raw device

Kumaresh P N — Tue, 20 Dec 2005 20:06:00 GMT

1)How to identify the disks used for oracle ( as raw device ) ?
2) whether it be displayed in bdf ?

Re: Oracle raw device

Raj D. — Tue, 20 Dec 2005 20:18:14 GMT

Hi Kumaresh ,

If you know the lvol name that is using by oracle certainly you can come to which one it is .

And hope you cannot see from bdf output and need to use sql commands.

for raw deice it will be using /dev/rdsk/ or /dev/vgname/rlvol ,

you can use like this , to get list :
SQL> select group_number, disk_number, mount_status, header_status, state, path, failgroup
2 from v$asm_disk;

Cheers,
Raj.

Re: Oracle raw device

Indira Aramandla — Tue, 20 Dec 2005 20:43:48 GMT

Hi Kumaresh,

You will require to query form the database dictionary using SQL to see the datafile name and from there you can see the volume group where the oracle data files are defined.

Data file names details can be fetched from the the views DBA_DATA_FILES, v$datafile as well.

Then you can use vgdisplay for that volume group to see the disks on which the voulme group was defined.

the raw devices would look like /dev/rdsk/....
or /dev/vg0?/rvol?... as Raj mentioned above.

Indira A

Re: Oracle raw device

Doug O'Leary — Tue, 20 Dec 2005 20:55:37 GMT

Hey;

As the others have told you, bdf won't tell you about Oracle raw devices because they're not filesystems. My normal way of identifying this information is as follows:

1. su - oracle
2. sqplus/nolog << eof
connect 1/2 as sysdba
column file_name format a45
column member format a45
spool /tmp/dba_files.txt
select file_name from dba_data files
order by file_name;
select member from v$logfile
eof

That will get you all of the potential raw devices that Oracle could be using. Please realize that there are other things that Oracle needs to run - binaries, control files, archive log filesystems if used, etc..

HTH;

Doug
order by member

Re: Oracle raw device

Yogeeraj_1 — Wed, 21 Dec 2005 00:11:12 GMT

hi,

you can also connect as sysdba and generate a trace file with all the required information.

alter database backup controlfile to trace;

hope this helps too!

kind regards
yogeeraj