Recovering a single table from an ontape archive

We create a backup of our Informix databases every night using ontape. This is great for recovering the entire instance but we are in the situation where we want to recover a single table from an earlier backup. We have a test machine that I hoped I could restore the archive to and extract the table but I'm running into problems. Is there a way to restore an ontape archive to another node without having to totally duplicate the original system including the node name? (ontape -r -rename... is not enough to make this work ) We would like to run exports to avoid this situation but the drawback is that you need exclusive access to a database to be able to export it. Since we have clients on the other side of the world that access the databases at night this gets a bit tricky. Thanks, Stewart CONFIDENTIAL AND PRIVILEGED INFORMATION NOTICE This e-mail, and any attachments, may contain information that is confidential, subject to copyright, or exempt from disclosure. Any unauthorized review, disclosure, retransmission, dissemination or other use of or reliance on this information may be unlawful and is strictly prohibited. AVIS D'INFORMATION CONFIDENTIELLE ET PRIVILIGIIE Le prisent courriel, et toute pihce jointe, peut contenir de l'information qui est confidentielle, rigie par les droits d'auteur, ou interdite de divulgation. Tout examen, divulgation, retransmission, diffusion ou autres utilisations non autorisies de l'information ou dipendance non autorisie envers celle-ci peut jtre illigale et est strictement interdite.

It looks like a good reason to upgrade to IDS 10.0 There you have the possibility not only to restore a table, you could also restore single rows by a sql expression. J. Attlesey, S.... escribis: > We create a backup of our Informix databases every night using ontape. This > is great for recovering the entire instance but we are in the situation > where we want to recover a single table from an earlier backup. We have a > test machine that I hoped I could restore the archive to and extract the > table but I'm running into problems. Is there a way to restore an ontape > archive to another node without having to totally duplicate the original > system including the node name? (ontape -r -rename... is not enough to make > this work ) > > We would like to run exports to avoid this situation but the drawback is > that you need exclusive access to a database to be able to export it. Since > we have clients on the other side of the world that access the databases at > night this gets a bit tricky. > > Thanks, > Stewart > CONFIDENTIAL AND PRIVILEGED INFORMATION NOTICE > > This e-mail, and any attachments, may contain information that > is confidential, subject to copyright, or exempt from disclosure. > Any unauthorized review, disclosure, retransmission, > dissemination or other use of or reliance on this information > may be unlawful and is strictly prohibited. > > AVIS D'INFORMATION CONFIDENTIELLE ET PRIVILIGIIE > > Le prisent courriel, et toute pihce jointe, peut contenir de > l'information qui est confidentielle, rigie par les droits > d'auteur, ou interdite de divulgation. Tout examen, > divulgation, retransmission, diffusion ou autres utilisations > non autorisies de l'information ou dipendance non autorisie > envers celle-ci peut jtre illigale et est strictement interdite.

On 16 Sep 2005 at 14:47, Attlesey, S.... wrote: > We create a backup of our Informix databases every night using ontape. This > is great for recovering the entire instance but we are in the situation > where we want to recover a single table from an earlier backup. We have a > test machine that I hoped I could restore the archive to and extract the > table but I'm running into problems. Is there a way to restore an ontape > archive to another node without having to totally duplicate the original > system including the node name? (ontape -r -rename... is not enough to make > this work ) I've been able to do this with IDS 7.31 where the production server was a quad processor with a lot of memory and the recovery system was a single processor with not so much memory. You need to be on the same version of Informix and the same OS version. You can twiddle the settings in the ONCONFIG file to match to reduced capabilities of the recovery machine without it affecting the restore. But you can't change at all the dataspace locations. They must be in exact same location on the recovery server as the production server. I did not try changing the instance name. As long as the production and recovery machines are on different servers, they shouldn't bump into each other. Basically setup the recovery server as if it were the only Informix server on the network. Then you should be able to restore and pull the info you need form the recovery server. Charles Rutledge Centauri Computer Works centauri@pobox.com

Depending on your IDS version this might be feasible. there is an archecker 4s option to restore a table from an archive and also there was an old utility to sort this problem out for version 7.2. I 4d suggest you to raise a case with IBM tech support. HTH, esteban.- Attlesey, S.... wrote: > We create a backup of our Informix databases every night using ontape. This > is great for recovering the entire instance but we are in the situation > where we want to recover a single table from an earlier backup. We have a > test machine that I hoped I could restore the archive to and extract the > table but I'm running into problems. Is there a way to restore an ontape > archive to another node without having to totally duplicate the original > system including the node name? (ontape -r -rename... is not enough to make > this work ) > > We would like to run exports to avoid this situation but the drawback is > that you need exclusive access to a database to be able to export it. Since > we have clients on the other side of the world that access the databases at > night this gets a bit tricky. > > Thanks, > Stewart > CONFIDENTIAL AND PRIVILEGED INFORMATION NOTICE > > This e-mail, and any attachments, may contain information that > is confidential, subject to copyright, or exempt from disclosure. > Any unauthorized review, disclosure, retransmission, > dissemination or other use of or reliance on this information > may be unlawful and is strictly prohibited. > > AVIS D'INFORMATION CONFIDENTIELLE ET PRIVILIGIIE > > Le prisent courriel, et toute pihce jointe, peut contenir de > l'information qui est confidentielle, rigie par les droits > d'auteur, ou interdite de divulgation. Tout examen, > divulgation, retransmission, diffusion ou autres utilisations > non autorisies de l'information ou dipendance non autorisie > envers celle-ci peut jtre illigale et est strictement interdite. > > ___________________________________________________________ 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor correo web del mundo http://correo.yahoo.com.ar

Have you tried archecker? it's an unsupported utility until v10, but should work in most cases. Take a look at http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.bar.d oc/barmst334.htm Esteban Cas.... wrote: > Depending on your IDS version this might be feasible. > > there is an archecker 4s option to restore a table from an archive and > also there was an old utility to sort this problem out for version 7.2. > > I 4d suggest you to raise a case with IBM tech support. > > HTH, > esteban.- > > Attlesey, S.... wrote: > >>We create a backup of our Informix databases every night using ontape. This >>is great for recovering the entire instance but we are in the situation >>where we want to recover a single table from an earlier backup. We have a >>test machine that I hoped I could restore the archive to and extract the >>table but I'm running into problems. Is there a way to restore an ontape >>archive to another node without having to totally duplicate the original >>system including the node name? (ontape -r -rename... is not enough to make >>this work ) >> >>We would like to run exports to avoid this situation but the drawback is >>that you need exclusive access to a database to be able to export it. Since >>we have clients on the other side of the world that access the databases at >>night this gets a bit tricky. >> >>Thanks, >>Stewart >>CONFIDENTIAL AND PRIVILEGED INFORMATION NOTICE >> >>This e-mail, and any attachments, may contain information that >>is confidential, subject to copyright, or exempt from disclosure. >>Any unauthorized review, disclosure, retransmission, >>dissemination or other use of or reliance on this information >>may be unlawful and is strictly prohibited. >> >>AVIS D'INFORMATION CONFIDENTIELLE ET PRIVILIGIIE >> >>Le prisent courriel, et toute pihce jointe, peut contenir de >>l'information qui est confidentielle, rigie par les droits >>d'auteur, ou interdite de divulgation. Tout examen, >>divulgation, retransmission, diffusion ou autres utilisations >>non autorisies de l'information ou dipendance non autorisie >>envers celle-ci peut jtre illigale et est strictement interdite. >> >> > > > > > > > ___________________________________________________________ > 1GB gratis, Antivirus y Antispam > Correo Yahoo!, el mejor correo web del mundo > http://correo.yahoo.com.ar > > -- Josi Luis Matute Martmnez Responsable Divisisn Sistemas Contacto Local del Grupo de Usuarios de Informix en Espaqa D&D Grupo Dydes Poligono EUROPOLIS Edif. Al Andalus Calle X, n: 4 y 6 28230 Las Rozas (Madrid) Tf: +34 91 6407080 Fax: +34 91 6373280