Oracle raw device

[Kumaresh P N]

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

[Raj D.]

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.

[Indira Aramandla]

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

[Doug O'Leary]

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

[Yogeeraj_1]

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