RE: Large ASM installation

  • From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
  • To: "'daniel.fink@xxxxxxxxxxxxxx'" <daniel.fink@xxxxxxxxxxxxxx>, 'oracle-l' <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 22 Oct 2010 11:40:50 -0400

Hi Daniel,

I have had several rac datawarehouses on asm (single asm instance) in the multi 
terabyte range (20 tb up to 90tb).

Pros - easy to manage from a dba perspective (I did the installation myself - 
OS, cluster, ASM, db so for me it was a snap)
     - good performance
     - easy to use multiple arrays on the same asm instance (my 90tb one was 
spread over 2 arrays - an xp10k and XIV for instance - different speeds of the 
arrays would need to be taken into account for the physical db design of course)

Cons - need to be aware of the 2 tb limit on individual luns
     - extra steps needed to taken on maintaining the luns (ie, take backups of 
the asm metadata regularly)
     - ideally on larger instances having a dedicated array to the asm is best 
(we had the large on go belly up because the san array was on a shared 
infrastructure and work being done for other systems had an impact on those 
luns - ie, some disk maintenance zeroed out the asm header on our luns even 
though that was not the system being worked on - or so oracle support told us).

Would I use it again? Yes, since the performance and ease of use outweighed the 
cons for our situation. Besides, knowing the cons it would be easier to add 
processes to make sure we would be covered.

HTH

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Daniel W. Fink
Sent: Friday, October 22, 2010 10:10 AM
To: oracle-l
Subject: Large ASM installation

We have a customer that is looking at ASM to handle their databases, the 
total planned is about 8TB for a single ASM instance. Has anyone on the 
list worked on a large (5+TB) ASM system? What have been the pros and 
cons versus a regular LVM and storage? If you had the chance to go back 
to the decision time, would you make the same decision and why?

I'm not needing nitty gritty details right now, more of a high level 
decision making view.

Regards,
Daniel Fink
--
//www.freelists.org/webpage/oracle-l



NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, go to www.td.com/legal for 
instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, allez 
au www.td.com/francais/avis_juridique pour des instructions.
--
//www.freelists.org/webpage/oracle-l


Other related posts: