HELP - RESTORE A TABLE
Question: can a single table be recovered from an ontape -L 0 level-0 archive on IDS 7.31? Answer: no, not directly. The suggested workaround is to restore the old backup onto a separate system (or take a fresh archive, restore the old one, unload the table, then restore the current archive again) and reload the extracted data manually. The IIUG arcunload tool was mentioned but Art Kagel said it is unmaintained, built only for Solaris/IDS 7.1x. An IBM developer noted true Table Level Restore was planned for IDS 9.50.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Can one table be restored from a backup created with ontape -L 0 (On version
7.31UD)?
Silvana
In a word, no!
The only way would be to resore to a completely separate system and extract the
data then reload manually.
Alternatively,
1. archive current
2. restore old backup
3. extract data
4. restore current from 1.
5. load data from 3.
Keith
-----Original Message-----
From: Meza, Silvana [mailto:smeza@fheg.follett.com]
Sent: Thursday, September 23, 2004 15:40
To: ids@iiug.org
Subject: HELP - RESTORE A TABLE [3462]
Can one table be restored from a backup created with ontape -L 0 (On version
7.31UD)?
********************************************************************************
**
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
********************************************************************************
**
Check this out. I never used this, but may be
it helps.
http://www.iiug.org/software/arcunload/index.html
Simmons, Keith wrote:
>Silvana
>
>In a word, no!
>The only way would be to resore to a completely separate system and extract
the
>data then reload manually.
>Alternatively,
>1. archive current
>2. restore old backup
>3. extract data
>4. restore current from 1.
>5. load data from 3.
>
>Keith
>
>-----Original Message-----
>From: Meza, Silvana [mailto:smeza@fheg.follett.com]
>Sent: Thursday, September 23, 2004 15:40
>To: ids@iiug.org
>Subject: HELP - RESTORE A TABLE [3462]
>
>
>
>
>Can one table be restored from a backup created with ontape -L 0 (On version
>7.31UD)?
>
>
>
>*******************************************************************************
***
>This message is sent in strict confidence for the addressee only. It may
>contain legally privileged information. The contents are not to be disclosed
>to anyone other than the addressee. Unauthorised recipients are requested
>to preserve this confidentiality and to advise the sender immediately of any
>error in transmission.
>This footnote also confirms that this email message has been swept for the
>presence of computer viruses, however we cannot guarantee that this message
>is free from such problems.
>*******************************************************************************
***
>
>
>
>
--
Anil Menon
MIS Team.
I'll try till I die or die trying.
No good. Arcunload is VERY out-of-date and will not work with current
OS
releases or IDS versions. It was compiled on Sun/Solaris 7 for IDS 7.1x only.
It is no longer maintained and contained proprietary Informix source so we
cannot maintain it ongoing.
Art S. Kagel
----- Original Message -----
From: Anil Menon <anil@rhythm.com>
At: 9/24 4:51
Check this out. I never used this, but may be it helps.
http://www.iiug.org/software/arcunload/index.html
Simmons, Keith wrote:
>Silvana
>
>In a word, no!
>The only way would be to resore to a completely separate system and extract
the
>data then reload manually.
>Alternatively,
>1. archive current
>2. restore old backup
>3. extract data
>4. restore current from 1.
>5. load data from 3.
>
>Keith
>
>-----Original Message-----
>From: Meza, Silvana [mailto:smeza@fheg.follett.com]
>Sent: Thursday, September 23, 2004 15:40
>To: ids@iiug.org
>Subject: HELP - RESTORE A TABLE [3462]
>
>
>
>
>Can one table be restored from a backup created with ontape -L 0 (On version
>7.31UD)?
>
>
>
>*******************************************************************************
***
>This message is sent in strict confidence for the addressee only. It may
>contain legally privileged information. The contents are not to be disclosed
>to anyone other than the addressee. Unauthorised recipients are requested
>to preserve this confidentiality and to advise the sender immediately of any
>error in transmission.
>This footnote also confirms that this email message has been swept for the
>presence of computer viruses, however we cannot guarantee that this message
>is free from such problems.
>*******************************************************************************
***
>
>
>
>
--
Anil Menon
MIS Team.
I'll try till I die or die trying.
This would be an awsome tool... I had some times when I prayed for a tool like
this...
Is there aay way/tool to do this on 9.3/9.4
Chucho!
-----Original Message-----
From: "ART KAGEL, ...." <KAGEL@bloomberg.net>
To: ids@iiug.org
Date: Fri, 24 Sep 2004 08:39:58 -0400 (EDT)
Subject: Fwd: Re: HELP - RESTORE A TABLE [3473]
No good. Arcunload is VERY out-of-date and will not work with current OS
releases or IDS versions. It was compiled on Sun/Solaris 7 for IDS 7.1x only.
It is no longer maintained and contained proprietary Informix source so we
cannot maintain it ongoing.
Art S. Kagel
----- Original Message -----
From: Anil Menon <anil@rhythm.com>
At: 9/24 4:51
Check this out. I never used this, but may be it helps.
http://www.iiug.org/software/arcunload/index.html
Simmons, Keith wrote:
>Silvana
>
>In a word, no!
>The only way would be to resore to a completely separate system and extract
the
>data then reload manually.
>Alternatively,
>1. archive current
>2. restore old backup
>3. extract data
>4. restore current from 1.
>5. load data from 3.
>
>Keith
>
>-----Original Message-----
>From: Meza, Silvana [mailto:smeza@fheg.follett.com]
>Sent: Thursday, September 23, 2004 15:40
>To: ids@iiug.org
>Subject: HELP - RESTORE A TABLE [3462]
>
>
>
>
>Can one table be restored from a backup created with ontape -L 0 (On version
>7.31UD)?
>
>
>
>*******************************************************************************
***
>This message is sent in strict confidence for the addressee only. It may
>contain legally privileged information. The contents are not to be disclosed
>to anyone other than the addressee. Unauthorised recipients are requested
>to preserve this confidentiality and to advise the sender immediately of any
>error in transmission.
>This footnote also confirms that this email message has been swept for the
>presence of computer viruses, however we cannot guarantee that this message
>is free from such problems.
>*******************************************************************************
***
>
>
>
>
--
Anil Menon
MIS Team.
I'll try till I die or die trying.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
THANKS
EVERYONE!
I just want to thank everyone for their input...
It's conferring to know that you're out there and willing to help.
Silvana :)
-----Original Message-----
From: ART KAGEL, .... [mailto:KAGEL@bloomberg.net]
Sent: Friday, September 24, 2004 7:40 AM
To: ids@iiug.org
Subject: Fwd: Re: HELP - RESTORE A TABLE [3473]
No good. Arcunload is VERY out-of-date and will not work with current OS
releases or IDS versions. It was compiled on Sun/Solaris 7 for IDS 7.1x
only.
It is no longer maintained and contained proprietary Informix source so we
cannot maintain it ongoing.
Art S. Kagel
----- Original Message -----
From: Anil Menon <anil@rhythm.com>
At: 9/24 4:51
Check this out. I never used this, but may be it helps.
http://www.iiug.org/software/arcunload/index.html
Simmons, Keith wrote:
>Silvana
>
>In a word, no!
>The only way would be to resore to a completely separate system and extract
the
>data then reload manually.
>Alternatively,
>1. archive current
>2. restore old backup
>3. extract data
>4. restore current from 1.
>5. load data from 3.
>
>Keith
>
>-----Original Message-----
>From: Meza, Silvana [mailto:smeza@fheg.follett.com]
>Sent: Thursday, September 23, 2004 15:40
>To: ids@iiug.org
>Subject: HELP - RESTORE A TABLE [3462]
>
>
>
>
>Can one table be restored from a backup created with ontape -L 0 (On
version
>7.31UD)?
>
>
>
>***************************************************************************
****
***
>This message is sent in strict confidence for the addressee only. It may
>contain legally privileged information. The contents are not to be
disclosed
>to anyone other than the addressee. Unauthorised recipients are requested
>to preserve this confidentiality and to advise the sender immediately of
any
>error in transmission.
>This footnote also confirms that this email message has been swept for the
>presence of computer viruses, however we cannot guarantee that this message
>is free from such problems.
>***************************************************************************
****
***
>
>
>
>
--
Anil Menon
MIS Team.
I'll try till I die or die trying.
Just for that I migrate to 9.5, well, and for the rest of new features of
course.
Chucho!
-----Original Message-----
From: Martin Fuerderer <MARTINFU@de.ibm.com>
To: "Jean Sagi" <jeansagi@myrealbox.com>
Date: Fri, 24 Sep 2004 17:35:59 +0200
Subject: Re: Fwd: Re: HELP - RESTORE A TABLE [3474]
Hi,
there's not. :-(
But there will be with the upcoming 9.50. :))
(So called TLR - Table Level Restore)
Sorry for the waiting,
Martin
--
Martin Fuerderer
IBM Informix Development Munich
Data Management Solutions
"Jean Sagi" <jeansagi@myrealbox.com>
Sent by: forum.subscriber@iiug.org
24.09.2004 15:36
To
ids@iiug.org
cc
Subject
Re: Fwd: Re: HELP - RESTORE A TABLE [3474]
This would be an awsome tool... I had some times when I prayed for a tool
like this...
Is there aay way/tool to do this on 9.3/9.4
Chucho!
-----Original Message-----
From: "ART KAGEL, ...." <KAGEL@bloomberg.net>
To: ids@iiug.org
Date: Fri, 24 Sep 2004 08:39:58 -0400 (EDT)
Subject: Fwd: Re: HELP - RESTORE A TABLE [3473]
No good. Arcunload is VERY out-of-date and will not work with current OS
releases or IDS versions. It was compiled on Sun/Solaris 7 for IDS 7.1x
only.
It is no longer maintained and contained proprietary Informix source so we
cannot maintain it ongoing.
Art S. Kagel
----- Original Message -----
From: Anil Menon <anil@rhythm.com>
At: 9/24 4:51
Check this out. I never used this, but may be it helps.
http://www.iiug.org/software/arcunload/index.html
Simmons, Keith wrote:
>Silvana
>
>In a word, no!
>The only way would be to resore to a completely separate system and
extract the
>data then reload manually.
>Alternatively,
>1. archive current
>2. restore old backup
>3. extract data
>4. restore current from 1.
>5. load data from 3.
>
>Keith
>
>-----Original Message-----
>From: Meza, Silvana [mailto:smeza@fheg.follett.com]
>Sent: Thursday, September 23, 2004 15:40
>To: ids@iiug.org
>Subject: HELP - RESTORE A TABLE [3462]
>
>
>
>
>Can one table be restored from a backup created with ontape -L 0 (On
version
>7.31UD)?
>
>
>
>*******************************************************************************
***
>This message is sent in strict confidence for the addressee only. It may
>contain legally privileged information. The contents are not to be
disclosed
>to anyone other than the addressee. Unauthorised recipients are requested
>to preserve this confidentiality and to advise the sender immediately of
any
>error in transmission.
>This footnote also confirms that this email message has been swept for
the
>presence of computer viruses, however we cannot guarantee that this
message
>is free from such problems.
>*******************************************************************************
***
>
>
>
>
--
Anil Menon
MIS Team.
I'll try till I die or die trying.
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com
Jean Sagi
jeansagi@myrealbox.com
jeansagi@yahoo.com