RE: Database Restore...

If the backup was done with ontape, then yes you want the DB to be offline and shut down (onmode -yuk) and then run the command ontape -r to start the restore. This is with INFORMIX-Universal Server Version 9.14.UC6. I assume it would be similar with 7.30. After the restore, check the status with onstat - -r 10 and when the engine gets in quiescent mode, bring it back on-line with a onmode -my. Don't be surprised if you have to wait ~20 minutes or longer for it to get into quiescent mode. This is from my experience this week. And I don't back up the logs. Your milage may vary. Thomas > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Stacey Windsor > Sent: Thursday, October 21, 1999 12:21 PM > To: < > Subject: Database Restore... > > > > Greetings.. > > > I need to restore a database. I have a Level 0 backup from last > night and a tape with 5 log files since that last Level 0 backup. > I simply want to overwrite the existing database. > > What is the command to copy all full and partial log files?? > > Should the current database be offline or online prior to the restore?? > > > Using SOC UNIX 5.05 > Informix 7.30 UC > > >