RE: Netapp snapshot backups for RAC

  • From: "Matthew Zito" <mzito@xxxxxxxxxxx>
  • To: <nupendra@xxxxxxxxxxx>, <exriscer@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 5 Jan 2010 16:29:41 -0500

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

 

Matt

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Upendra N
Sent: Tuesday, January 05, 2010 4:26 PM
To: exriscer@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx
To: nupendra@xxxxxxxxxxx
CC: freek.dhooge@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx

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@xxxxxxxxxxx> 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@xxxxxxxxx


> To: nupendra@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx

> 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@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> 
> 
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Upendra N
> Sent: dinsdag 24 november 2009 16:46
> 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.
> --
> //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/> 

Other related posts: