I hope there are other DBAs that have experience with Oracle ASM disk groups on NetApp storage. I administer a couple of 11gR2 RAC clusters on IBM pSeries servers running AIX 6.1. We have configured various ASM diskgroups for data, fra, redo and archive logs. Currently my cluster hosts one (1) database, and I am being asked to create a second database on the same cluster.
My question is: should I create separate diskgroups for the new database? Or is it fine to simply add additional storage to the existing diskgroups?
Assistance and advice from anyone in the forum that has experience with NetApp and SnapManager backups will be greatly appreciated. I have reviewed the NetApp/Oracle Best Practices document provided by NetApp support, but it does not seem to address my question.
Thanks in advance for any and all advice.
I you are going to use snapmanager for oracle to take backup you have to create separate diskgroups (if I remember correctly best practice 6 diskgroups per database [data,fra,temp,ctrl,redo,arch]). I suggest you to use direct NFS (in relation to netapp) instead of ASM if it's possible. snapmanager for oracle didn't work for us, we are back on rman. snapcreator should be nice, but we didn't test it so far.
Thank you for the information. Unfortunately, since we are using 11gR2 clusterware ASM is mandatory. I appreciate the advice about different diskgroups. Our planned configuration is similar to what you suggest, except we have placed control files in data and fra since we back up both those volumes. The others are ignored by the backup, for obvious reasons. Thank you.