Re: Applying logical logs

Neil Truby wrote: > > I have a production server in site A, and a contingency server at site B > some miles away. Each night I copy an archive of the production server > to site B and restore it. > > Using onarchive/ondatartr, the database server at site B is in "Fast > Recovery" mode at the end of the restore. I leave it like this, because > it retains the flexibility to (a) bring it online if it's needed or (b) > copy subsequent log back-ups to site B use ondatartr to apply these, > thus bring the database server up-to-date. > > I believe that you can't to this with ontape; the archive restore and > log roll-forward must be done in the same operation. Depends what you mean by "in the same operation". You can achieve the same result with ontape by simply leaving the restore process hanging at the prompt "Do you have any more logical logs to restore?" (or whatever the text is). Then if you get more logs, you answer "Y" and insert the tape, even though it may be hours since the last tape completed. If you need to bring it on-line, you simply answer "N". Just don't let anybody near the keyboard during the hours it's just sitting there waiting for you to answer the question ;-) -- June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ----