RE: Datagaurd snapshots in lieu of backups?
Date: Tue, 25 Mar 2014 13:09:01 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F131F72B65B_at_NC2PWEX504.us.ad.lfg.com>
We are just starting to use NetApp snapshots in our environment. We are not using them in a standby configuration though...just as a supplement (for the time being) to our main databases. I am by no means an expert but would be happy to share any experiences this far. Our configuration:
Currently using a d-patch version of SnapCreator 4.0p1d2 Configured Server (running on a Windows VM) Agents running to back up both AIX and Linux x86-64 targets We utilize RAC and ASM
We have successfully tested in place recoveries, snap clones, and are working on snap mirrors for DR.
Chris..
Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kenny Payton
Sent: Tuesday, March 25, 2014 9:01 AM
To: Oracle Discussion List
Subject: Datagaurd snapshots in lieu of backups?
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
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 25 2014 - 14:09:01 CET