Re: How are you backing up your V,VLDB????

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:b19rbs028b3_at_drn.newsguy.com...
> In article <b19q9b$23f$1$8302bc10_at_news.demon.co.uk>, "Jonathan says...
> >
> >
> >I think the most significant strategic point
> >is that a database of this sort is almost
> >always susceptible to partitioning, with
> >a date-based partition. So a large fraction
> >of the database can be put into read-only
> >tablespaces.
> >
> >if you are in this position, the backup
> >strategy consists of making sure you have
> >a library of the read-only components, and
> >the daily/weekly backup of changing data
> >turns back into a large but viable volume.
>
> Quite true, but one point I'd like to add that I'm sure Jonathan and Brian
> already know.
>
> I've heard this "make it all read-only, back it up once and then you can
ignore
> it" approach many times. Most of the time the point that's left out of
that
> discussion is make sure you can get back to that backup very very quickly.
Take
> a crazy example. You back up lots of read-only tablespaces January 1 -
December
> 31 the database crashes and you need to restore. If you haven't kept
track of
> the backups, you may have to go through 365 tapes to find what you want
for the
> recovery. In other words, make sure it's as automated as it can be to get
those
> read-only tablespace backups back again. If you can't automate it, you
may want
> to consider backing them up every month or so, just to make it quicker to
> recover.
>
> Also make sure you have more than one copy of the tapes that have the read
only
> tablespaces on them. Otherwise if they're lost or otherwise damaged
you're in
> deep doo-doo (TM).
>
> Pete
> >

Hi Pete,

Good point. We're looking at converting much data to read only and backing it up once in a blue moon. However, our backups get copied to tape and the tapes get re-cycled after 3 months (or so). So we need to change something here or make sure the "blue moon" arrives at least within this time period !!

Cheers

Richard Received on Thu Jan 30 2003 - 06:57:24 CST