Re: Datagaurd snapshots in lieu of backups?

From: Kenny Payton <k3nnyp_at_gmail.com>
Date: Thu, 27 Mar 2014 06:31:20 -0400
Message-Id: <245BFFC8-FF2C-4F69-BCD8-9606EE7B59C1_at_gmail.com>


Just taking the snapshot. Iíve debated stopping the apply process but itís not really necessary since the snapshot is taken consistent across the entire database.

On Mar 27, 2014, at 6:03 AM, Laimutis.Nedzinskas_at_seb.lt wrote:

> Hi
>
> Do you open standby in read only to force alert message like "recovering datafiles up to scn..." (citing from memory) or do you just take the snapshot ?
>
> On the other hand, it should work either way - taking the snapshot in the middle of recovery is the same as crashing database in the middle of work. Crash recovery should recover lost memory and go forward.
> Or not ?
>
>
>
> Pagarbiai / Sincerely
> Laimutis Nedzinskas
> Lead of Database Administrators
> IT Lithuania, SEB
> Direct phone +370-5-2682759
>
> ---------------------------------------------------------------------------------
> Please consider the environment before printing this e-mail
>
> <graycol.gif>Kenny Payton ---2014.03.25 15:02:19---We've tested and are starting to move some of our Data Guard physical standby's to storage with snap
>
> From: Kenny Payton <k3nnyp_at_gmail.com>
> To: Oracle Discussion List <oracle-l_at_freelists.org>,
> Date: 2014.03.25 15:02
> Subject: Datagaurd snapshots in lieu of backups?
> Sent by: oracle-l-bounce_at_freelists.org
>
>
>
> 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
Received on Thu Mar 27 2014 - 11:31:20 CET

Original text of this message