No able to restore.

I am doing ISM onbar backup-restore test in ISM Version 11.50.FC5. Steps i follow is as below: My database in logging and buffered mode. 1. onmode -lc (forced logical log and checkpoint) 2. onbar -b -L 0 (0 level backup)- below is extract of bar_act.log: 2009-11-13 05:41:27 4423 4418 /appl/informix/11.50_CERT/bin/onbar_d complete, returning 0 (0x00) 2009-11-13 05:57:37 8077 8072 /appl/informix/11.50_CERT/bin/onbar_d -b -L 0 2009-11-13 05:57:38 8077 8072 Archive started on rootdbs1, leadsdat1, leadsdat2, leadsdat3, leadsdat4, leadsdat5, tinfodat 1, tinfodat2, leadstmpdat1, tinfoidx3, leadsidx4, leadsidx5, leadsidx3, tinfoidx1, leadstidx1, tinfoidx2, leadsidx1, tmpdat1 , leadstidx2, leadsidx2, logdbs1, logdbs2, logdbs3, logdbs4, logdbs5, logdbs6, logdbs7, phydbs (Requested Level 0). 2009-11-13 05:57:38 8077 8072 Begin level 0 backup rootdbs1. 2009-11-13 05:57:38 8077 8072 Successfully connected to Storage Manager. 2009-11-13 05:57:39 8077 8072 Completed level 0 backup rootdbs1 (Storage Manager copy ID: 23408 0). 2009-11-13 05:57:40 8094 8077 Process 8094 8077 successfully forked. 2009-11-13 05:57:40 8096 8077 Process 8096 8077 successfully forked. ........... ........... ........... 2009-11-13 06:02:43 8113 8077 Process 8113 8077 completed. 2009-11-13 06:02:43 8077 8072 Archive on rootdbs1, leadsdat1, leadsdat2, leadsdat3, leadsdat4, leadsdat5, tinfodat1, tinfo dat2, leadstmpdat1, tinfoidx3, leadsidx4, leadsidx5, leadsidx3, tinfoidx1, leadstidx1, tinfoidx2, leadsidx1, tmpdat1, leadst idx2, leadsidx2, logdbs1, logdbs2, logdbs3, logdbs4, logdbs5, logdbs6, logdbs7, phydbs Completed (Requested Level 0). 3. Drop a table 4. Took the system offline and Restore from the level 0 backup: onbar -r 5. Restoration completed successfully.. no error in bar_act.log 6. Dropped table is still missing in the database. Please help me to find any missing link. Let me know if any log or more information is required. Thanks. DJ.

DJ. onbar -r restaures the instance to the most recent possible time, so thedrop table statement is also "restored" when aplying logical-logs... andthe table is dropped again. This is the expected behaviour. If you want to recover the dropped table you can: Restore the complete instance to a point in time older than the "drop table" Restore only the dropped table using "archecker" Best regards, Javier Gómez IT Specialist Information Management Services - IBM Software Group C/ Santa Hortensia 26-28 28002 Madrid Tlf: 91 397 66 11 Fax: 91 519 39 87 From: "DHANANJAY KUMAR" <dhananjay_kumar2k@yahoo.com> To: ids@iiug.org Date: 13.11.2009 12:43 Subject: No able to restore. [18101] Sent by: ids-bounces@iiug.org I am doing ISM onbar backup-restore test in ISM Version 11.50.FC5. Steps i follow is as below: My database in logging and buffered mode. 1. onmode -lc (forced logical log and checkpoint) 2. onbar -b -L 0 (0 level backup)- below is extract of bar_act.log: 2009-11-13 05:41:27 4423 4418 /appl/informix/11.50_CERT/bin/onbar_d complete, returning 0 (0x00) 2009-11-13 05:57:37 8077 8072 /appl/informix/11.50_CERT/bin/onbar_d -b -L 0 2009-11-13 05:57:38 8077 8072 Archive started on rootdbs1, leadsdat1, leadsdat2, leadsdat3, leadsdat4, leadsdat5, tinfodat 1, tinfodat2, leadstmpdat1, tinfoidx3, leadsidx4, leadsidx5, leadsidx3, tinfoidx1, leadstidx1, tinfoidx2, leadsidx1, tmpdat1 , leadstidx2, leadsidx2, logdbs1, logdbs2, logdbs3, logdbs4, logdbs5, logdbs6, logdbs7, phydbs (Requested Level 0). 2009-11-13 05:57:38 8077 8072 Begin level 0 backup rootdbs1. 2009-11-13 05:57:38 8077 8072 Successfully connected to Storage Manager. 2009-11-13 05:57:39 8077 8072 Completed level 0 backup rootdbs1 (Storage Manager copy ID: 23408 0). 2009-11-13 05:57:40 8094 8077 Process 8094 8077 successfully forked. 2009-11-13 05:57:40 8096 8077 Process 8096 8077 successfully forked. ............ ............ ............ 2009-11-13 06:02:43 8113 8077 Process 8113 8077 completed. 2009-11-13 06:02:43 8077 8072 Archive on rootdbs1, leadsdat1, leadsdat2, leadsdat3, leadsdat4, leadsdat5, tinfodat1, tinfo dat2, leadstmpdat1, tinfoidx3, leadsidx4, leadsidx5, leadsidx3, tinfoidx1, leadstidx1, tinfoidx2, leadsidx1, tmpdat1, leadst idx2, leadsidx2, logdbs1, logdbs2, logdbs3, logdbs4, logdbs5, logdbs6, logdbs7, phydbs Completed (Requested Level 0). 3. Drop a table 4. Took the system offline and Restore from the level 0 backup: onbar -r 5. Restoration completed successfully.. no error in bar_act.log 6. Dropped table is still missing in the database. Please help me to find any missing link. Let me know if any log or more information is required. Thanks. DJ. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. Salvo indicado de otro modo más arriba / Unless stated otherwise above: International Business Machines, S.A. Santa Hortensia, 26-28, 28002 Madrid Registro Mercantil de Madrid; Folio 1; Tomo 1525; Hoja M-28146 CIF A28-010791

