IDS Forum

Re: Restoring Ontape to a different instan....

Posted By: Marcus Haarmann
Date: Friday, 8 July 2016, at 3:15 p.m.

In Response To: Re: Fw: Restoring Ontape to a different instan.... (LARRY SORENSEN)

Hi, you could also restore the whole instance (in case you have enough space, and it
works without scripting.)
To do this on the same machine, you have to have a location for each chunk and
do the restore with chunk rename options. See ontape -r -rename option.
Then you get the state of the database when your backup was taken (I suspect
you have to recover historical values).

Since archecker has to work through the whole backup, there is no big difference
in execution time for both options.

Marcus Haarmann

----- Ursprüngliche Mail -----

Von: "LARRY SORENSEN" <LSORENSEN25@msn.com>
An: ids@iiug.org
Gesendet: Freitag, 8. Juli 2016 20:57:26
Betreff: Re: Fw: Restoring Ontape to a different instan.... [37407]

So, doing as you show below, I just have to make sure that I have my
environment variables pointing to the new instance and the database created
and populated with chunks, and I am good to go?

Larry

________________________________
From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
<art.kagel@gmail.com>
Sent: Friday, July 8, 2016 12:40 PM
To: ids@iiug.org
Subject: Re: Fw: Restoring Ontape to a different instan.... [37405]

Oops. So the schema file will look something like this when complete:

DATABASE original;
CREATE TABLE tbl_1 (

one INT;

two CHAR(100);
) IN dbs1;
CREATE TABLE tbl_2 (

one INT;

two CHAR(100);
) IN dbs1;

DATABASE copy;
CREATE TABLE tbl_1 (

one INT;

two CHAR(100);
) IN dbs2;
CREATE TABLE tbl_2 (

one INT;

two CHAR(100);
) IN dbs2;

INSERT INTO copy:tbl_1 SELECT * FROM original:tbl_1;
INSERT INTO copy:tbl_2 SELECT * FROM original:tbl_2;

You can create the empty tables before the archecker run or rely on
archecker to create them for you. IB that the database has to exist already
though, it's not clear in the manual and I've only used it to restore to an
existing database myself.

Art

Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com<http://www.askdbmgt.com>

ASK Database Management - Home<http://www.askdbmgt.com/>
www.askdbmgt.com
This is the site for Art S. Kagel's consultancy. The soaring majesty and
beauty in the image above hides the complex ecology and detail of its
existence.

Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.

On Fri, Jul 8, 2016 at 2:34 PM, Art Kagel <art.kagel@gmail.com> wrote:

> The only way to restore a whole database using archecker is to include
> source database and table schema, target database and schema, and an insert
> into ... select * from statement for each table. It's not hard to write an
> awk or perl script to read a dbschema/myschema output file and create the
> required command file.
>
> Art
>
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com<http://www.askdbmgt.com>
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on the IIUG, nor any other organization with which I am
> associated either explicitly, implicitly, or by inference. Neither do
> those opinions reflect those of other individuals affiliated with any
> entity with which I am affiliated nor those of the entities themselves.
>
>
> On Fri, Jul 8, 2016 at 2:01 PM, LARRY SORENSEN <LSORENSEN25@msn.com>
> wrote:
>
>> So, if I have, let's say 100+ tables, is this going to be very tedious,
>> or is
>> there a way to specify an entire database?
>>
>> Larry
>>
>> ________________________________
>> From: ids-bounces@iiug.org <ids-bounces@iiug.org> on behalf of Art Kagel
>> <art.kagel@gmail.com>
>> Sent: Friday, July 8, 2016 11:43 AM
>> To: ids@iiug.org
>> Subject: Re: Fw: Restoring Ontape to a different instan.... [37400]
>>
>> Ahh, so, ypu don't wamt to restore to create a new instance on the same
>> host, but to restore a database from an archive to a different running
>> instance? Correct?
>>
>> You do that with archecker. Look int the Backup and Restore Guide or the
>> Infocenter for details.
>>
>> Art
>>
>> On Jul 8, 2016 13:30, "LARRY SORENSEN" <LSORENSEN25@msn.com> wrote:
>>
>> > Also, to add a little more information, the new dbspace already exists
>> in
>> > the
>> > other instance and is populated with chunks. I only want to restore one
>> of
>> > the
>> > databases in the archive if possible.
>> >
>> > Larry
>> >
>> > ________________________________
>> > From: LARRY SORENSEN
>> > Sent: Friday, July 8, 2016 11:21 AM
>> > To: ids@iiug.org
>> > Subject: Restoring Ontape to a different instance on the same computer
>> >
>> > Solaris 10
>> >
>> > IDS 11.50.FC7
>> >
>> > I know I have seen this before, but I can't find where I may have saved
>> the
>> > information.
>> >
>> > What is the easiest way to restore an ontape backup to a different
>> > instance on
>> > the same computer? Are there any steps that someone may have typed up
>> > before
>> > that you can share?
>> >
>> > Larry
>> >
>> >
>> >
>> >
>>
>>
>>

*******************************************************************************
>> > Forum Note: Use "Reply" to post a response in the discussion forum.
>> >
>> >
>>
>> --94eb2c05f87e54093f05372358bd
>>
>>
>>
>>

*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>>

*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>

--001a1144b7d056eef20537242491

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Fw: Restoring Ontape to a different instance on th
  LARRY SORENSEN -- Friday, 8 July 2016, at 1:30 p.m.
  • Re: Restoring Ontape to a different instance o....
    Kern Doe -- Friday, 8 July 2016, at 1:38 p.m.
  • Re: Fw: Restoring Ontape to a different instance o
    Art Kagel -- Friday, 8 July 2016, at 1:43 p.m.
    • Re: Fw: Restoring Ontape to a different instan....
      LARRY SORENSEN -- Friday, 8 July 2016, at 1:52 p.m.
    • Re: Fw: Restoring Ontape to a different instan....
      LARRY SORENSEN -- Friday, 8 July 2016, at 2:01 p.m.
      • Re: Fw: Restoring Ontape to a different instan....
        Art Kagel -- Friday, 8 July 2016, at 2:35 p.m.
        • Re: Fw: Restoring Ontape to a different instan....
          LARRY SORENSEN -- Friday, 8 July 2016, at 2:51 p.m.
      • Re: Fw: Restoring Ontape to a different instan....
        Art Kagel -- Friday, 8 July 2016, at 2:40 p.m.
        • Re: Fw: Restoring Ontape to a different instan....
          LARRY SORENSEN -- Friday, 8 July 2016, at 2:57 p.m.
          • Re: Restoring Ontape to a different instan....
            Marcus Haarmann -- Friday, 8 July 2016, at 3:15 p.m.
          • Re: Fw: Restoring Ontape to a different instan....
            Art Kagel -- Friday, 8 July 2016, at 3:40 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.