Re: Ontape recovery ?

Barry Leb wrote: > > Hopefully, I can present this in a cohereny manner. > > This is the situation. We backup our 7.14 database using ontape. We > have a problem where some data got blown away several weeks ago, and > it was just now discovered. I have an ontape Level 0 from three weeks > ago. Obviously, I can't restore this tape to the current production > database. > > What I would like to do is restore this tape on the same machine in a > different instance using the same chunk names but using symbolic links > to different raw devices. For example: [SNIP] > Will this restore procedure work, all other configuration parameters > being equal, without clobbering my production database? > > In other words, does the ontape -r actually look to the pathnames to > the chunk, or does it only care that the chunk exists in the new > instance? Been there. Done that! No this will not work because ontape reads reserved pages from tape and slaps them down on disk onto the ROOT dbspace specified on the reserved page chunk page on the tape so that the restored data WILL ABSOLUTELY overwrite your production database. You do not need to build a new rootdb for the restored instance it will be built from the restored data. You need to restore onto a separate machine where the disk aliases are unused or, if you can live with out the production engine for several hours, go through the following: 1) bring down the production database, 2) break the links, 3) recreate the links to the new diskS, 4) restore, 5) bring up the restored engine, 6) unload/dbunload/onunload the lost data, 7) bring down the restored engine, 8) break the links, 9) recreate the original links to the production drives, 10) bring up the production engine, 11) load/dbload/onload the extracted data. No easy solution. Art S. Kagel