Hi, check the bar_act.log file to see what really was restored. I'm sure you will see that the logical logs also were restored, including the log file that contains the log record of the drop table. It should be a good example of how close we get with the restore to the "point of failure" (in your case when you took the server off-line). This is also due to the log salvage functionality. You can tell ON-Bar to restore only up to a specific point in time ("PIT restore"). Please read the manual for more information. 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 ids-bounces@iiug.org wrote on 11/13/2009 12:42:17 PM: > > I am doing ISM onbar backup-restore test in ISM Version 11.50.FC5. > > Steps i follow is as below: > > My database in logging and buffered mode. > > 1. onmode -lc (forced logical log and checkpoint) > > 2. onbar -b -L 0 (0 level backup)- below is extract of bar_act.log: > > 2009-11-13 05:41:27 4423 4418 /appl/informix/11.50_CERT/bin/ > onbar_d complete, > returning 0 (0x00) > 2009-11-13 05:57:37 8077 8072 /appl/informix/11.50_CERT/bin/onbar_d -b -L 0 > 2009-11-13 05:57:38 8077 8072 Archive started on rootdbs1, leadsdat1, > leadsdat2, leadsdat3, leadsdat4, leadsdat5, tinfodat > 1, tinfodat2, leadstmpdat1, tinfoidx3, leadsidx4, leadsidx5, leadsidx3, > tinfoidx1, leadstidx1, tinfoidx2, leadsidx1, tmpdat1 > , leadstidx2, leadsidx2, logdbs1, logdbs2, logdbs3, logdbs4, > logdbs5, logdbs6, > logdbs7, phydbs (Requested Level 0). > 2009-11-13 05:57:38 8077 8072 Begin level 0 backup rootdbs1. > 2009-11-13 05:57:38 8077 8072 Successfully connected to Storage Manager. > 2009-11-13 05:57:39 8077 8072 Completed level 0 backup rootdbs1 (Storage > Manager copy ID: 23408 0). > 2009-11-13 05:57:40 8094 8077 Process 8094 8077 successfully forked. > 2009-11-13 05:57:40 8096 8077 Process 8096 8077 successfully forked. > > ............ > ............ > ............ > > 2009-11-13 06:02:43 8113 8077 Process 8113 8077 completed. > 2009-11-13 06:02:43 8077 8072 Archive on rootdbs1, leadsdat1, leadsdat2, > leadsdat3, leadsdat4, leadsdat5, tinfodat1, tinfo > dat2, leadstmpdat1, tinfoidx3, leadsidx4, leadsidx5, leadsidx3, tinfoidx1, > leadstidx1, tinfoidx2, leadsidx1, tmpdat1, leadst > idx2, leadsidx2, logdbs1, logdbs2, logdbs3, logdbs4, logdbs5, logdbs6, > logdbs7, phydbs Completed (Requested Level 0). > > 3. Drop a table > > 4. Took the system offline and Restore from the level 0 backup: onbar -r > > 5. Restoration completed successfully.. no error in bar_act.log > > 6. Dropped table is still missing in the database. > > Please help me to find any missing link. Let me know if any log or more > information is required. > > Thanks. > DJ. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >