Automatic restore in IDS 11
The poster wanted to automate restoring a daily level-0 ontape archive onto a second server without manual intervention. Art Kagel's answer: pipe the archive file into "ontape -r -t STDIO <archive_file_path", which the poster confirmed worked. For adding level 1/2 backups, Kagel noted the restore is interactive (ontape prompts for further files) so it may not be automatable, suggesting an untested "cat level0 level1 level2 | ontape -r -t STDIO". He also said you cannot restore an IDS 10/9 ontape archive into IDS 11 — the ontape version must match — though archecker might extract the data.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to all i am doing a daily L0, and i want to send it to another server in order to do a restore. i think that is possible to do this restore automatically without a human hand. am i right ? and if so, how to do it ? thanks in advance
ontape -r -t STDIO <archive_file_path
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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, Nov 11, 2011 at 2:06 PM, SMITH JOHN <daylight@webmails.com> wrote:
> Hi to all
>
> i am doing a daily L0, and i want to send it to another server in order to
> do
> a restore. i think that is possible to do this restore automatically
> without a
> human hand.
>
> am i right ? and if so, how to do it ?
>
> thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--14dae9340dc124a78e04b17bb987
it works, thanks a lot
hi once again, and what about L1 and L2 please ?
hi once again, and what about L1 and L2 please ? and can i do a restore in IDS 11 from a backup of an earlier version (10, 9) Thanks
If you also have to restore level 1 &/or level 2 IB that you need an
interactive restore, so you may not be able to use -t STDIO but will have
to use -t <path> instead and ontape will prompt for the additional files so
you may not be able to automate the restore. However, you could try:
cat level0.file level1.file level2.file | ontape -r -t STDIO
and see what happens. Never tried that.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Sat, Nov 12, 2011 at 2:13 AM, SMITH JOHN <daylight@webmails.com> wrote:
> hi once again,
>
> and what about L1 and L2 please ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba1fd5644b404b191a590
No, to the second part. You can only restore with the exact same version
of ontape that made the archive. You MAY be able to use the archecker to
extract the data from the older archives and insert into tables in an
existing instance, however.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Sat, Nov 12, 2011 at 2:29 AM, SMITH JOHN <daylight@webmails.com> wrote:
> hi once again,
>
> and what about L1 and L2 please ?
>
> and can i do a restore in IDS 11 from a backup of an earlier version (10,
> 9)
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f3ba2adaf706b04b191a94f
thanks a lot