Re: NetApp SAN - monitoring aggregate free space

Yeah ... the UNIX admin and the Storage admin are one and the same.
In this environment the DBAs currently are barred access to the storage tools.  I would definitely like to have access, but then I could also see how everything has been configured, or misconfigured, as the case may be ....

The UNIX/Storage admin seems content to let this fail and then fix it, which is a drag.

So yes, I am hoping for a technical solution to what is really a "human factors" problem.

Niall Litchfield <niall.litchfield_at_gmail.com> wrote:

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