Datagaurd snapshots in lieu of backups?

From: Kenny Payton <k3nnyp_at_gmail.com>
Date: Mon, 24 Mar 2014 19:33:48 -0400
Message-ID: <CAEidWqPf0zLWvd8nqSum35mvSbSNHcA7Ds1Ak-Og_HUi8U0qeQ_at_mail.gmail.com>

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

Received on Tue Mar 25 2014 - 00:33:48 CET