Re: Datagaurd snapshots in lieu of backups?

I'd like to hear a little more details on

> block level recovery have been dramatically improved.
1) How and why did it improve?

2) How do you take the snapshots on the standby so that you wouldn't be affected by Fractured Block issues (as Laimutis pointed out).

---
Maris Elsins
_at_MarisElsins <https://twitter.com/MarisElsins>
www.facebook.com/maris.elsins




On Sat, May 31, 2014 at 3:32 AM, Kenny Payton <k3nnyp_at_gmail.com> wrote:



> I thought I would provide an update on this, since I find it pretty cool

> and very useful for those using local physical standby databases.

>

> I will not go into a ton of detail but If you're interested in more let me

> know.

> We have officially migrated four 10+T databases to this model and no

> longer do RMAN backups on the primaries, except for autobackup of spfiles

> and control files. We have improved our RPO and RTO in addition to

> eliminating the backup overhead.   Things like block level recovery have

> been dramatically improved.

>

> To re-iterate, our production is not on NetApp storage, only our standby

> has snapshot capabilities.  Standby database snapshots are serving as the

> source of the primary database backups.

>

> Here are some key benefits.

>

> No RMAN backups

>

> Reduced recovery times since we take regular snapshots that can be used as

> fulls ( every 2 hours as opposed to weekly).

>

> Snapshots can be used to easily spin up thin test copies of the standby

> without interrupting apply processing.

> These test instances can be used for data recovery or point in time

> comparisons.

>

> And so you know, I am not at all affiliated with NetApp and they are

> certainly not the only vendor providing snapshot solutions.  I'm just happy

> to say I no longer run backups on production and wanted to share.

>

> Kenny

>

>

>

>

> On Mar 25, 2014 9:00 AM, "Kenny Payton" <k3nnyp_at_gmail.com> wrote:

> >

> > We've tested and are starting to move some of our Data Guard physical

> standby's to storage with snapshot capabilities, specifically Netapp.  Our

> plan is to use snapshots and transported log files in Lieu of production

> backups.  Anyone else doing this?  I'm not talking about backups of the

> standby, just using the storage snapshots similar to the way you would use

> image file copies.  Archived logs will be used to roll forward any snapshot

> and we're planning on taking daily, potentially hourly, snapshots to meet

> our recovery window requirements.

> >

> > I've successfully tested database, datafile and block level recovery

> operations.  The approach provides a number of advantages including

> maximizing productivity of capital costs of the standby environments,

> reducing primary database resource consumption as well as providing a

> shorter RTO.  An additional benefit is the ability to bring up a copy of

> the standby, via Flex Clones, in read/write mode for testing without

> interrupting the continuity of our DG apply processes.

> >

> > We do not currently ship anything offsite, we have remote DR DG copies

> for that purpose.

> >

> > Thanks,

> > Kenny

>


--
http://www.freelists.org/webpage/oracle-l