Oninit cdi / Archive
Talk to an expert →

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

Posted in 2003

Topics: Backup & Restore, Server Administration, Logging & Checkpoints, Migration, Import/Export & Data Conversion

Mark Denham — — source: Usenet: comp.databases.informix

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

↪ replying to Mark Denham
David Summers — — source: Usenet: comp.databases.informix

Christian, On your test system delete all logical log backups and delete all logical log entries from the ixbar.# file that occured AFTER the last dbspace backup you are recovering from. Run onbar -r -l, it will not find any logs so it will go into fast recovery. Once recovered run onmode -m Regards, David "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

Glossary