Re: ASM on top of SLVM - HPUX - DW
- From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- To: John.Hallas@xxxxxxxxxxxxxxxxxx
- Date: Wed, 5 Nov 2008 06:44:52 -0600
You dont need asmcmd to see disk usage. The usage is available within any
Oracle database using the ASM instance:
select group_number, name, state,
total_mb, free_mb,
round(free_mb / total_mb * 100) "Free%"
from v$asm_diskgroup
order by 1, 2;
I cant think of anything you would gain by using the HP tool.
On Wed, Nov 5, 2008 at 6:35 AM, <John.Hallas@xxxxxxxxxxxxxxxxxx> wrote:
>
>
>
> Environment HPUX 11:31 Oracle 11.1.0.6 ASM HP Superdome XP Array Storage
> Application - Data warehouse ~15TB
>
> We are being advised by 3rd party consultants to install HP SLVM (shared
> volume manager) to present the disks to ASM and use ASM for disk
> management.
>
> The advantages are supposed to be
>
> 1) If we ever go to a clustered system/database then having SLVM will be an
> essential building block in building Service Guard
>
> 2) It allows the Unix team to 'see' disk usage without using asmcmd
>
>
> I see 1) as an irrelevancy as if we do go to SG (highly unlikely as there
> is no business requirement) then we would use RAC as well and therefore
> that would be time to re-design the application and disk layout anyway.
>
> 2) has some merit but I am worried about supportability from Oracle if we
> have any disk issues.
>
> Does anybody know of a similar setup or have any thoughts on the matter
>
> Thanks
>
> John
>
>
>
>
> ==========================================================================================================================
>
> Wm Morrison Supermarkets PLC is registered in England with number 358949.
> The registered office of the company is situated
> at Gain Lane, Bradford, West Yorkshire BD3 7DL.
>
> This email and any attachments are intended for the addressee(s) only and
> may be confidential. If you are not the
> intended recipient, please inform the sender by replying to the email that
> you have received in error and then destroy
> the email. If you are not the intended recipient, you must not use,
> disclose, copy or rely on the email or its attachments
> in any way.
>
> Wm Morrison Supermarkets PLC accepts no liability or responsibility for
> anything said in the email or its
> attachments and gives no warranty as to accuracy. It is the policy of Wm
> Morrison Supermarkets PLC not to enter
> into any contractual or other obligations by email.
>
> Although we have taken steps to ensure the email and its attachments are
> virus-free, we cannot guarantee this or
> accept any responsibility, and it is the responsibility of recipients to
> carry out their own virus checks.
>
>
> ==========================================================================================================================
>
> ______________________________________________________________________
> Wm Morrison Supermarkets Plc is registered in England with number 358949.
> The registered office of the company is situated at Gain Lane, Bradford,
> West Yorkshire BD3 7DL. This email and any attachments are intended for the
> addressee(s) only and may be confidential.
>
> If you are not the intended recipient, please inform the sender by replying
> to the email that you have received in error and then destroy the email.
> If you are not the intended recipient, you must not use, disclose, copy or
> rely on the email or its attachments in any way.
>
> Wm Morrison Supermarkets PLC accepts no liability or responsibility for
> anything said in the email or its attachments and gives no warranty as to
> accuracy. It is the policy of Wm Morrison Supermarkets PLC not to enter into
> any contractual or other obligations by email.
>
> Although we have taken steps to ensure the email and its attachments are
> virus-free, we cannot guarantee this or accept any responsibility,
> and it is the responsibility of recipients to carry out their own virus
> checks.
> ______________________________________________________________________
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
