ontape -r
Hi folks
We have a problem not experienced before.
OS:
> cat /proc/version
Linux version 2.4.18-14 (bhcompile@stripples.devel.redhat.com) (gcc version
3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 13:35:50 EDT 2002
IDS:
Online version: Informix Dynamic Server Version 7.31.UD5
In ontape -s -L0 the tape size is enought to fill a woole instance. (it
doesn't as to mount a second tape and show the log number).
Now, I try to recover (ontape -r) and checking the I/O operations I can see
(with onstat -D) that the chunks have a lot of pages written in it.
And at the end , the restore ask for a second tape:
See bellow the commands and results ....
Have somebody experienced that before ?? Is that a bug in IDS V7.31 on Linux ??
Thanks for helping !
Best regards.
Roberto Ferronato
> ontape -r
Please mount tape 1 on /dev/st0 and press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 7.31.UD5
Archive date: Wed Dec 31 09:53:28 2008
User id: informix
Terminal id: /dev/tty1
Archive level: 0
Tape device: /dev/st0
Tape blocksize (in k): 512
Tape size (in k): 12000000
Tape number in series: 1
Spaces to restore:1 [rootdbs ]
2 [simdbs ]
Archive Information
Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
Initialization Time 11/12/2004 12:18:25
System Page Size 2048
Version 6
Archive CheckPoint Time 12/31/2008 09:53:30
Dbspaces
number flags fchunk nchunks flags owner name
1 1 1 1 N informix rootdbs
2 1 2 8 N informix simdbs
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 1000000 839061 PO- /usr/informix/dbs/rootsim
2 2 0 1000000 5 PO- /usr/informix/dbs/simdbs01
3 2 0 1000000 319 PO- /usr/informix/dbs/simdbs02
4 2 0 1000000 257 PO- /usr/informix/dbs/simdbs03
5 2 0 1000000 166 PO- /usr/informix/dbs/simdbs04
6 2 0 1000000 1 PO- /usr/informix/dbs/simdbs05
7 2 0 1000000 175445 PO- /usr/informix/dbs/simdbs06
8 2 0 1000000 110862 PO- /usr/informix/dbs/simdbs07
9 2 0 1000000 0 PO- /usr/informix/dbs/simdbs08
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
Please mount tape 2 on /dev/st0 and press Return to continue ... Tape sequence
number is 1, expecting 2
Bad tape.
_________________________________________________________________
Show them the way! Add maps and directions to your party invites.
http://www.microsoft.com/windows/windowslive/events.aspx
For the restore TAPEDEV seems to be set to 12000000, was the setting higher
for the original archive? Perhaps ontape is not seeing the soft
end-of-archive page bacause it stopped reading early.
Art
On Sat, Feb 7, 2009 at 2:05 PM, R Fo <roeferr@hotmail.com> wrote:
> Hi folks
>
> We have a problem not experienced before.
> OS:
> > cat /proc/version
> Linux version 2.4.18-14 (bhcompile@stripples.devel.redhat.com) (gcc
> version
> 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 13:35:50 EDT 2002
>
> IDS:
> Online version: Informix Dynamic Server Version 7.31.UD5
>
> In ontape -s -L0 the tape size is enought to fill a woole instance. (it
> doesn't as to mount a second tape and show the log number).
>
> Now, I try to recover (ontape -r) and checking the I/O operations I can see
> (with onstat -D) that the chunks have a lot of pages written in it.
>
> And at the end , the restore ask for a second tape:
>
> See bellow the commands and results ....
>
> Have somebody experienced that before ?? Is that a bug in IDS V7.31 on
> Linux
> ??
>
> Thanks for helping !
>
> Best regards.
>
> Roberto Ferronato
>
> > ontape -r>
> Please mount tape 1 on /dev/st0 and press Return to continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: Informix Dynamic Server Version 7.31.UD5
> Archive date: Wed Dec 31 09:53:28 2008
> User id: informix
> Terminal id: /dev/tty1
> Archive level: 0
> Tape device: /dev/st0
> Tape blocksize (in k): 512
> Tape size (in k): 12000000
> Tape number in series: 1
>
> Spaces to restore:1 [rootdbs ]
> 2 [simdbs ]
>
> Archive Information
>
> Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
> Initialization Time 11/12/2004 12:18:25
> System Page Size 2048
> Version 6
> Archive CheckPoint Time 12/31/2008 09:53:30
>
> Dbspaces
> number flags fchunk nchunks flags owner name
> 1 1 1 1 N informix rootdbs
> 2 1 2 8 N informix simdbs
>
> Chunks
> chk/dbs offset size free bpages flags pathname
> 1 1 0 1000000 839061 PO- /usr/informix/dbs/rootsim
> 2 2 0 1000000 5 PO- /usr/informix/dbs/simdbs01
> 3 2 0 1000000 319 PO- /usr/informix/dbs/simdbs02
> 4 2 0 1000000 257 PO- /usr/informix/dbs/simdbs03
> 5 2 0 1000000 166 PO- /usr/informix/dbs/simdbs04
> 6 2 0 1000000 1 PO- /usr/informix/dbs/simdbs05
> 7 2 0 1000000 175445 PO- /usr/informix/dbs/simdbs06
> 8 2 0 1000000 110862 PO- /usr/informix/dbs/simdbs07
> 9 2 0 1000000 0 PO- /usr/informix/dbs/simdbs08
>
> Continue restore? (y/n)y
> Do you want to back up the logs? (y/n)n
>
> Please mount tape 2 on /dev/st0 and press Return to continue ... Tape
> sequence
> number is 1, expecting 2
>
> Bad tape.
>
> _________________________________________________________________
> Show them the way! Add maps and directions to your party invites.
> http://www.microsoft.com/windows/windowslive/events.aspx
>
>
>
>
*******************************************************************************
> 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.
--00163646bfccec73ff04626ab0ed
Hi Roberto,
Some ideas, besides calling tech support:
- check all tape parameters in ONCONFIG and compare the TAPESIZE and TAPEBLK
with the ones in the source instance (the archive information below)
- check if a non-rewinding device was used in either the source or the target
machine. We need a rewinding device.
- maybe you want to try using a backup image in a file on disk (then you might
want to change the TAPESIZE to have just one file), rather than in a tape, to
isolate a problem when using the tape devices.
Regards,
Veronica.
> To: ids@iiug.org
> From: roeferr@hotmail.com
> Subject: ontape -r [14799]
> Date: Sat, 7 Feb 2009 14:05:48 -0500
>
> Hi folks
>
> We have a problem not experienced before.
> OS:
> > cat /proc/version
> Linux version 2.4.18-14 (bhcompile@stripples.devel.redhat.com) (gcc version
> 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 13:35:50 EDT 2002
>
> IDS:
> Online version: Informix Dynamic Server Version 7.31.UD5
>
> In ontape -s -L0 the tape size is enought to fill a woole instance. (it
> doesn't as to mount a second tape and show the log number).
>
> Now, I try to recover (ontape -r) and checking the I/O operations I can see
> (with onstat -D) that the chunks have a lot of pages written in it.
>
> And at the end , the restore ask for a second tape:
>
> See bellow the commands and results ....
>
> Have somebody experienced that before ?? Is that a bug in IDS V7.31 on Linux
> ??
>
> Thanks for helping !
>
> Best regards.
>
> Roberto Ferronato
>
> > ontape -r>
> Please mount tape 1 on /dev/st0 and press Return to continue ...
>
> Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: Informix Dynamic Server Version 7.31.UD5
> Archive date: Wed Dec 31 09:53:28 2008
> User id: informix
> Terminal id: /dev/tty1
> Archive level: 0
> Tape device: /dev/st0
> Tape blocksize (in k): 512
> Tape size (in k): 12000000
> Tape number in series: 1
>
> Spaces to restore:1 [rootdbs ]
> 2 [simdbs ]
>
> Archive Information
>
> Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
> Initialization Time 11/12/2004 12:18:25
> System Page Size 2048
> Version 6
> Archive CheckPoint Time 12/31/2008 09:53:30
>
> Dbspaces
> number flags fchunk nchunks flags owner name
> 1 1 1 1 N informix rootdbs
> 2 1 2 8 N informix simdbs
>
> Chunks
> chk/dbs offset size free bpages flags pathname
> 1 1 0 1000000 839061 PO- /usr/informix/dbs/rootsim
> 2 2 0 1000000 5 PO- /usr/informix/dbs/simdbs01
> 3 2 0 1000000 319 PO- /usr/informix/dbs/simdbs02
> 4 2 0 1000000 257 PO- /usr/informix/dbs/simdbs03
> 5 2 0 1000000 166 PO- /usr/informix/dbs/simdbs04
> 6 2 0 1000000 1 PO- /usr/informix/dbs/simdbs05
> 7 2 0 1000000 175445 PO- /usr/informix/dbs/simdbs06
> 8 2 0 1000000 110862 PO- /usr/informix/dbs/simdbs07
> 9 2 0 1000000 0 PO- /usr/informix/dbs/simdbs08
>
> Continue restore? (y/n)y
> Do you want to back up the logs? (y/n)n
>
> Please mount tape 2 on /dev/st0 and press Return to continue ... Tape
sequence
> number is 1, expecting 2
>
> Bad tape.
>
> _________________________________________________________________
> Show them the way! Add maps and directions to your party invites.
> http://www.microsoft.com/windows/windowslive/events.aspx
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
Color coding for safety: Windows Live Hotmail alerts you to suspicious email.
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_safety_1120
08
Hi Veronica
Nice to heard from you ... Thanks.
Thanks to Art too (other email).
After hours analysing the restore, we got what was a problem.
The guy who run the backup (ontape -s -L0) categorically told us that in the
end of the tape, told us that the log number was showed and he removed the
tape from device and it's all.
But, comparing the size of the chunks (all of the 9 chunks has 1000000 page of
2k, than 2 GB on each one.
If we check the page free columns, we get the number o "used pages" in the
instance. Sum that , we have the whole size of the level 0 backup greather
than 12GB.
As never was mounted the 2nd tape, we'll never have the total amount of pages
to restore.
With the dd command , the archive was transfered from the tape to disk.
The total size of the file is: 12287737856 / 1024 show: 11999744 almost 12 GB.
See the table:
The column "restored pages" showed by the onstat -D statement while running
restore (when the requesto for 2nd tape is showed)
Pages:
chunkSize free pages used pages restored pages
1000000 839061 160939 10480
1000000 5 999995 979605
1000000 319 999681 995576
1000000 257 999743 999504
1000000 166 999834 991427
1000000 1 999999 958916
1000000 175445 824555 721337
1000000 110862 889138 340450
1000000 0 1000000 0
Total size (sum) in pages
9000000 1126116 7873884 5997295
Total size in kbytes
18000000 2252232 15747768 11994590
If the file has 11.999 GB, and the total sum of used pages is 15.747 GB, then
we realized the whole archive is not complete on tape.
The question is: Has somebody experienced that the version 7.31.UD5 on Linux
have the bug not requesting to mount the 2nd tape ?
Please Veronica, could you check in your company if there is a registered bug
in ontape ?
Thanks all.
R Ferronato
> To: ids@iiug.org
> From: vgomesn@hotmail.com
> Subject: RE: ontape -r [14801]
> Date: Sun, 8 Feb 2009 12:43:09 -0500
>
> Hi Roberto,
>
> Some ideas, besides calling tech support:
>
> - check all tape parameters in ONCONFIG and compare the TAPESIZE and TAPEBLK
> with the ones in the source instance (the archive information below)
> - check if a non-rewinding device was used in either the source or the target
> machine. We need a rewinding device.
> - maybe you want to try using a backup image in a file on disk (then you
might
> want to change the TAPESIZE to have just one file), rather than in a tape, to
> isolate a problem when using the tape devices.
>
> Regards,
> Veronica.
>
> > To: ids@iiug.org
> > From: roeferr@hotmail.com
> > Subject: ontape -r [14799]
> > Date: Sat, 7 Feb 2009 14:05:48 -0500
> >
> > Hi folks
> >
> > We have a problem not experienced before.
> > OS:
> > > cat /proc/version
> > Linux version 2.4.18-14 (bhcompile@stripples.devel.redhat.com) (gcc version
> > 3.2 20020903 (Red Hat Linux 8.0 3.2-7)) #1 Wed Sep 4 13:35:50 EDT 2002
> >
> > IDS:
> > Online version: Informix Dynamic Server Version 7.31.UD5
> >
> > In ontape -s -L0 the tape size is enought to fill a woole instance. (it
> > doesn't as to mount a second tape and show the log number).
> >
> > Now, I try to recover (ontape -r) and checking the I/O operations I can see
> > (with onstat -D) that the chunks have a lot of pages written in it.
> >
> > And at the end , the restore ask for a second tape:
> >
> > See bellow the commands and results ....
> >
> > Have somebody experienced that before ?? Is that a bug in IDS V7.31 on
Linux
> > ??
> >
> > Thanks for helping !
> >
> > Best regards.
> >
> > Roberto Ferronato
> >
> > > ontape -r> >
> > Please mount tape 1 on /dev/st0 and press Return to continue ...
> >
> > Archive Tape Information
> >
> > Tape type: Archive Backup Tape
> > Online version: Informix Dynamic Server Version 7.31.UD5
> > Archive date: Wed Dec 31 09:53:28 2008
> > User id: informix
> > Terminal id: /dev/tty1
> > Archive level: 0
> > Tape device: /dev/st0
> > Tape blocksize (in k): 512
> > Tape size (in k): 12000000
> > Tape number in series: 1
> >
> > Spaces to restore:1 [rootdbs ]
> > 2 [simdbs ]
> >
> > Archive Information
> >
> > Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
> > Initialization Time 11/12/2004 12:18:25
> > System Page Size 2048
> > Version 6
> > Archive CheckPoint Time 12/31/2008 09:53:30
> >
> > Dbspaces
> > number flags fchunk nchunks flags owner name
> > 1 1 1 1 N informix rootdbs
> > 2 1 2 8 N informix simdbs
> >
> > Chunks
> > chk/dbs offset size free bpages flags pathname
> > 1 1 0 1000000 839061 PO- /usr/informix/dbs/rootsim
> > 2 2 0 1000000 5 PO- /usr/informix/dbs/simdbs01
> > 3 2 0 1000000 319 PO- /usr/informix/dbs/simdbs02
> > 4 2 0 1000000 257 PO- /usr/informix/dbs/simdbs03
> > 5 2 0 1000000 166 PO- /usr/informix/dbs/simdbs04
> > 6 2 0 1000000 1 PO- /usr/informix/dbs/simdbs05
> > 7 2 0 1000000 175445 PO- /usr/informix/dbs/simdbs06
> > 8 2 0 1000000 110862 PO- /usr/informix/dbs/simdbs07
> > 9 2 0 1000000 0 PO- /usr/informix/dbs/simdbs08
> >
> > Continue restore? (y/n)y
> > Do you want to back up the logs? (y/n)n
> >
> > Please mount tape 2 on /dev/st0 and press Return to continue ... Tape
> sequence
> > number is 1, expecting 2
> >
> > Bad tape.
> >
> > _________________________________________________________________
> > Show them the way! Add maps and directions to your party invites.
> > http://www.microsoft.com/windows/windowslive/events.aspx
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
> _________________________________________________________________
> Color coding for safety: Windows Live Hotmail alerts you to suspicious email.
>
>
http://windowslive.com/Explore/Hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_safety_1120
08
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
_________________________________________________________________
More than messagescheck out the rest of the Windows Live.
http://www.microsoft.com/windows/windowslive/
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape