IDS Forum

Re: External Restoration

Posted By: Peter_Logan@spartanstores.com
Date: Wednesday, 4 February 2009, at 8:25 a.m.

In Response To: Re: External Restoration (Art Kagel)

he's talking about the ROOTPATH in the onconfig file ... That has to be
set to the original location in the target file ... the rename will then
change it ..

Peter Logan
Senior Database Administrator
Phone: 616/878-8309

From:
"Art Kagel" <art.kagel@gmail.com>
To:
ids@iiug.org
Date:
02/04/2009 06:51 AM
Subject:
Re: External Restoration [14728]
Sent by:
ids-bounces@iiug.org

No. I don't know what Kenneth is referring to. Ontape does NOT need to
know about the original root db space. You can set that to anything you
want as long as you are including a rename clause for that particular
chunk.

Art

On Wed, Feb 4, 2009 at 3:50 AM, VIKAS HIVARKAR
<vikas.hivarkar@gmail.com>wrote:

> Kenneth, Art. Thanks for the help !
>
> one query:
>
> --- In the ONCONFIG of the target ensure that the rootdbs is pointing to

> the
> root chunk of the source (otherwise restore fails)----
>
> Does it mean, we would be restoring the level 0 backup of one instance
to
> itself but at new place?
>
> Regards,
> Vikas.
>
>
>
------------------------------------------------------------------------------

>
> You can indeed use a backup and restore. IDS 11.10 and later allow you
to
> rename the chunks at restore time. Just make sure that either the
original
> server is offline, or that the new server has a different SERVERNUM and
> SERVERNAME in its ONCONFIG file than the existing one.
>
> Art
>
>
>
------------------------------------------------------------------------------

> Vikas,
>
> You need to perform an ontape backup with chunk rename. I am
> assuming that you have correctly setup the onconfig of the destination.
> Here ensure that the servernum of the source and destination are
> different. Create a text file with the following structure, called
> dest_rename.
> <chunk name in source> <chunk offset> <chunk name in destination> <chunk

> offset in destination>
>
> Ensure that you include all the chunks here as otherwise you might end
> up overwriting the live db.
>
> On both the source database and destination set the tape dev to STDIO.
> In the ONCONFIG of the target ensure that the rootdbs is pointing to the

> root chunk of the source (otherwise restore fails)
> Assuming you have an env file for the source Informix instance called
> src.env and one for the destination Informix instance called dest.env.
> If the destination chunks are files, pre-create them by just touching
> them and set the appropriate permissions, chmod 0660 informix:Informix
> <files>
>
> Run
> $ . src.env
> $ ontape -s -L 0 | (. dest.env; ontape -r -rename -f <full path to the
> file created with the rename details as indicated above>)
>
> After it finishes the destination will be in quiescent mode.
>
> BTW, you can use ontape instead of STDIO, but STDIO is faster ;)
> You can monitor the progress of the backup using onstat -g arc on the
> source and the progress of the restore using onstat -D on the
> destination.
>
> Regards,
> Kenneth Penza
> Systems Engineer| SMD
> MALTA INFORMATION TECHNOLOGY AGENCY
> * email: kenneth.penza@gov.mt - ( Office: +356 2599 2867 :
> http://www.mita.gov.mt
> * Please read our Legal Notice: http://emailpolicy.mita.gov.mt
> P Please consider your environmental responsibility before printing this

> e-mail
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> VIKAS HIVARKAR
> Sent: 03 February 2009 16:58
> To: ids@iiug.org
> Subject: External Restoration [14708]
>
> Hello,
>
> IDS 11.10 FC3 on solaris 10.
>
> Problem: I have instance lt1 on my test server having 25 medium size
> databases
> (level 0 backup size of about 400 GB using ontape), now I want all these

>
> databases on the same server in another instance. Currenly the chunks of

> lt1
> are in /dbs/lt1/ and I want the new database chunks in /ids/lt2 on same
> server.
>
> I simply cannot build another instance and restore the level 0 as the
> chunk
> paths won't be the same and restoration will abort giving me an error.
>
> What options do I have, OTHER than Export / Import OR HPL OR Archecker?
>
> Would External Backup and Restore help me in this case? I see the
> documents
> say that Cold Restoration would allow me to change the chunk path.
>
> Old path of chunks /dbs/lt1/.....
> New path of chunks /ids/lt2/.....
>
> Can this help me with my requirement? If yes then
>
> I need help with the restoration process as, what should be the path of
> root
> dbspaces for the new instance when I want to initialize it for the first

> time
> so that I have a instance which I can now take down and start the
> External
> Restoration with the copied chunks from old instance.
> Or do i have so simple create a new instance with the chunks in new path

> ( in
> this case do i have to build all the chunks as that of old instance or
> only
> rootdbs ).
>
> Else any suggestions of doing this in a better way will help me!
>
> Regards,
> Vikas
>
>
>
>
*******************************************************************************

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

--
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.

--0016361e8252684c2f04621665de

*******************************************************************************

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

Messages In This Thread

• External Restoration
  VIKAS HIVARKAR -- Tuesday, 3 February 2009, at 10:58 a.m.
  • RE: External Restoration
    Penza Kenneth at MITA -- Tuesday, 3 February 2009, at 11:16 a.m.
  • Re: External Restoration
    Art Kagel -- Tuesday, 3 February 2009, at 11:31 a.m.
    • Re: External Restoration
      VIKAS HIVARKAR -- Wednesday, 4 February 2009, at 3:49 a.m.
      • RE: External Restoration
        Penza Kenneth at MITA -- Wednesday, 4 February 2009, at 5:31 a.m.
      • Re: External Restoration
        Art Kagel -- Wednesday, 4 February 2009, at 6:50 a.m.
        • Re: External Restoration
          Peter_Logan@spartanstores.com -- Wednesday, 4 February 2009, at 8:25 a.m.
          • RE: External Restoration
            Penza Kenneth at MITA -- Thursday, 5 February 2009, at 5:06 a.m.
      • Re: External Restoration
        Martin Fuerderer -- Wednesday, 4 February 2009, at 12:17 p.m.
        • Re: External Restoration
          VIKAS HIVARKAR -- Friday, 6 February 2009, at 4:03 a.m.
          • Re: External Restoration
            Martin Fuerderer -- Friday, 6 February 2009, at 4:38 a.m.
            • Re: External Restoration
              VIKAS HIVARKAR -- Friday, 6 February 2009, at 5:02 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.