NetApp SAN - monitoring aggregate free space

From: Lou Avrami <avramil_at_concentric.net>
Date: Tue, 26 Jul 2011 16:34:07 -0400 (EDT)
Message-Id: <20110726203407.63387531_at_courageux.cnc.net>



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
Received on Tue Jul 26 2011 - 15:34:07 CDT

Original text of this message