Datagaurd snapshots in lieu of backups?
- From: Kenny Payton <k3nnyp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 24 Mar 2014 19:33:48 -0400
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:
