RE: EMC Clariion "Snaps" for Oracle Backups anyone?

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'mzito@xxxxxxxxxxx'" <mzito@xxxxxxxxxxx>, fuadar@xxxxxxxxx
  • Date: Tue, 28 Dec 2004 13:14:00 -0500

Matt,

Thanks for the explanation of the differences.  So how would one implement
this snap functionality with an Oracle database (or would it be appropriate
to do so?)  I would not feel good using this as part of a backup strategy,
would you?  How would it be useful?

Thanks,

Tom

-----Original Message-----
From: Matthew Zito [mailto:mzito@xxxxxxxxxxx] 
Sent: Tuesday, December 28, 2004 12:35 PM
To: fuadar@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: EMC Clariion "Snaps" for Oracle Backups anyone?


The snap functionality being described is very different from BCVs.  A 
bcv is a real third-mirror copy of the data.  A snap, or snapshot, is a 
"virtual" or fake disk that is a representative image of the volume at 
a given point-in-time.  The snapshot takes up only as much disk space 
as what has changed on disk since the snapshot has been taken.  Better 
snapshot implementations can do cascading snapshots, where all of the 
snapshots only take up as much disk space total as has changed since 
the first snapshot.

The disadvantage of snapshots is that any disk I/O to the snapshot 
actually goes to the live disk, so using snapshots for I/O intensive 
operations could impact the performance of your production database.  
The advantage is that while you can only have one, or possibly two, BCV 
copies of a disk, you could have potentially hundreds of snapshots, and 
can roll back your live image to any one of those snapshots online.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: mzito@xxxxxxxxxxx
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com


On Dec 28, 2004, at 9:32 AM, Fuad Arshad wrote:

> by snaps do you mean emc splits. if so thisis only  adisk split and 
> hardware issues can arise causing you to lose disk. and we've had to 
> deal with situations like those.
> We do use emc bcv splits but  fro a shot period of time.
> the pupose if to keep data current in case o any  mishap
> but tape recover is still importnat.
> it also depends o the nature and colatility of the data.
> why does your integrator only want snaps.
> is there a problem(performance issue) with backing up the primary db.
> if so emc can get backups of the split to tape also.
>
>
> "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx> wrote:
> Hi!
>
> We just bought two EMC Clariion CX700 boxes as SAN storage. The boxes
> are primarily used for Oracle databases. Our system integrator is 
> trying
> to persuade us to use "snaps" for database backups.=20
>
> Is anybody out there running a similar configuration and can share 
> their
> expieriences?
>
> This is 9.2 on HP-UX 11i.
>
> Thanks,
> Helmut
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: