ADSM-L

Re: [ADSM-L] PA-RISC system shelf life

2010-07-27 21:22:24
Subject: Re: [ADSM-L] PA-RISC system shelf life
From: "Prather, Wanda" <wPrather AT ICFI DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 28 Jul 2010 01:20:35 +0000
The TDP for Oracle is just a connector/driver; it's actually Oracle RMAN that 
is selecting the data out of the data base on a backup, and writing it back to 
the DB on restore.  So if you have issues restoring from PA-RISC to Itanium, 
that is actually a question for Oracle rather than TSM.

But the answer to your question is NO.  Don't plan on any server working for 20 
years.
TSM will happily store the data, because you can keep migrating it from one 
type of storage media to the next.
But besides the question of keeping the server physically working, you will be 
reliant on the version of Oracle you have installed on it.
If your restore fails (and again, it's RMAN handling the DB, not TSM), you 
aren't going to be able to get assistance from Oracle (or anybody else).

I would also point out, if you have a requirement to keep the data for 20 
years, it's probably not just 1 copy of the data- it's probably many copies 
over the years.  If you do need to recover something 10 years from now, how are 
you going to FIND it?  Restore every copy sequentially until you find what 
you're looking for?

The way to handle legal retention of that sort of stuff is with one of the 
archiving products.  (Tivoli has one, and there are others that use TSM as the 
backstore).  They not only put the data out in a machine-independent form, they 
index it so you have a clue of finding it in 10 years.  

Barring implementation of an archiving system (which is not without cost), you 
need to have your DBA's set up some sort of periodic dump to a non-DB dependent 
format (e.g. an ASCII text flat file) and archive that. 

W

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Thomas Denier
Sent: Tuesday, July 27, 2010 4:41 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] PA-RISC system shelf life

-----Duane Ochs wrote: -----

>Thomas,
>Did you perform a TDP backup of the Oracle database to TSM?
>Or use a native oracle dump and backup the dump ?

The backups were done with the software Tivoli used to
market as TDP for Oracle, and now markets as part of
TSM for Databases.