PIT Restore from directory

Posted in 2009

ruediger.papke@t-online.de — Mon, 12 Jan 2009 01:56:17 -0800 (PST) — source: Usenet: comp.databases.informix

Hi, im not able to make a PIT-Recovery of a table from backups in directories. same problems on ids 11.50 uc2, ids11.50 fc3 on linux. The physical restore works, but the stage phase hangs. my schema file: trest.sql: ----------- database stores_demo; create table zeit ( nr serial , zeit datetime year to second )in rootdbs ; create table zeit_pit ( nr serial, zeit datetime year to second )in rootdbs ; insert into zeit_pit select * from zeit ;restore to '2009-01-08 00:06:00'; ------------------------------------------------------------ AC_CONFIG is set to this file: ac_config.0: ------------- AC_MSGPATH /home/informix/huef/trest/ac_msg.log # archecker message log AC_STORAGE /tmp # Directory used for temp storage AC_VERBOSE 1 # 1 verbose messages 0 terse messages #AC_TAPEDEV /home/informix/huef/arc AC_TAPEDEV STDIO AC_LTAPEDEV /home/informix/huef/logs AC_SCHEMA /home/informix/huef/trest/trest.sql --------------------------------------------------------------------------------- physical restore: >cat /home/informix/huef/arc/flow_0_20090107_194143_L0 | archecker -tsdvX -lphys Terminal: Scan PASSED Control page checks PASSED Table checks PASSED Table extraction commands 1 Tables found on archive 1 LOADED: stores_demo:zeit_pit produced 4389 rows. Oldest logid needed for logical restore: 7 O.K. ( the table zeit_pit has rows) Now the logical restore: >archecker -tsvX -lstage Terminal: AC_STORAGE /tmp AC_MSGPATH /home/informix/huef/trest/ac_msg.log AC_VERBOSE on AC_TAPEDEV STDIO AC_TAPEBLOCK 32 KB AC_LTAPEDEV /home/informix/huef/logs/ AC_LTAPEBLOCK 32 KB Creating log control tables Log file /home/informix/huef/logs/ ac_msg.log: ----------- STATUS: Arguments [-tsvX -lstage] STATUS: AC_STORAGE /tmp STATUS: AC_MSGPATH /home/informix/huef/trest/ac_msg.log STATUS: AC_VERBOSE on STATUS: AC_TAPEDEV STDIO STATUS: AC_TAPEBLOCK 32 KB STATUS: AC_LTAPEDEV /home/informix/huef/logs/ STATUS: AC_LTAPEBLOCK 32 KB STATUS: AC_SCHEMA /home/informix/huef/trest/trest.sql STATUS: Creating log control tables STATUS: Setting up log stream 1 STATUS: Starting recovery at log 7. STATUS: Common rollforward point 0007:0x00831:0x0018. STATUS: Log file /home/informix/huef/logs/ <--last message The Logs are in the directory and not renamed. archecker hangs. What is wrong ? What have i forgotten? TIA ruediger

↪ replying to ruediger.papke@t-online.de

Martin Fuerderer — Mon, 12 Jan 2009 15:31:28 +0100 — source: Usenet: comp.databases.informix

Hi, I did a test on my system and it does work. Do you have any non-default locale setting? (I did not set any locale related parameter.) Does a TLR run work (with restore of log data) when not specifying a PIT? Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Development GmbH Chairman of the Supervisory Board: Martin Jetter Board of Management: Erich Baier Corporate Seat: Boeblingen, Germany Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 informix-list-bounces@iiug.org wrote on 12.01.2009 10:56:17: > Hi, > > im not able to make a PIT-Recovery of a table from backups in > directories. > same problems on ids 11.50 uc2, ids11.50 fc3 on linux. > The physical restore works, but the stage phase hangs. > > my schema file: > trest.sql: > ----------- > database stores_demo; > create table zeit > ( > nr serial , > zeit datetime year to second > )in rootdbs ;> > create table zeit_pit > ( > nr serial, > zeit datetime year to second > )in rootdbs ; > insert into zeit_pit select * from zeit ;> restore to '2009-01-08 00:06:00'; > ------------------------------------------------------------ > > AC_CONFIG is set to this file: > ac_config.0: > ------------- > AC_MSGPATH /home/informix/huef/trest/ac_msg.log # > archecker message log > AC_STORAGE /tmp # Directory used for temp > storage > AC_VERBOSE 1 # 1 verbose messages 0 terse > messages > #AC_TAPEDEV /home/informix/huef/arc > AC_TAPEDEV STDIO > AC_LTAPEDEV /home/informix/huef/logs > AC_SCHEMA /home/informix/huef/trest/trest.sql > --------------------------------------------------------------------------------- > > physical restore: > >cat /home/informix/huef/arc/flow_0_20090107_194143_L0 | archecker - > tsdvX -lphys > > > Terminal: > Scan PASSED > Control page checks PASSED > Table checks PASSED > Table extraction commands 1 > Tables found on archive 1 > LOADED: stores_demo:zeit_pit produced 4389 rows. > Oldest logid needed for logical restore: 7 > > O.K. ( the table zeit_pit has rows) > > Now the logical restore: > >archecker -tsvX -lstage > > Terminal: > AC_STORAGE /tmp > AC_MSGPATH /home/informix/huef/trest/ac_msg.log > AC_VERBOSE on > AC_TAPEDEV STDIO > AC_TAPEBLOCK 32 KB > AC_LTAPEDEV /home/informix/huef/logs/ > AC_LTAPEBLOCK 32 KB > Creating log control tables > Log file /home/informix/huef/logs/ > > ac_msg.log: > ----------- > STATUS: Arguments [-tsvX -lstage] > STATUS: AC_STORAGE /tmp > STATUS: AC_MSGPATH /home/informix/huef/trest/ac_msg.log > STATUS: AC_VERBOSE on > STATUS: AC_TAPEDEV STDIO > STATUS: AC_TAPEBLOCK 32 KB > STATUS: AC_LTAPEDEV /home/informix/huef/logs/ > STATUS: AC_LTAPEBLOCK 32 KB > STATUS: AC_SCHEMA /home/informix/huef/trest/trest.sql > STATUS: Creating log control tables > STATUS: Setting up log stream 1 > STATUS: Starting recovery at log 7. > STATUS: Common rollforward point 0007:0x00831:0x0018. > STATUS: Log file /home/informix/huef/logs/ <--last message > > The Logs are in the directory and not renamed. > archecker hangs. > What is wrong ? > What have i forgotten? > > TIA > ruediger > > > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Martin Fuerderer

