RE: Netapp snapshot backups for RAC
- From: Upendra N <nupendra@xxxxxxxxxxx>
- To: <mzito@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Nov 2009 01:46:02 -0500
Hi Matt,
My intention is to reduce the use of Oracle resources, I understand the io
limitations.
I will investigate SnapManager.
Thanks for cautioning on exposing the snapshotted LUNS on the same host.
This environment is currently running Oracle 10.2, I didn't think DNFS existed
in 10g? I know it is available in 11g.
If you have seen DNFS in action, could you share some of your experiences?
Thanks again
-Upendra
> Subject: RE: Netapp snapshot backups for RAC
> Date: Tue, 24 Nov 2009 10:59:45 -0500
> From: mzito@xxxxxxxxxxx
> To: nupendra@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
>
>
> It works great. Put the database in hotbackup mode, take a snapshot, back up
> the snapshot. Couple of notes, though:
>
> - Remember that the way NetApp snapshots work, any I/Os to the snapshots go
> against the same physical disks. Normally not an issue, but if you're
> already heavily utilized on those disks, you can get performance problems.
> - If you want a more elegant/automated way of doing these backups, there's
> SnapManager for Oracle. Additional cost option, but it saves the
> scripting/integration headaches you deal with when doing things by hand
> - Since you're using ASM, make sure to not expose the snapshotted LUNs to the
> original server, since they'll have the same disk labels and headers
> - Also, you can use snapshots to make backups of your OCR device as well,
> prior to attempting to add a resource, or reconfigure your cluster
> - Any reason you're not using NFS/DNFS for your database? It simplifies a
> lot of the things above
>
> Thanks,
> Matt
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Upendra N
> Sent: Tue 11/24/2009 10:45 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Netapp snapshot backups for RAC
>
> Hello all,
> Currently doing a RMAN bi-weekly backups to disk. Database is running ASM on
> Netapp storage.
> I am considering netapp snapshot backups for Oracle RAC to reduce the Oracle
> overhead.
> Have anyone used it on a critical production database? What are your thoughts?
> Have you seen any issues with it?
>
> Thanks in advance
> -Upendra
>
>
>
> ________________________________
>
> Windows 7: I wanted simpler, now it's simpler. I'm a rock star.
> <http://www.microsoft.com/Windows/windows-7/default.aspx?h=myidea?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_myidea:112009>
>
_________________________________________________________________
Windows 7: It works the way you want. Learn more.
http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen:112009v2
Other related posts:
