Here is a suggestion for your Oracle databases.
Buy a "clustered" Network Appliance filer, F880C, with
2Tbytes each. Put Oracle on it. Turn on Snapshots and
purchase the Snap Recover license. Then, in two
months buy their new NearStore filer and get
rid of daily backups altogether. Just snap to the
NearStore every hour if you want. Once a week, do a
full backup of the NearStore filer, which happens to
be at a remote site along with your tape drives.
The restore of a 2/4/6 TB disaster in this scenario
would take about 2 minutes or less to recover data.
Doesn't matter if the data is 1TB or 6TB, it takes
two minutes because that's how long it takes for
a NetApp to reboot.
john
scott.kendall AT abbott DOT com wrote:
>
> Snapshots are "cool" and they're great for many things, but as you mentioned
> they have a small foot print. That's because it's just the pointers to the
> original data and any changed data made throgh a "copy-on-write" process.
>
> It will help if you drop a table accidentally or need to roll-back to the way
> things used to look before that bad batch job.
>
> If there is actually corruption of the data the pointers are just pointing to
> bad data. It won't help your recovery in this case!
>
> - Scott
>
>
> Chris Brewer
> <cgbrewer AT rmbsc DOT com> To:
> "'Rick Keahey'" <rickkeahey AT hotmail DOT com>
> Sent by: cc: veritas-bu
> AT mailman.eng.auburn DOT edu
> veritas-bu-admin AT mailman DOT eng. Subject:
> RE: [Veritas-bu] Disk to Disk Backups
> auburn.edu
>
>
> 03/06/2002 04:33 PM
>
>
>
> What about snapshots and BLIB (block level incremental backups). I've not
> used them (hope to soon), but the theory is intriquing as it has a very
> small data footprint and rapid recovery, among other things...
>
> For official email, please respond to cgbrewer AT kpmg DOT com
>
> Chris Brewer
> UNIX Systems Consultant
> Rocky Mountain Broadband Solution Center
> KPMG Consulting, Inc.
> 6399 S. Fiddler's Green Circle #400
> Greenwood Village, CO 80104
>
> 720-493-7992
>
> -----Original Message-----
> From: Rick Keahey [mailto:rickkeahey AT hotmail DOT com]
> Sent: Wednesday, March 06, 2002 2:53 PM
> To: joe AT joe DOT net
> Cc: veritas-bu AT mailman.eng.auburn DOT edu
> Subject: Re: [Veritas-bu] Disk to Disk Backups
>
> Ok, so here is my delima. I have more and more customers coming to me
> saying that they have a database that is mission critical and if it goes
> down, they need to be able to restore it very quickly, within minutes or few
>
> hours. The problem is that these databases are expected to grow to several
> terabytes in the next year or so. Backups alone will take forever, but the
> restores will be ugly. We are using DLT's right now and are just starting
> to use SDLT's. I use NetBackup for backups software and do not have the
> option to change off of that. Disk base is really the only choice that I
> have to look at from here, although I am not against looking at some other
> means that will speed things up.
>
> Thanks,
> Rick
>
> >From: Johnny Oestergaard <joe AT joe DOT net>
> >To: "Rick Keahey" <rickkeahey AT hotmail DOT com>
> >CC: veritas-bu AT mailman.eng.auburn DOT edu
> >Subject: Re: [Veritas-bu] Disk to Disk Backups
> >Date: Wed, 06 Mar 2002 22:11:09 +0100
> >
> >We have tried to do diskbackups to see if it's faster, but what we have
> >seen is that is't faster to use tapes. Our disksubsystem is a STK
> >SVA9500 and the tapedrives are STK 9940 all using FC
> >But if you use DLT it could be that it's faster to disk.
> >
> >I know about sites where they use STK VSM systems and that should be
> >fast, but I have never tried that.
> >
> >/johnny
> >
> >At 11:34 06-03-2002 -0800, you wrote:
> >>I am researching different ways to do disk to disk backups for faster
> >>backup and restore times. Does anyone have any suggested hardware
> >>platforms to do this on. I know that ATL just announced a new
> >>solution called the DX-30, but wanted to see if anyone else out there
> >>knew of anything else that works as good. Appreciate your input.
> >>
> >>Thanks,
> >>Rick
> >>
> >>_________________________________________________________________
> >>MSN Photos is the easiest way to share and print your photos:
> >>http://photos.msn.com/support/worldwide.aspx
> >>
> >>_______________________________________________
> >>Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> >>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
--
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
+ John D Stephens UNIX Administration +
+ Texas Instruments 12500 TI BLVD, Dallas +
+ jstephens AT ti DOT com 214-480-6229 +
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
|
