IDS Forum

Re: help me to clearify few of the points

Posted By: Art Kagel
Date: Thursday, 22 October 2009, at 10:36 a.m.

In Response To: help me to clearify few of the points (DEEPAK JOSHI)

OK, there's something you are missing, that being the intent of ontape/onbar
archives. The intent is to take an image of the current server instance's
disk space so that in case of disaster the server can be resurrected using
the archive to restore its disk image.

Yes, you can restore the image to a different machine. This is permitted in
case there is a catastrophic hardware failure requiring the installation of
the archive on a new machine. However, for all releases prior to IDS 10.00,
all of the disk chunk paths that were present in the archive file/tape must
exist and be at least as large as the original file/device was. That is
why, though you may not know it, most IDS DBAs use symbolic links for the
chunk paths so that if a restore to a different machine or to different
storage structures on the same machine is required, then the links can just
be rebuilt on the new machine (or on the same machine pointing to the new
storage) and poof, everything works.

In the newest releases (10.00, 11.10, & 11.50) it is possible to restore the
chunks to a different path, to effectively 'rename' the chunks during the
restore operation, but you are using and older release without this
capability IIRC. Even so, the newest releases still will not allow you to
restore a dbspace from one server to another.

What you seem to want to do, however, is to copy a dbspace from one server
to another existing server from an archive that was taken on the first
server. This you cannot do. If you need to port data from one server to
another, you have many options. Restore from an archive is not one of them.

One option is not open to you. In newer versions of IDS (again 10.00 and
later), you can use the archecker utility to extract data from an archive
and insert it into tables in an existing database on any server. However,
the older version of archecker which you have does not have this capability
IB (John, can you comment on that?)

The other options are as follows and some are documented in the Migration
Guide manual:

- dbexport the database on one server and dbimport it onto the other

server.

- This will extract and recreate an entire database, not be dbspace.

- You can also use my dbexport/dbimport replacement utility package,

myexport, which you can download from the IIUG Software Repository (also

download my utils2_ak package, Jonathan Leffler's sqlcmd package and Ravi

Krishna's myonpload package which myexport/myimport require)

- Use the High Performance Loader to extract data for one or more

tables, recreate the table(s) on the other server and use the HP Loader to

reload the data. The HP Loader has its own manual.

- Note that myexport (see above) can optionally use the HP Loader -

via myonpload - to run quite a bit faster without you needing to
know how to

set up an HP Loader job

- You can also use the myonpload utility manually for the same

reasons.

- Copy the data directly from one server to the other.

- This can be done in dbaccess (or sqlcmd) using INSERT INTO <remote

table> ... SELECT FROM <local table>...;

- You can use my dbcopy utility which is much faster copying between

two servers than dbaccess or sqlcmd. (Dbcopy is in the
utils2_ak package).

- Write scripts yourself to extract the data using dbaccess (UNLOAD

TO) and reload it (LOAD FROM) the same way or using dbload (documented in

the Migration Guide).

Art

Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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 Thu, Oct 22, 2009 at 9:30 AM, DEEPAK JOSHI <djoshih@hotmail.com> wrote:

> Hi All,
>
> Please help me to clear below points.
>
> 1. If we have an ontape level 0 backup, can't we restore this on another
> server if we don't have identical raw device structure over there? Although
> size of logical volume is same.
>
> 2.We only can do full restore on the system from which level 0 were backed
> up,
> Is it true?
>
> 3. How can I do a restore of few of the dbspaces from level 0 backup.
>
> I am trying using the command below.
>
> ontape -r -D sabledbs_6? is it right
>
> I have created an xxxxx dbspace similar to which in level 0 archive on the
> new
> server but still I am getting few of the errors.
>
> Physical restore failed - Archive API error: on open
>
> Program over.
>
> What else I have do in order to restore few of the dbspace from level 0
> backup.
>
> Please guide me, as I am new to informix.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--00235453092867043c047687056a

Messages In This Thread

• help me to clearify few of the points
  DEEPAK JOSHI -- Thursday, 22 October 2009, at 9:30 a.m.
  • Re: help me to clearify few of the points
    Keith Simmons -- Thursday, 22 October 2009, at 10:11 a.m.
  • Re: help me to clearify few of the points
    Gustavo Castro -- Thursday, 22 October 2009, at 10:36 a.m.
    • Re: help me to clearify few of the points
      Jonathan Leffler -- Thursday, 22 October 2009, at 10:42 p.m.
  • Re: help me to clearify few of the points
    Art Kagel -- Thursday, 22 October 2009, at 10:36 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.