Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle backups using Snapshot Technology

RE: Oracle backups using Snapshot Technology

From: Hameed, Amir <>
Date: Thu, 9 Nov 2006 08:18:18 -0500
Message-ID: <>

We have been using EMC's BCV technology to backup our mission critical database for the past fours years and it has been working fine for us. The database size is over 1.2 TB. Once the establish is complete, the split is almost instantaneous and does not take more than a minute. As for the argument that "until the split is sent to tape, there is no good backup because a disk failure in the primary backup storage can destroy the entire snapshot". Even though this is true but there are ways to protect the online backup mirror by mirroring it with 1+0 or 0+1. It is certainly not a cheap solution but there is no guarantee that a tape will not go bad after the snapshot is copied to the tape. We have been operating our snapshot devices in "non-protective" mode all these years and we have had situations where a drive went bad after the snapshot was taken, but we use rotating BCVs where we always have two backups on-line, the most current one and the one taken a night before that and if the devices are configured properly, the chances of both mirrored copies going bad is low. The backups also go to take soon after the snapshot is taken.

-----Original Message-----
[] On Behalf Of Alex Gorbachev Sent: Thursday, November 09, 2006 1:59 AM To:
Cc:; Subject: Re: Oracle backups using Snapshot Technology

Well, for those requirements you better go with third-mirror / split-mirror type of technologies. I wouldn't bet on snapshots in this case (or maybe it's just wording and that what you meant). Recently, we've implemented EMC BCV backups of couple 1 TB databases and they work like a charm - 4 times a day having a backup - dream of any DBA! :) Plus daily off-host backups to tape.

On 11/8/06, Mark Brinsmead <> wrote: ...
> In cases where you have really extreme backup requirements (e.g.,
> terabyte+ database running flat-out 24x7 on the biggest hardware you
> can find) snapshot technologies can be a godsend. They might be the
> only option available.


Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

Received on Thu Nov 09 2006 - 07:18:18 CST

Original text of this message