Oninit cdi / Archive
Talk to an expert →

HELP! Table level restore

Posted in 2008

Summary

Robert Roussey's filtered table-level restore failed with 'Table db1_4 not found in dictionary'. John Miller said both source and target tables need create table statements in the archecker command file. Roussey found he had omitted the create for the existing table. Miller added that the source table needs its dbspace list but not index definitions. Solved.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Server Administration

Robert Roussey(IT) — — source: IIUG Forums & Mailing Lists

Trying to do a (filtered) TLR. In the ac.log, I'm getting the following error message: TIME: [2008-01-18 19:06:06] All old validation files removed. STATUS: Dropping old log control tables ERROR: Table "db1_4" not found in dictionary STATUS: Restore disabled for maintprod:db1_4 into maintprod:db1_4_a CRITICAL ERROR: Unable to continue -- no tables to restore. STATUS: archecker completed Physical Restore pid = 31978 exit code: 3 The table 'db1_4' is there, I dumped the schema with dbschema. What doesn't it like? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980

↪ replying to Robert Roussey(IT)
John Miller iii — — source: IIUG Forums & Mailing Lists

I am not sure what your command file looks like, but you should make sure that both tables db1_4 and db1_4_a have create table statements defined for database maintprod. John = "Robert = Roussey(IT)" = <Robert.Roussey@S = To piritAir.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect HELP! Table level restore [1100= 1] = 01/18/2008 04:12 = PM = = = Please respond to = ids@iiug.org = = = Trying to do a (filtered) TLR. In the ac.log, I'm getting the following error message: TIME: [2008-01-18 19:06:06] All old validation files removed. STATUS: Dropping old log control tables ERROR: Table "db1_4" not found in dictionary STATUS: Restore disabled for maintprod:db1_4 into maintprod:db1_4_a CRITICAL ERROR: Unable to continue -- no tables to restore. STATUS: archecker completed Physical Restore pid =3D 31978 exit code: 3= The table 'db1_4' is there, I dumped the schema with dbschema. What doesn't it like? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =

↪ replying to John Miller iii
Robert Roussey(IT) — — source: IIUG Forums & Mailing Lists

Bingo, missed 'create' for the existing table. - do I need the "in dbspace" for the original table? - do I need "create index ...." for the original table? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Friday, January 18, 2008 7:42 PM To: ids@iiug.org Subject: Re: HELP! Table level restore [11003] I am not sure what your command file looks like, but you should make sure that both tables db1_4 and db1_4_a have create table statements defined for database maintprod. John = "Robert = Roussey(IT)" = <Robert.Roussey@S = To piritAir.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect HELP! Table level restore [1100= 1] = 01/18/2008 04:12 = PM = = = Please respond to = ids@iiug.org = = = Trying to do a (filtered) TLR. In the ac.log, I'm getting the following error message: TIME: [2008-01-18 19:06:06] All old validation files removed. STATUS: Dropping old log control tables ERROR: Table "db1_4" not found in dictionary STATUS: Restore disabled for maintprod:db1_4 into maintprod:db1_4_a CRITICAL ERROR: Unable to continue -- no tables to restore. STATUS: archecker completed Physical Restore pid =3D 31978 exit code: 3= The table 'db1_4' is there, I dumped the schema with dbschema. What doesn't it like? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! = ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

↪ replying to Robert Roussey(IT)
John Miller iii — — source: IIUG Forums & Mailing Lists

For the table that is on the archive you do need the dbspace list. If = you are using onbar, then only the dbspaces in the fragment list are scanne= d. For the table that is on the archive you do not need the index definiti= ons, TLR only requires the table name, column layout and the fragment information (actually on the dbspace names, it does not care about the expression). Hope this helps, John Miller = "Robert = Roussey(IT)" = <Robert.Roussey@S = To piritAir.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect RE: HELP! Table level restore = [11004] = 01/18/2008 04:56 = PM = = = Please respond to = ids@iiug.org = = = Bingo, missed 'create' for the existing table. - do I need the "in dbspace" for the original table? - do I need "create index ...." for the original table? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Friday, January 18, 2008 7:42 PM To: ids@iiug.org Subject: Re: HELP! Table level restore [11003] I am not sure what your command file looks like, but you should make sure that both tables db1_4 and db1_4_a have create table statements defined for database maintprod. John =3D "Robert =3D Roussey(IT)" =3D <Robert.Roussey@S =3D To piritAir.com> ids@iiug.org =3D Sent by: =3D cc ids-bounces@iiug. =3D org Subj=3D ect HELP! Table level restore [1100=3D 1] =3D 01/18/2008 04:12 =3D PM =3D =3D =3D Please respond to =3D ids@iiug.org =3D =3D =3D Trying to do a (filtered) TLR. In the ac.log, I'm getting the following error message: TIME: [2008-01-18 19:06:06] All old validation files removed. STATUS: Dropping old log control tables ERROR: Table "db1_4" not found in dictionary STATUS: Restore disabled for maintprod:db1_4 into maintprod:db1_4_a CRITICAL ERROR: Unable to continue -- no tables to restore. STATUS: archecker completed Physical Restore pid =3D3D 31978 exit code:= 3=3D The table 'db1_4' is there, I dumped the schema with dbschema. What doesn't it like? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 ***********************************************************************= =3D ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =3D ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =

↪ replying to John Miller iii
Robert Roussey(IT) — — source: IIUG Forums & Mailing Lists

Great! Tried RTFM some more and found it there too; it worked! Thank you sir! Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Friday, January 18, 2008 8:15 PM To: ids@iiug.org Subject: RE: HELP! Table level restore [11005] For the table that is on the archive you do need the dbspace list. If = you are using onbar, then only the dbspaces in the fragment list are scanne= d. For the table that is on the archive you do not need the index definiti= ons, TLR only requires the table name, column layout and the fragment information (actually on the dbspace names, it does not care about the expression). Hope this helps, John Miller = "Robert = Roussey(IT)" = <Robert.Roussey@S = To piritAir.com> ids@iiug.org = Sent by: = cc ids-bounces@iiug. = org Subj= ect RE: HELP! Table level restore = [11004] = 01/18/2008 04:56 = PM = = = Please respond to = ids@iiug.org = = = Bingo, missed 'create' for the existing table. - do I need the "in dbspace" for the original table? - do I need "create index ...." for the original table? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John Miller iii Sent: Friday, January 18, 2008 7:42 PM To: ids@iiug.org Subject: Re: HELP! Table level restore [11003] I am not sure what your command file looks like, but you should make sure that both tables db1_4 and db1_4_a have create table statements defined for database maintprod. John =3D "Robert =3D Roussey(IT)" =3D <Robert.Roussey@S =3D To piritAir.com> ids@iiug.org =3D Sent by: =3D cc ids-bounces@iiug. =3D org Subj=3D ect HELP! Table level restore [1100=3D 1] =3D 01/18/2008 04:12 =3D PM =3D =3D =3D Please respond to =3D ids@iiug.org =3D =3D =3D Trying to do a (filtered) TLR. In the ac.log, I'm getting the following error message: TIME: [2008-01-18 19:06:06] All old validation files removed. STATUS: Dropping old log control tables ERROR: Table "db1_4" not found in dictionary STATUS: Restore disabled for maintprod:db1_4 into maintprod:db1_4_a CRITICAL ERROR: Unable to continue -- no tables to restore. STATUS: archecker completed Physical Restore pid =3D3D 31978 exit code:= 3=3D The table 'db1_4' is there, I dumped the schema with dbschema. What doesn't it like? Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com Office: 248.727.2620 Cell: 586.838.8980 ***********************************************************************= =3D ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! =3D ***********************************************************************= * ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!! = ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!