RE: Oracle backups using Snapshot Technology
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: <gorbyx@xxxxxxxxx>, <pythianbrinsmead@xxxxxxxxx>
- Date: Thu, 9 Nov 2006 08:18:18 -0500
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.
Amir
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alex Gorbachev
Sent: Thursday, November 09, 2006 1:59 AM
To: pythianbrinsmead@xxxxxxxxx
Cc: DIANNA.GIBBS@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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 <pythianbrinsmead@xxxxxxxxx> 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
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
