RE: Netapp snapshot backups for RAC

From: Matthew Zito <mzito_at_gridapp.com>
Date: Tue, 5 Jan 2010 16:29:41 -0500
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B1027C7D93_at_exchange.gridapp.com>



If you take the snapshot, you can use NDMP or dd without getting oracle in the picture.  

Matt  


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Upendra N Sent: Tuesday, January 05, 2010 4:26 PM
To: exriscer_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Netapp snapshot backups for RAC  

Hi there,
Quick question following up on this thread: After you to take the snapshot how do you backup the snapshot ASM volumes (they are still RAW)?
Do you use DD or ASMCMD or any other way?

If we need to use asmcmd that would require an Oracle license. I am trying to avoid that.

Thanks
-Upendra


Date: Wed, 25 Nov 2009 10:00:53 +0100
Subject: Re: Netapp snapshot backups for RAC From: exriscer_at_gmail.com
To: nupendra_at_hotmail.com
CC: freek.dhooge_at_uptime.be; oracle-l_at_freelists.org

With split-mirroring or snapshot solutions (EMC or NETAPP or anyother vendor) when working with ASM you need to carefully layout the Disk Groups.

For example you should (or shall I say must) NOT mix databases in same Disk Groups, because when you run the snapshot you will be backing up all databases in the Disk Group, that is not a problem. The problem is when you have to restore, when you restore a snapshot you will be restoring several databases!

Thanks

--
LSC

On Wed, Nov 25, 2009 at 7:50 AM, Upendra N <nupendra_at_hotmail.com> wrote:

Hi Freek,
Thanks for your reply. A couple of follow up questions.




> There are some limitations in how you should structure your
volumes/data. What kind of limitations are you referring to? Could you share a few more areas/details?
> I have used it in the past on nfs environments, and it works
reasonable although there are some bugs and annoyances in how the product currently works. Any major issues you ran into? Thanks again -Upendra
> From: Freek.DHooge_at_uptime.be

> To: nupendra_at_hotmail.com; oracle-l_at_freelists.org

> Date: Tue, 24 Nov 2009 17:07:00 +0100
> Subject: RE: Netapp snapshot backups for RAC

>
> Hi,
>
> If you are using ASM, then you will need to use the "snapmanager for
oracle" product from NetApp.
> There are some limitations in how you should structure your
volumes/data.
>
> I have used it in the past on nfs environments, and it works
reasonable although there are some bugs and annoyances in how the product currently works.
>
>
> Regards,
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Upendra N
> Sent: dinsdag 24 november 2009 16:46
> To: oracle-l_at_freelists.org
> 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.freelists.org/webpage/oracle-l
>
>
________________________________ Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up now. <http://clk.atdmt.com/GBL/go/177141664/direct/01/http:/clk.atdmt.com/GBL /go/177141664/direct/01/> ________________________________ Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up now. <http://clk.atdmt.com/GBL/go/177141664/direct/01/%0D%0Ahttp:/clk.atdmt.c om/GBL/go/177141664/direct/01/> ________________________________ Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up now. <http://clk.atdmt.com/GBL/go/177141664/direct/01/> -- http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 05 2010 - 15:29:41 CST

Original text of this message