In the case where you are required to put the data on tape, you might as
take a new tape out of the box, write the name of the archive one it and put
it into the box going off-site. Skip that annoying step where you put the
tape into a drive. If you aren't ever going to be able to read it anyway,
why write it.
Perhaps you can get a deal on tapes that don't actually have any tape in the
cartridge. Those should be considerably cheaper. The problem would be the
weight. I guess you could fill the cartridges with fishing weights to make
the approximate weight of a cartridge with tape in it.
On top of this, you're probably archiving, in paper format, the original
stuff that was used to fill the database. The good news about that is you
could actually read the paper 20 years from now.
Kelly J. Lipp
Storage Solutions Specialists, Inc.
PO Box 51313
Colorado Springs CO 80949-1313
(719) 531-5926
Fax: (240) 539-7175
Email: [EMAIL PROTECTED] or [EMAIL PROTECTED]
www.storsol.com
www.storserver.com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Reinhold Wagner
Sent: Thursday, April 05, 2001 9:13 AM
To: [EMAIL PROTECTED]
Subject: Re: Long Term Archive for Databases
Jim,
we have this discussion nearly every year. We all know that we need not only
the
backup of the database, but also the appropriate DBM version plus Operating
system, hardware and application software. We have to keep our inventory
data
for 15 years! I have more than 10 years old half inch tape reels from our
mainframe time. Today i don't have any mainframe, not any version of the
operating system or application software and i dont't know anybody who would
be
able to read a 1/2 inch tape reel! And - more important - there is nobody in
our
company who knows the data and would be able to work with them!
Our solution is to migrate the data to an optical archive. So the supplier
of
the archive is responsible that the data can be read and interpreted for
such a
long time. Despite that we are forced to keep 1 backup of our SAP database
per
year. Nonsense. But we do it and hope that noone would ever need it!
regards
Reinhold
Jim Taylor schrieb:
> I keep getting this pressure from clients to keep copies of their 500GB
> oracle database for 7 years. They don't seem to know why they want it
kept
> for seven years. Like most others they don't think of what their restore
> requirements are.
>
> Has anyone had to restore/retrieve a large database that was, say more
than
> 2 years old. If so was it successful and was it as simple as restoring
just
> the DB.
>
> ThanX
>
> > Jim Taylor
> > Senior Associate, Technical Services
> > Enlogix
> > * E-mail: [EMAIL PROTECTED]
> > * Office: (416) 496-5264 ext. 286
> > * Cell: (416)458-6802
> > * Fax: (416) 496-5245
> >
> >
