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 presume you mean recovery mode. > I believe that you can't to this with ontape; the archive restore and > log roll-forward must be done in the same operation. I don't see why not. We used to have a large customer here (well, we still do) who wanted a hot backup with OnLine 4.1. They used to use tbtape to do the archive and restore onto a second machine. The second machine was then left in recovery mode, having log tapes restored as soon as they were backed up on the primary server. As you say, if the primary went down, they restored all new log tapes and then told tbtape there were no more, and went online. > Am I right? It makes a difference because the database server is so > large that it takes over an hour to restore. I'm not sure what happened if the secondary machine goes down in the middle of the restore. But I guess you just start again with the latest archive. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+