Re: Restoring with logical logs only

I don't think I've seen any answers to this question, so I'm sending an answer now. Sorry if it's a waste of bandwidth. >From: uunet!teal.csn.org!billm (Bill Miller) >Subject: Restoring with logical logs only >Date: Thu, 10 Jun 1993 20:23:53 GMT >X-Informix-List-Id: <news.3554> > >Is it possible to update/restore a database using just logical logs. >NOT archive tapes. No. A level 0 archive is required to give a strating point, and the logical logs record the differences between the level 0 archive and the current state. (Even if you had all the logical logs since the OnLine system was built, and if all the databases were logged, I think (though I'm not absolutely certain) that you'd need a level 0 archive to start the ball rolling). >We are trying to set up a read-only image of our production data base >and would like to keep it up-to-date with minimal down time ... >for running batch jobs, queries etc. > >Our plan is to roll logical logs forward each night on the read- >only database to keep it up to date. Complete restores take waaaay >to long (16-22 hrs). You can only do that if the read-only database is kept in recovery mode. However, I don't think (but again, I'm not certain) that a version 5 OnLine system can be used, even for read-only work, in recovery mode. >We are running ON-Line 5.0 on an R/S6000-980. We would like to >distribute our user load over two processors, using the same >LARGE (9 Gb) database. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>