Problem of restore
A user on AIX 6.1 with IDS 10.00.FC10X1 got "read: I/O error ... 22+0 records in/out, Physical restore failed - function read archive backup failed code 1" when running ontape -p against a remote tape drive (TAPEDIR set to host:/dev/rmt/0). Art Kagel and Martin Fuerderer explained that ontape reads the first 22 pages, closes the device, restarts the engine in recovery mode, then reopens the tape expecting to start from the beginning again — so a no-rewind (or auto-ejecting) device fails exactly this way; an auto-rewind device is required. The user reported that piping the tape through rsh/dd into "ontape -p -t STDIO" restored successfully.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi
I have problems with my engine Informix restore.
If raalizo restore with the command:
$ ontape -p
Show me the following error message:
read: I/O error
22+0 records in
22+0 records out
Physical restore failed - function read archive backup failed code 1 errno 0
Thanks for the help
Date:
AIX 6.1
Informix 10.FC10X1
_________________________________________________________________
Disfrutá todos los especiales que MSN tiene para vos
http://especiales.latam.msn.com/cl
Can you see the TAPEDIR file/device? What are its permissions?
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, May 7, 2009 at 6:41 PM, emaus <in4mixperu@hotmail.com> wrote:
> Hi
> I have problems with my engine Informix restore.
> If raalizo restore with the command:
>
> $ ontape -p>
> Show me the following error message:
> read: I/O error
> 22+0 records in
> 22+0 records out
>
> Physical restore failed - function read archive backup failed code 1 errno
> 0
>
> Thanks for the help
>
> Date:
> AIX 6.1
> Informix 10.FC10X1
>
> _________________________________________________________________
> Disfrutá todos los especiales que MSN tiene para vos
> http://especiales.latam.msn.com/cl
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b8efdd6ec804695ae87a
Hi Art:
TAPEDIR: 20.68.1.20:/dev/rmt/0
lrwxrwxrwx 1 root other 66 Apr 30 14:51 /dev/rmt/0 ->
../../devices/pci@1e,600000/pci@0/p
Thanks for the help
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: Problem of restore [15705]
> Date: Thu, 7 May 2009 19:31:37 -0400
>
> Can you see the TAPEDIR file/device? What are its permissions?
>
> 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, May 7, 2009 at 6:41 PM, emaus <in4mixperu@hotmail.com> wrote:
>
> > Hi
> > I have problems with my engine Informix restore.
> > If raalizo restore with the command:
> >
> > $ ontape -p> >
> > Show me the following error message:
> > read: I/O error
> > 22+0 records in
> > 22+0 records out
> >
> > Physical restore failed - function read archive backup failed code 1 errno
> > 0
> >
> > Thanks for the help
> >
> > Date:
> > AIX 6.1
> > Informix 10.FC10X1
> >
> > _________________________________________________________________
> > Disfrutá todos los especiales que MSN tiene para vos
> > http://especiales.latam.msn.com/cl
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5b8efdd6ec804695ae87a
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Disfrutá todos los especiales que MSN tiene para vos
http://especiales.latam.msn.com/cl
Not clear. Is the /dev/rmt/0 device local to the machine on which you are
performing the restore or is it remote? If local, then you should have
TAPEDIR set to simply /dev/rmt/0 without the IP address.
Can you read the tape manually on it's host with dd? What happens? Is it
possible that the tape unit is ejecting the tape when ontape closes the
device? Ontape reads the first 22 pages from the tape to get the reserved
pages restored, then it closes the tape device/file and starts the IDS
instance in recovery mode (oninit -r). Once the engine is up in recovery
mode, ontape reopens the tape device/file and expects to reread the first
page (that's why you need to use an auto rewind capable device). If the
tape unit ejects the tape when ontape closes the file the first time one
would expect to see the exact results you are seeing here.
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, May 7, 2009 at 8:41 PM, emaus <in4mixperu@hotmail.com> wrote:
> Hi Art:
>
> TAPEDIR: 20.68.1.20:/dev/rmt/0
>
> lrwxrwxrwx 1 root other 66 Apr 30 14:51 /dev/rmt/0 ->
> .../../devices/pci@1e,600000/pci@0/p
>
> Thanks for the help
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: Problem of restore [15705]
> > Date: Thu, 7 May 2009 19:31:37 -0400
> >
> > Can you see the TAPEDIR file/device? What are its permissions?
> >
> > 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, May 7, 2009 at 6:41 PM, emaus <in4mixperu@hotmail.com> wrote:
> >
> > > Hi
> > > I have problems with my engine Informix restore.
> > > If raalizo restore with the command:
> > >
> > > $ ontape -p> > >
> > > Show me the following error message:
> > > read: I/O error
> > > 22+0 records in
> > > 22+0 records out
> > >
> > > Physical restore failed - function read archive backup failed code 1
> errno
> > > 0
> > >
> > > Thanks for the help
> > >
> > > Date:
> > > AIX 6.1
> > > Informix 10.FC10X1
> > >
> > > _________________________________________________________________
> > > Disfrutá todos los especiales que MSN tiene para vos
> > > http://especiales.latam.msn.com/cl
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001636c5b8efdd6ec804695ae87a
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
> Disfrutá todos los especiales que MSN tiene para vos
> http://especiales.latam.msn.com/cl
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5a57be6e7c604695bff5c
Art:
Step 1:
Backup the primary server online
·
The
backup is running on a backup tape drive local, finishing well.
$ ontape s L 0
Step 2: Restore online server contingency
·
The
restore is run from a tape backup unit remote in the same VLAN
$
ontape p
Remote tape report:
read: I/O error
22+0 records in
22+0 records out
Physical restore failed - function
read archive backup failed code 1 errno 0
Archive
online.log
10:49:42 Restartable Restore has been ENABLED
10:49:42 Recovery Mode
10:49:45
Physical Restore of rootdbs, physdbs, logsdbs, data1, data 2, data3,
otherdata0,
data 4, data 5, idx1, otherdata1, data6, idx2, otherdata2 started.
10:49:46 Checkpoint Completed: duration was 0 seconds.
10:49:46 Checkpoint loguniq 2246, logpos 0x8bb018,
timestamp: 0x3ea455f6
10:49:46 Maximum server connections 0
10:49:46 Checkpoint Completed: duration was 0 seconds.
10:49:46 Checkpoint loguniq 2246, logpos 0x8bb018,
timestamp: 0x3ea45600
10:49:46 Maximum server connections 0
10:49:46 Checkpoint Completed: duration was 0 seconds.
10:49:46 Checkpoint loguniq 2246, logpos 0x8bb018,
timestamp: 0x3ea4560a
10:49:46 Maximum server connections 0
10:49:54 Aborting physical restore of ROOT DBSpace
10:49:54 Aborted by client.
10:49:54 IBM Informix Dynamic Server Stopped.
Step 3:
Restore online whit STDIO
·
The
restore is run from a tape backup unit remote in the same VLAN
$ rsh 20.68.1.20 dd if=/dev/rmt/0 bs=16384k |ontape p t STDIO
This restore
satisfactorily completes
Thanks for the help
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: Problem of restore [15707]
> Date: Thu, 7 May 2009 20:49:28 -0400
>
> Not clear. Is the /dev/rmt/0 device local to the machine on which you are
> performing the restore or is it remote? If local, then you should have
> TAPEDIR set to simply /dev/rmt/0 without the IP address.
>
> Can you read the tape manually on it's host with dd? What happens? Is it
> possible that the tape unit is ejecting the tape when ontape closes the
> device? Ontape reads the first 22 pages from the tape to get the reserved
> pages restored, then it closes the tape device/file and starts the IDS
> instance in recovery mode (oninit -r). Once the engine is up in recovery
> mode, ontape reopens the tape device/file and expects to reread the first
> page (that's why you need to use an auto rewind capable device). If the
> tape unit ejects the tape when ontape closes the file the first time one
> would expect to see the exact results you are seeing here.
>
> 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, May 7, 2009 at 8:41 PM, emaus <in4mixperu@hotmail.com> wrote:
>
> > Hi Art:
> >
> > TAPEDIR: 20.68.1.20:/dev/rmt/0
> >
> > lrwxrwxrwx 1 root other 66 Apr 30 14:51 /dev/rmt/0 ->
> > .../../devices/pci@1e,600000/pci@0/p
> >
> > Thanks for the help
> >
> > > To: ids@iiug.org
> > > From: art.kagel@gmail.com
> > > Subject: Re: Problem of restore [15705]
> > > Date: Thu, 7 May 2009 19:31:37 -0400
> > >
> > > Can you see the TAPEDIR file/device? What are its permissions?
> > >
> > > 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, May 7, 2009 at 6:41 PM, emaus <in4mixperu@hotmail.com> wrote:
> > >
> > > > Hi
> > > > I have problems with my engine Informix restore.
> > > > If raalizo restore with the command:
> > > >
> > > > $ ontape -p> > > >
> > > > Show me the following error message:
> > > > read: I/O error
> > > > 22+0 records in
> > > > 22+0 records out
> > > >
> > > > Physical restore failed - function read archive backup failed code 1
> > errno
> > > > 0
> > > >
> > > > Thanks for the help
> > > >
> > > > Date:
> > > > AIX 6.1
> > > > Informix 10.FC10X1
> > > >
> > > > _________________________________________________________________
> > > > Disfrutá todos los especiales que MSN tiene para vos
> > > > http://especiales.latam.msn.com/cl
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001636c5b8efdd6ec804695ae87a
> > >
> > >
> > >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> > _________________________________________________________________
> > Disfrutá todos los especiales que MSN tiene para vos
> > http://especiales.latam.msn.com/cl
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001636c5a57be6e7c604695bff5c
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
¡Es hora que descubras quién sos! Alguien puede conocerte mejor que vos mismo
_________________________________________________________________
Los mejores videos de Peter Capusotto están en MSN
http://video.msn.com/?mkt=es-xl&vid=c0e9175e-4a3f-4bae-8ea2-d96315d241b6&tab=s12
3756909335
Hi,
the problem may be that the tape (device) you are
using for the restore does not act as a rewind device.
ontape first reads some pages to determine what is
to be restored. Then it closes the tape device and
opens it again, expecting that it will start again from
the beginning. If the device acts as a no-rewind
device, then upon the second opening of the
device it will not start from the beginning.
This is what Art also explained already, and it
really works like that!
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
ids-bounces@iiug.org wrote on 09.05.2009 00:24:23:
> Art:
> Step 1:
> Backup the primary server online
>
> ·
> The
> backup is running on a backup tape drive local, finishing well.
>
> $ ontape ?s ?L 0>
> Step 2: Restore online server contingency
>
> ·
> The
> restore is run from a tape backup unit remote in the same VLAN
>
> $
> ontape ?p
>
> Remote tape report:
>
> read: I/O error
>
> 22+0 records in
>
> 22+0 records out
>
> Physical restore failed - function
> read archive backup failed code 1 errno 0
>
> Archive
> online.log
>
> 10:49:42 Restartable Restore has been ENABLED
>
> 10:49:42 Recovery Mode
>
> 10:49:45
> Physical Restore of rootdbs, physdbs, logsdbs, data1, data 2, data3,
> otherdata0,
> data 4, data 5, idx1, otherdata1, data6, idx2, otherdata2 started.
>
> 10:49:46 Checkpoint Completed: duration was 0 seconds.
>
> 10:49:46 Checkpoint loguniq 2246, logpos 0x8bb018,
> timestamp: 0x3ea455f6
>
> 10:49:46 Maximum server connections 0
>
> 10:49:46 Checkpoint Completed: duration was 0 seconds.
>
> 10:49:46 Checkpoint loguniq 2246, logpos 0x8bb018,
> timestamp: 0x3ea45600
>
> 10:49:46 Maximum server connections 0
>
> 10:49:46 Checkpoint Completed: duration was 0 seconds.
>
> 10:49:46 Checkpoint loguniq 2246, logpos 0x8bb018,
> timestamp: 0x3ea4560a
>
> 10:49:46 Maximum server connections 0
>
> 10:49:54 Aborting physical restore of ROOT DBSpace
>
> 10:49:54 Aborted by client.
>
> 10:49:54 IBM Informix Dynamic Server Stopped.
>
> Step 3:
> Restore online whit STDIO
>
> ·
> The
> restore is run from a tape backup unit remote in the same VLAN
>
> $ rsh 20.68.1.20 dd if=/dev/rmt/0 bs=16384k |> ontape ?p ?t STDIO
>
> This restore
> satisfactorily completes
>
> Thanks for the help
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: Problem of restore [15707]
> > Date: Thu, 7 May 2009 20:49:28 -0400
> >
> > Not clear. Is the /dev/rmt/0 device local to the machine on which you
are
> > performing the restore or is it remote? If local, then you should have
> > TAPEDIR set to simply /dev/rmt/0 without the IP address.
> >
> > Can you read the tape manually on it's host with dd? What happens? Is
it
> > possible that the tape unit is ejecting the tape when ontape closes
the
> > device? Ontape reads the first 22 pages from the tape to get the
reserved
> > pages restored, then it closes the tape device/file and starts the IDS
> > instance in recovery mode (oninit -r). Once the engine is up in
recovery
> > mode, ontape reopens the tape device/file and expects to reread the
first
> > page (that's why you need to use an auto rewind capable device). If
the
> > tape unit ejects the tape when ontape closes the file the first time
one
> > would expect to see the exact results you are seeing here.
> >
> > 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, May 7, 2009 at 8:41 PM, emaus <in4mixperu@hotmail.com> wrote:
> >
> > > Hi Art:
> > >
> > > TAPEDIR: 20.68.1.20:/dev/rmt/0
> > >
> > > lrwxrwxrwx 1 root other 66 Apr 30 14:51 /dev/rmt/0 ->
> > > .../../devices/pci@1e,600000/pci@0/p
> > >
> > > Thanks for the help
> > >
> > > > To: ids@iiug.org
> > > > From: art.kagel@gmail.com
> > > > Subject: Re: Problem of restore [15705]
> > > > Date: Thu, 7 May 2009 19:31:37 -0400
> > > >
> > > > Can you see the TAPEDIR file/device? What are its permissions?
> > > >
> > > > 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, May 7, 2009 at 6:41 PM, emaus <in4mixperu@hotmail.com>
wrote:
> > > >
> > > > > Hi
> > > > > I have problems with my engine Informix restore.
> > > > > If raalizo restore with the command:
> > > > >
> > > > > $ ontape -p> > > > >
> > > > > Show me the following error message:
> > > > > read: I/O error
> > > > > 22+0 records in
> > > > > 22+0 records out
> > > > >
> > > > > Physical restore failed - function read archive backup failed
code 1
> > > errno
> > > > > 0
> > > > >
> > > > > Thanks for the help
> > > > >
> > > > > Date:
> > > > > AIX 6.1
> > > > > Informix 10.FC10X1
> > > > >
> > > > >
_________________________________________________________________
> > > > > Disfrutá todos los especiales que MSN tiene para vos
> > > > > http://especiales.latam.msn.com/cl
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>
*******************************************************************************
> > > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > > >
> > > > >
> > > >
> > > > --001636c5b8efdd6ec804695ae87a
> > > >
> > > >
> > > >
> > >
> > >
> >
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion
forum.
> > > >
> > >
> > > _________________________________________________________________
> > > Disfrutá todos los especiales que MSN tiene para vos
> > > http://especiales.latam.msn.com/cl
> > >
> > >
> > >
> > >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >@@