Re: Physical restore that doesn't require a logical restore

Hi, if you try to move data from a host to another, you MUST perform a backup with -w option, this option is for whole backups. The Restore must also be performed with the option -w. You can try perform a Restore with the option time-of-point. Regards Glenn c-eriks@algonet.se (Christian Eriksson) wrote in message news:<d0d6f67c.0309221303.61cc41f1@posting.google.com>... > I did that but then this happened (from the message log): > > 15:58:54 Physical Restore of felisia_db01 Completed. > 15:58:54 Checkpoint Completed: duration was 0 seconds. > 15:58:54 Checkpoint loguniq 5720, logpos 0x18 > > 16:10:39 No logical log restore will be performed. > 16:10:39 Preparing Physical Log for Fast Recovery ... > 16:10:51 Preparing Logical Logs for Fast Recovery ... > 16:10:57 Physical Recovery Started. > 16:10:58 Physical Recovery Complete: 0 Pages Restored. > 16:10:58 Logical Recovery Started. > 16:10:58 Checkpoint Record not Found in Logical Log. > 16:11:00 Cannot Rollforward from Checkpoint. > 16:11:01 Informix Dynamic Server Stopped. > 16:11:01 mt_shm_remove: WARNING: may not have removed all/correct> segments > > What did I do wrong? > > Regards Christian Eriksson > > PS. Before this restore I deleted all the logical log entries after > the last backup from the ixbar.<servernum> file. The ixbar.<servernum> > file was copied from the host I'm importing from. Did the delete of > the logical log entries cause the "No logical log restore will be > performed."? DS. > > "Mark Denham" <mkdenham@comcast.net> wrote in message news:<bj63h8$nue$1@terabinaries.xmission.com>... > > After the physical restore completes bring the engine online using > > onmode -m.> > > > System should do fast recovery and come up. > > > > Mark > > > > ----- Original Message ----- > > From: "Christian Eriksson" <c-eriks@algonet.se> > > To: <informix-list@iiug.org> > > Sent: Wednesday, September 03, 2003 17:03 > > Subject: Physical restore that doesn't require a logical restore > > > > > > > Hi! > > > > > > How do I ensure that my physical restore, onbar -r -p, isn't followed by > > > a logical restore, i. e. followed by applying the logical logs since the > > > last full or incremental backup? I want to use this in database server > > > migration, as an imported restore, and I want the migration to be as > > > fast as possible. The copied/migrated database server should be used in > > > a test environment so I can cope without the data since the last backup. > > > > > > Regards Christian Eriksson > > > > > > > sending to informix-list