Re: Applying logical logs

In article <34CFAEA7.2C79@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >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. > >Am I right? It makes a difference because the database server is so >large that it takes over an hour to restore. > YOu can do ontape -p (Physical Restore) ontape -l (Logical Restore) >Thanks > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK >neil.truby@chase.com -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care