LUN and RAID

[VIRENDER SINGH_1]

Hi,

Platform: HP-UX 11i and oracle 10g(10.2.0.1)both with RAC.

I am working as Oracle dba and want to create hold on OS also.My database is created on RAW devices (SAN storage is used).Please tell me what are LUN and how can we check which RAID that we are using ?

I have hold on RAC enviornment but i am a bit confused so please support me to know all about this system.

Thanks.

[Yogeeraj_1]

hi,

First thing you can do to check the current disk utilisation by Oracle is to connect to the database as the dba and execute the SQL statement:

SQL> Alter database backup controlfile to trace;


This will generate a trace file containing all the datafiles used. (NB. file will be found int the udump directory. To get the exact location, please use:
e.g.
SQL> show parameter user_dump_dest

user_dump_dest string /d01/app/oracle/admin/mydb/udump
)

With this list in your hands, you can further drill-down into your configuration.


hope this helps!

kind regards
yogeeraj

[Yogeeraj_1]

hi,

First thing you can do to check the current disk utilisation by Oracle is to connect to the database as the dba and execute the SQL statement:

SQL> Alter database backup controlfile to trace;


This will generate a trace file containing all the datafiles used. (NB. file will be found in the udump directory. To get the exact location, please use:
e.g.
SQL> show parameter user_dump_dest

user_dump_dest string /d01/app/oracle/admin/mydb/udump
)

With this list in your hands, you can further drill-down into your configuration.


hope this helps!

kind regards
yogeeraj

[Trevor Roddam_1]

Hello.

Not sure if I'm on the right track, but if you're looking for what RAID type is being used then you will need to identify which hardware path is being used by Oracle.

That RAW disk space could be managed by LVM or not.

With the HW path you can identify which LUN is being used. With the LUN you can look on the SAN storage device and see what RAID is being used.

Please read the following to identify which LUN is in use.
http://docs.hp.com/en/A6795-90007/ch01s09.html

This is the admin guide for LVM.
http://www.docs.hp.com/en/5991-6481/index.html

Trevor.