Reading informix backup from tape drive
Poster needed to restore a 40GB ontape backup onto a standby server that has no tape drive, and asked how to get the tape-based backup readable there. Suggestions: for a small instance, take the ontape backup to disk and copy the file to the standby for restore; or point the standby's ONCONFIG TAPEDEV at the primary's tape device remotely (e.g. TAPEDEV primaryserver:/dev/rmt1), which requires an rsh daemon and trusted-host setup on the primary. Art Kagel also suggested using ifxclone to restore the secondary directly from the live primary. The poster didn't confirm which option he used.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi All,
I have requirements as below and my current server using ontape backup.
My standby server need to restore this backup but the issue is my standby
server doesn't have tape drive and needs to read this file to filesystem
and then restore to tape.
Is there any option to do this?
Thank you
--089e013c66443dea2104ecd552e7
What is the size of your instance? If its a small one you can do a
ontape on disk and move the file to standby and restore. Another option
would be to point your standby server to read the tape device of the primary
server.
From: "medkba" <medkba@gmail.com>
Sent: Fri, 06 Dec 2013 09:05:12
To: ids@iiug.org
Subject: Reading informix backup from tape drive [32089]
Hi All,
I have requirements as below and my current server using ontape backup.
My standby server need to restore this backup but the issue is my standby
server doesn't have tape drive and needs to read this file to filesystem
and then restore to tape.
Is there any option to do this?
Thank you
--089e013c66443dea2104ecd552e7
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Size:40G but my standby server no tape drive how it possible to use
tapedrive. How to move move it on disk read from tape
On Fri, Dec 6, 2013 at 12:59 PM, Lloyd S <lloyd_s@rediffmail.com> wrote:
> What is the size of your instance? If its a small one you can do a
> ontape on disk and move the file to standby and restore. Another
> option
> would be to point your standby server to read the tape device of the
> primary
> server.
>
> From: "medkba" <medkba@gmail.com>
> Sent: Fri, 06 Dec 2013 09:05:12
> To: ids@iiug.org
> Subject: Reading informix backup from tape drive [32089]
> Hi All,
>
> I have requirements as below and my current server using ontape backup.
>
> My standby server need to restore this backup but the issue is my standby
>
> server doesn't have tape drive and needs to read this file to filesystem
>
> and then restore to tape.
>
> Is there any option to do this?
>
> Thank you
>
> --089e013c66443dea2104ecd552e7
>
>
>
>
*******************************************************************************
>
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01227c0cc089e404ecd68cd4
You can include the primary server tape device path in your onconfig file in
the secondary server and try a restore.
TAPEDEV primaryserver:/dev/rmt1
# Tape device path
From: "medkba" <medkba@gmail.com>
Sent: Fri, 06 Dec 2013 10:32:49
To: ids@iiug.org
Subject: Re: Reading informix backup from tape drive [32091]
Size:40G but my standby server no tape drive how it possible to use
tapedrive. How to move move it on disk read from tape
On Fri, Dec 6, 2013 at 12:59 PM, Lloyd S <lloyd_s@rediffmail.com> wrote:
> What is the size of your instance? &nbsp;If its a small one you can
do a
> ontape on disk and move the file to standby and restore. &nbsp;Another
> option
> would be to point your standby server to read the tape device of the
> primary
> server.
>
> From: "medkba" &lt;medkba@gmail.com>;
> Sent: Fri, 06 Dec 2013 09:05:12
> To: ids@iiug.org
> Subject: Reading informix backup from tape drive [32089]
> Hi All,
>
> I have requirements as below and my current server using ontape backup.
>
> My standby server need to restore this backup but the issue is my standby
>
> server doesn't have tape drive and needs to read this file to filesystem
>
> and then restore to tape.
>
> Is there any option to do this?
>
> Thank you
>
> --089e013c66443dea2104ecd552e7
>
>
>
>
*******************************************************************************
>
> &nbsp;Forum Note: Use "Reply" to post a response in the discussion
forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01227c0cc089e404ecd68cd4
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Previous contents were not readable. TAPEDEV primaryserver:/dev/rmt1
For this to work, rsh daemon must be configured on primaryserver and a trust must be defined. On Dec 6, 2013 6:31 AM, "LLOYD SERRAO" <serrao.lloyd@gmail.com> wrote: > Previous contents were not readable. > > TAPEDEV primaryserver:/dev/rmt1 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e01176885bd221a04ecd9545e
Two good options: 1) Use the primary's tape drive remotely, 2) use ifxclone
to restore the secondary directly from the primary live. Ifxclone is
documented in the Administrator's Reference Manual.
Art
Art S. Kagel, Principal Consultant
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, Dec 6, 2013 at 12:02 AM, medkba <medkba@gmail.com> wrote:
> Size:40G but my standby server no tape drive how it possible to use
> tapedrive. How to move move it on disk read from tape
>
> On Fri, Dec 6, 2013 at 12:59 PM, Lloyd S <lloyd_s@rediffmail.com> wrote:
>
> > What is the size of your instance? If its a small one you can do a
> > ontape on disk and move the file to standby and restore. Another
> > option
> > would be to point your standby server to read the tape device of the
> > primary
> > server.
> >
> > From: "medkba" <medkba@gmail.com>
> > Sent: Fri, 06 Dec 2013 09:05:12
> > To: ids@iiug.org
> > Subject: Reading informix backup from tape drive [32089]
> > Hi All,
> >
> > I have requirements as below and my current server using ontape backup.
> >
> > My standby server need to restore this backup but the issue is my standby
> >
> > server doesn't have tape drive and needs to read this file to filesystem
> >
> > and then restore to tape.
> >
> > Is there any option to do this?
> >
> > Thank you
> >
> > --089e013c66443dea2104ecd552e7
> >
> >
> >
> >
>
>
*******************************************************************************
> >
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --089e01227c0cc089e404ecd68cd4
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7b4725a8e8340404ecdccf55