RE: Netapp snapshot backups for RAC

  • From: Upendra N <nupendra@xxxxxxxxxxx>
  • To: <exriscer@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 5 Jan 2010 16:26:21 -0500

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.


                                          
Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up now.  
                                  
_________________________________________________________________
Hotmail: Trusted email with Microsoft’s powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141664/direct/01/

Other related posts: