Re: Datagaurd snapshots in lieu of backups?
- From: Laimutis.Nedzinskas@xxxxxx
- To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 Mar 2014 12:03:10 +0200
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
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:
