HELP! Table level restore

Posted in 2008

Robert Roussey(IT) — Sat, 19 Jan 2008 00:12:22 — 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 — Sat, 19 Jan 2008 00:42:10 — 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) — Sat, 19 Jan 2008 00:56:21 — 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 — Sat, 19 Jan 2008 01:14:46 — 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) — Sat, 19 Jan 2008 01:18:11 — 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!!