Re: DB recovery using ontape

It sounds like the transaction was still in the current log so Yes should have been the correct answer. However, the level 0 was performed while in log 1, so the restore will ask you to start logical recovery with log 1. If you filled log 1 and rolled to log 2, then said Yes to the "backup current log" message, you would overwrite the file (since it went to a cooked file and not to tape). Putting the pieces together, answer Yes if the transaction was contained in log 1 and log 1 is still the current log. Answer No if it was in log 1 and log 2 is current and you are using cooked files for the log. Take care. Kenji Hino <kenji@alcatraz.net> wrote in article <33FB474A.3A08A5E4@alcatraz.net>... > I did say "No" to that but I still didn't get the update. Do I need to > do something else ? > > Kenji > > Mark D. Stock wrote: > > > Kenji Hino wrote: > > > > > > snip... > > > To get familiar with the tool, I created a dataspace and put data in it > > > and created a level-0 archive using "ontape -s". Then, I updated one > > > of the record and created a logical log archive using "ontape -a". For > > > the testing purpose, I used UNIX files (not devices) to specify the > > > destination for both system and logincal archive tape devices. > > > When I try to do full recovery using those two files, I get the system > > > archive recovered fine but I can't get the logical log to rollforward > > > which means that I can't get any update after I created the system > > > archive. Does anybody know what I am doing wrong ? During the > > > recovery, > > > > During the restore it asks if you want to backup the current logs. You > > > > MUST say NO. Otherwise you will overwrite your previous backup, and > > have no logs to restore. > > > > Hope that helps, > > -- > > Mark.