ruediger.papke@t-online.de — Mon, 12 Jan 2009 07:29:27 -0800 (PST) — source: Usenet: comp.databases.informix

Hi, I did not set locale parameters. I removed the 'restore to ..'-line from the schema script. same result: physical restore is o.k. archecker -tsvX -lstage gives the name of the directory with logs and hangs. What can I do. Its a very simple example. Rüdiger On Jan 12, 3:31 pm, Martin Fuerderer <MARTI...@de.ibm.com> wrote: > Hi, > > I did a test on my system and it does work. > > Do you have any non-default locale setting? > (I did not set any locale related parameter.) > > Does a TLR run work (with restore of log data) > when not specifying a PIT? > > Regards, > Martin > -- > Martin Fuerderer > IBM Informix Development Munich, Germany > Information Management > > IBM Deutschland Research & Development GmbH > Chairman of the Supervisory Board: Martin Jetter > Board of Management: Erich Baier > Corporate Seat: Boeblingen, Germany > Reg.-Gericht: Amtsgericht Stuttgart, HRB 243294 > > informix-list-boun...@iiug.org wrote on 12.01.2009 10:56:17: > > > > > Hi, > > > im not able to make a PIT-Recovery of a table from backups in > > directories. > > same problems on ids 11.50 uc2, ids11.50 fc3 on linux. > > The physical restore works, but the stage phase hangs. > > > my schema file: > > trest.sql: > > ----------- > > database stores_demo; > > create table zeit > > ( > > nr serial , > > zeit datetime year to second > > )in rootdbs ;> > > create table zeit_pit > > ( > > nr serial, > > zeit datetime year to second > > )in rootdbs ; > > insert into zeit_pit select * from zeit ;> > restore to '2009-01-08 00:06:00'; > > ------------------------------------------------------------ > > > AC_CONFIG is set to this file: > > ac_config.0: > > ------------- > > AC_MSGPATH /home/informix/huef/trest/ac_msg.log # > > archecker message log > > AC_STORAGE /tmp # Directory used for temp > > storage > > AC_VERBOSE 1 # 1 verbose messages 0 terse > > messages > > #AC_TAPEDEV /home/informix/huef/arc > > AC_TAPEDEV STDIO > > AC_LTAPEDEV /home/informix/huef/logs > > AC_SCHEMA /home/informix/huef/trest/trest.sql > > --------------------------------------------------------------------------------- > > > > > physical restore: > > >cat /home/informix/huef/arc/flow_0_20090107_194143_L0 | archecker - > > tsdvX -lphys > > > Terminal: > > Scan PASSED > > Control page checks PASSED > > Table checks PASSED > > Table extraction commands 1 > > Tables found on archive 1 > > LOADED: stores_demo:zeit_pit produced 4389 rows. > > Oldest logid needed for logical restore: 7 > > > O.K. ( the table zeit_pit has rows) > > > Now the logical restore: > > >archecker -tsvX -lstage > > > Terminal: > > AC_STORAGE /tmp > > AC_MSGPATH /home/informix/huef/trest/ac_msg.log > > AC_VERBOSE on > > AC_TAPEDEV STDIO > > AC_TAPEBLOCK 32 KB > > AC_LTAPEDEV /home/informix/huef/logs/ > > AC_LTAPEBLOCK 32 KB > > Creating log control tables > > Log file /home/informix/huef/logs/ > > > ac_msg.log: > > ----------- > > STATUS: Arguments [-tsvX -lstage] > > STATUS: AC_STORAGE /tmp > > STATUS: AC_MSGPATH /home/informix/huef/trest/ac_msg.log > > STATUS: AC_VERBOSE on > > STATUS: AC_TAPEDEV STDIO > > STATUS: AC_TAPEBLOCK 32 KB > > STATUS: AC_LTAPEDEV /home/informix/huef/logs/ > > STATUS: AC_LTAPEBLOCK 32 KB > > STATUS: AC_SCHEMA /home/informix/huef/trest/trest.sql > > STATUS: Creating log control tables > > STATUS: Setting up log stream 1 > > STATUS: Starting recovery at log 7. > > STATUS: Common rollforward point 0007:0x00831:0x0018. > > STATUS: Log file /home/informix/huef/logs/ <--last message > > > The Logs are in the directory and not renamed. > > archecker hangs. > > What is wrong ? > > What have i forgotten? > > > TIA > > ruediger > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list

Glossary

IDS (Informix Dynamic Server)