Re: Datagaurd snapshots in lieu of backups?

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Thu, 27 Mar 2014 12:35:14 +0200
Message-ID: <OFCCAAFA64.732E6296-ONC2257CA8.0039F3F8-C2257CA8.003A28AA_at_seb.lt>


> since the snapshot is taken consistent across the entire database.

well, for DG even this requirement is not necessary. It's similar to old-good hot backup technique. Though Fractured Block issue must be tackled then, imho.

Brgds,
Laimis N


Please consider the environment before printing this e-mail

From:	Kenny Payton <k3nnyp_at_gmail.com>
To:	Laimutis.Nedzinskas_at_seb.lt,
Cc:	Oracle Discussion List <oracle-l_at_freelists.org>
Date:	2014.03.27 12:31
Subject:	Re: Datagaurd snapshots in lieu of backups?




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


graycol.gif
Received on Thu Mar 27 2014 - 11:35:14 CET

Original text of this message