Re: NetApp SAN - monitoring aggregate free space

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 26 Jul 2011 21:44:19 +0100
Message-ID: <CABe10sbDSwTu7n+9LwNj=QVKRpVUXB+m_uQAT5sU36MDpdZAzw_at_mail.gmail.com>

In your situation you can *only* get a true view of things, including snapshot reserve space and all the rest of it by using the netapp storage level tools. smo doesn't give you that info. Time to either make good friends with the storage guys or become a DBA 2.0 (in the original sense) and bring netapp storage into your realm and skillset. Good luck with either. Incidentally your Unix admins likely *also* can't see the true picture unless they are the storage admin as well.

On Tue, Jul 26, 2011 at 9:34 PM, Lou Avrami <avramil_at_concentric.net> wrote:

> Hello oracle-l,
>
> We have an Oracle 11.2.0.2 RAC on a 2-node Solaris 10 cluster on a NetApp
> FAS6080. This database is somewhat large, approximately 18 TB. We are
> using NetApp Snap Manager 3.1 for online database backups.
>
> We've had two incidents now where the SAN Aggregate for the archive
> destination has "filled up", despite the fact that the ASM disk group is
> only at 50% of capacity.
>
> Does anyone know of a command-line utility that could give us information
> on the status and free space of the aggregate? Our UNIX/Storage admin is
> "working on the problem" ... but our wait for a fix or a correction to the
> configuration could be quite long. We don't have access to the NetApp tools
> that are used to configure and monitor the SAN. I was hoping that there
> might be something that could be run that could at least give us a warning
> when space was becoming an issue at the aggregate level.
>
> I've tried
>
> $ sanlun lun show -p -v all
>
> and that displays a lot of info, but there appears to be no options with
> sanlun that have details on aggregate space.
>
> I did come across this webpage:
>
> http://www.datadisk.co.uk/html_docs/netapp/netapp_disk.htm
> http://www.datadisk.co.uk/html_docs/netapp/netapp_cs.htm
>
> Both mention the "aggr" command:
>
> aggr status
> aggr status -r
> aggr status <aggregate> [-v]
>
> but I can't locate aggr on our Solaris servers.
>
> If anyone has any suggestions, they would be most welcome.
> Thanks,
> Lou Avrami
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 26 2011 - 15:44:19 CDT