Milazzo,
Thanks for the information. At this point it looks like they are going to be happy with the performance of the NFS mount. They can definitely do the scripting for the backups, but it sounds like we'll still need to get a snap restore license for them.
Jeff
On Wed, May 28, 2014 at 6:56 AM, Milazzo Giacomo G.Milazzo@sinergy.itwrote:
I’ve read each single row J. Very interesting discussion.
Where’s the problem? FCP and a lot of SSD! That’s all folk as stated in Looney Toons! J
Jokes aside my two cents come bringing one of the biggest success story of a customer of our (a big petroleum company here)
They’re “playing” with Oracle on NFS since the FAS270 time! And overall winning a battle against Oracle representative too and “old fashioned dbadmin”…
FAS and Ontap 7 mode (now 8.1)
Their infrastructure is all virtualized on VMware platform (NFS for the datastore too), using now a core network at 10 GbE with LACP (but they started coupling single 1 Gbps links with the ip aliasing technique on filers to allow several mp on different links) and all the db server run on Linux RH as VM with vdisk for binaries and exports from NetApp for their RAC or standalone functions: always on NFS exports. Their SAP frame runs on Oracle too, same architecture. They use DirectNFS sometimes but the most of link are on NFS.
For which concern backup and dr everything is managed by Workflow and OnCommand Core (aka DFM) and its Console (all scripts integrated with RMAN, no SMO/SMSAP at all) and SnapMirror. Lot of usage of FLexClone for quality test and dr test too.
On the top VMware SRM drives all the dr. To facilitate the start in production of replicated instances a lot of vserver are also used.
Regards,
*Da:* toasters-bounces@teaparty.net [mailto:toasters-bounces@teaparty.net] *Per conto di *Alexander Griesser *Inviato:* mercoledì 14 maggio 2014 02:06 *A:* Jeff Cleverley; jack1729@gmail.com *Cc:* toasters-bounces@teaparty.net; Toasters@teaparty.net *Oggetto:* AW: Oracle access and backups
And please do not forget to mention that you absolutely need to provide:
10 LUNs 50GB each on RAID-786
13 LUNs 38.2GB each on RAID-32
9.5 LUNs 18.4GB each on RAID-10 with 17 hot spares
Because that’s what the documentation says about how to layout your database disks.
*Alexander Griesser*
System-Administrator
ANEXIA Internetdienstleistungs GmbH
Telefon: +43-5-0556-320
Telefax: +43-5-0556-500
E-Mail: ag@anexia.at
Web: http://www.anexia.at
Anschrift Hauptsitz Klagenfurt: Feldkirchnerstraße 140, 9020 Klagenfurt
Geschäftsführer: Alexander Windbichler
Firmenbuch: FN 289918a | Gerichtsstand: Klagenfurt | UID-Nummer: AT U63216601
*Von:* Jeff Cleverley [mailto:jeff.cleverley@avagotech.comjeff.cleverley@avagotech.com]
*Gesendet:* Mittwoch, 14. Mai 2014 02:01 *An:* jack1729@gmail.com *Cc:* toasters-bounces@teaparty.net; Alexander Griesser; < Toasters@teaparty.net> *Betreff:* Re: Oracle access and backups
Jack,
It is a similar thing here. They are old school and not that inclined to change :-) We may be able to get them there, but not in the time frame we have available to figure out how to set things up.
They are only focused on lun/local file system and we need to figure out the best way to backup and restore that.
Thanks,
Jeff
On Tue, May 13, 2014 at 5:33 PM, Jack Lyons jack1729@gmail.com wrote:
Work with your netapp team to get a reference account for using oracle on nfs - I think oracle internal IT is doing it.
We had same issue with our sr. Oracle dba...the meeting opened his mind, but with 18 months until retirement - he still didn't to undertake that project
Jack Sent from my Verizon Wireless BlackBerry
-----Original Message----- From: Jeff Cleverley jeff.cleverley@avagotech.com Sender: toasters-bounces@teaparty.net Date: Tue, 13 May 2014 17:01:57 To: Alexander Griesserag@anexia.at Cc: Toasters@teaparty.netToasters@teaparty.net Subject: Re: Oracle access and backups
Toasters mailing list Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters
-- Jeff Cleverley Unix Systems Administrator 4380 Ziegler Road Fort Collins, Colorado 80525 970-288-4611