Re: Datagaurd snapshots in lieu of backups?
- From: Kenny Payton <k3nnyp@xxxxxxxxx>
- To: Laimutis.Nedzinskas@xxxxxx
- Date: Thu, 27 Mar 2014 06:31:20 -0400
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@xxxxxx 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@xxxxxxxxx>
> To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>,
> Date: 2014.03.25 15:02
> Subject: Datagaurd snapshots in lieu of backups?
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>
>
>
> 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
>
>
Other related posts:
