Re: Questions about Archive & Restore

>What happens if you lose just a few tables ?? Do we have to >go to the full extent of restoring the entire dbspace onto a different >machine and then copy the tables over ? Or restore an older version of >the data on the current instance ? Officially, yes, those are the options. >The reason I'm asking this questions is that a couple of important >tables were dropped from our production m/c and we are going through >the process of recovery. Ah-ha, another victi-- um, candidate for Arcunload. I wrote a little unsupported utility program called Arcunload which takes a level 0 ontape backup and extracts a single table into onunload format, to tape or disk. I strongly recommend re-loading this into a test instance to safeguard against any corruption being introduced into your production system. Because of differences between versions (e.g. GLS and some system catalogs), you must re-load into a version that is the same as the one the archive came from, and you must use a version of arcunload that corresponds to your OnLine version. Arcunload is available on the IIUG website, under Special Software. Go to http://www.iiug.org and look for the Software section. June