 |
IDS Forum
Re: Problems with restore on Windows
Posted By: Art Kagel
Date: Thursday, 21 February 2013, at 11:34 a.m.
In Response To: RE: Problems with restore on Windows (Schleicher, Keith)
No, ontape -r is correct. If this archive is 'bad' you can try using the
previous archive, you will just have to restore more logical logs to get
back up-to-date.
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 Thu, Feb 21, 2013 at 11:24 AM, Schleicher, Keith <
Keith.Schleicher@searshc.com> wrote:
> Art,
>
> Would I use another ontape command besides "-r" to restore this server? I
> got
> an error message saying the tape (file) was bad, even though it didn't
> seem to
> have an issue restoring a single dbspace.
>
> ________________________________________
> From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Art Kagel
> [art.kagel@gmail.com]
> Sent: Thursday, February 21, 2013 10:04 AM
> To: ids@iiug.org
> Subject: Re: Problems with restore on Windows [29560]
>
> To me, looking at the rollforward errors, I would kill everything and
> perform a full restore of the entire server and rollforward the logs from
> there using the last known good archive and all of the following logical
> log backups.
>
> 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 Thu, Feb 21, 2013 at 9:55 AM, Schleicher, Keith <
> Keith.Schleicher@searshc.com> wrote:
>
> > I tried to start up the database instance, but now it is in Fast Recovery
> > mode. However, when I run "onstat -d update" I get the following:
> >
> > d:\IDS9~1.40>onstat -d update
> > Informix Dynamic Server Version 9.40.TC1 -- Fast Recovery -- Up 06:57:53
> --
> > 849024 Kbytes
> > Dbspaces
> > address number flags fchunk nchunks flags owner name
> > 3EC8B7D8 1 0x1 1 3 N informix rootdbs
> > 3F444EC8 2 0x1 19 1 N informix plogdbs
> > 3F445EC8 4 0x1 4 1 N informix llogdbs01
> > 3F446308 5 0x40001 12 11 N B informix ddrrdbs
> > 3F446458 6 0x2001 6 4 N T informix tempdbs01
> > 3F4465A8 7 0x2001 7 4 N T informix tempdbs02
> > 3F4466F8 8 0x40005 13 7 ND B informix ddrrflsdbs
> > 7 active, 2047 maximum
> > Chunks
> > address chunk/dbs offset size free bpages flags pathname
> > 3EC8B928 1 1 0 12800 11076 PO-- D:\IFMXDATA\ifmx00253\rootdbs_dat.000
> > 3F443318 2 6 0 512000 511997 PO-- d:\ifmxdata\ifmx00253\tempdbs01_02
> > 3F443490 3 7 0 512000 511997 PO-- d:\ifmxdata\ifmx00253\tempdbs02_02
> > 3F443608 4 4 0 51200 44647 PO-- d:\ifmxdata\ifmx00253\llogdbs01
> > 3F443780 5 8 0 2048000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_02
> > 3F4438F8 6 6 0 512000 511947 PO-- d:\ifmxdata\ifmx00253\tempdbs01
> > 3F443A70 7 7 0 512000 511947 PO-- d:\ifmxdata\ifmx00253\tempdbs02
> > 3F443BE8 8 8 0 2048000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_03
> > 3F443D60 9 8 0 2048000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_04
> > 3F444018 10 8 0 1024000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_05
> > 3F444190 11 8 0 2023000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_06
> > 3F444308 12 5 0 1536000 36 PO-B e:\ifmxdata\ifmx00253\datadbsddrr_01
> > 3F444480 13 8 0 4096000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_01
> > 3F4445F8 14 8 0 2048000 0 PD-B e:\ifmxdata\ifmx00253\datadbsddrrfls_07
> > 3F444770 15 5 0 512000 6 PO-B e:\ifmxdata\ifmx00253\datadbsddrr_02
> > 3F4448E8 16 5 0 512000 1 PO-B e:\ifmxdata\ifmx00253\datadbsddrr_03
> > 3F444A60 17 5 0 512000 1 PO-B e:\ifmxdata\ifmx00253\datadbsddrr_04
> > 3F444BD8 18 5 0 512000 3 PO-B e:\ifmxdata\ifmx00253\datadbsddrr_05
> > 3F444D50 19 2 0 64025 1472 PO-- d:\ifmxdata\ifmx00253\plogdbs01
> > 3F445018 20 5 0 256000 3 PO-B d:\ifmxdata\ifmx00253\datadbsddrr_06
> > 3F445190 21 6 0 512000 511997 PO-- d:\ifmxdata\ifmx00253\tempdbs01_03
> > 3F445308 22 7 0 512000 511997 PO-- d:\ifmxdata\ifmx00253\tempdbs02_03
> > 3F445480 23 5 0 256000 5 PO-B d:\ifmxdata\ifmx00253\datadbsddrr_07
> > 3F4455F8 24 5 0 256000 0 PO-B d:\ifmxdata\ifmx00253\datadbsddrr_08
> > 3F445770 25 5 0 256000 7 PO-B d:\ifmxdata\ifmx00253\datadbsddrr_09
> > 3F4458E8 26 5 0 512000 6 PO-B d:\ifmxdata\ifmx00253\datadbsddrr_10
> > 3F445A60 27 1 0 12800 12797 PO-- d:\ifmxdata\ifmx00253\rootdbs_dat.001
> > 3F445BD8 28 1 0 250000 249997 PO-- D:\IFMXDATA\ifmx00253\rootdbs_dat.002
> > 3F445D50 29 6 0 512000 511997 PO-- d:\ifmxdata\ifmx00253\tempdbs01_04
> > 3F446018 30 7 0 512000 511997 PO-- d:\ifmxdata\ifmx00253\tempdbs02_04
> > 3F446190 31 5 0 256000 166960 PO-B d:\ifmxdata\ifmx00253\datadbsddrr_11
> >
> > It looks like all of the chunks associated with the ddrrdbs dbspace are
> > coming
> > up as online, including the two that were marked as down, and the
> > ddrrflsdbs
> > dbspace has all of its chunks marked as full. The error log file is
> > getting a
> > bunch of these messages:
> >
> > 08:52:06 Log Record: log = 15368, pos = 0x1edc70, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> > 08:52:06 Rollforward of log record failed. iserrno = 101
> > 08:52:06 Log Record: log = 15368, pos = 0x1ecca4, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> > 08:52:06 Rollforward of log record failed. iserrno = 101
> > 08:52:06 Log Record: log = 15368, pos = 0x1ecca4, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> > 08:52:07 Rollforward of log record failed. iserrno = 135
> > 08:52:07 Log Record: log = 15368, pos = 0x1ed1dc, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> > 08:52:07 Rollforward of log record failed. iserrno = 135
> > 08:52:07 Log Record: log = 15368, pos = 0x1ed1dc, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> > 08:52:07 Rollforward of log record failed. iserrno = 135
> > 08:52:07 Log Record: log = 15368, pos = 0x1ebe5c, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> > 08:52:07 Rollforward of log record failed. iserrno = 135
> > 08:52:07 Log Record: log = 15368, pos = 0x1ebe5c, type =
> > OLDRSAM:DELITEM(29),
> > trans = 55
> >
> > I am guessing I will need to try to restore the ddrrflsdbs dbspace. Does
> > anyone else have any other suggestions? The Fast Recovery has been going
> on
> > for about seven hours now, and I'd like to be able to get this server
> > running
> > in a usable state.
> >
> > ________________________________________
> > From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of
> Schleicher,
> > Keith [Keith.Schleicher@searshc.com]
> > Sent: Wednesday, February 20, 2013 11:18 PM
> > To: ids@iiug.org
> > Subject: Problems with restore on Windows [29544]
> >
> > We have a Win 2000 SP4 running Informix 9.40.TC1. We recently had an
> issue=
> > where some chunks went bad:
> >
> > Informix Dynamic Server Version 9.40.TC1 -- On-Line -- Up 00:39:45 -- 8=
> > 67072 Kbytes
> >
> > Dbspaces
> > address number flags fchunk nchunks flags owner name
> > 3EC8B7D8 1 0x1 1 3 N informix rootdbs
> > 3F446EC8 2 0x1 19 1 N informix plogdbs
> > 3F447EC8 4 0x1 4 1 N informix llogdbs01
> > 3F448308 5 0x40001 12 11 N B informix ddrrdbs
> > 3F448458 6 0x2001 6 4 N T informix tempdbs01
> > 3F4485A8 7 0x2001 7 4 N T informix tempdbs02
> > 3F4486F8 8 0x40001 13 7 N B informix ddrrflsdbs
> > 7 active, 2047 maximum
> >
> > Chunks
> > address chunk/dbs offset size free bpages flags pathn=
> > ame
> > 3EC8B928 1 1 0 12800 11076 PO-- D:\IF=
> > MXDATA\ifmx00253\rootdbs_dat.000
> > 3F445318 2 6 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01_02
> > 3F445490 3 7 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02_02
> > 3F445608 4 4 0 51200 44647 PO-- d:\if=
> > mxdata\ifmx00253\llogdbs01
> > 3F445780 5 8 0 2048000 10747 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_02
> > 3F4458F8 6 6 0 512000 511497 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01
> > 3F445A70 7 7 0 512000 511497 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02
> > 3F445BE8 8 8 0 2048000 1128 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_03
> > 3F445D60 9 8 0 2048000 1670 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_04
> > 3F446018 10 8 0 1024000 6229 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_05
> > 3F446190 11 8 0 2023000 171011 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_06
> > 3F446308 12 5 0 1536000 36 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_01
> > 3F446480 13 8 0 4096000 53393 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_01
> > 3F4465F8 14 8 0 2048000 1164797 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_07
> > 3F446770 15 5 0 512000 6 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_02
> > 3F4468E8 16 5 0 512000 1 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_03
> > 3F446A60 17 5 0 512000 1 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_04
> > 3F446BD8 18 5 0 512000 3 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_05
> > 3F446D50 19 2 0 64025 1472 PO-- d:\if=
> > mxdata\ifmx00253\plogdbs01
> > 3F447018 20 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_06
> > 3F447190 21 6 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01_03
> > 3F447308 22 7 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02_03
> > 3F447480 23 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_07
> > 3F4475F8 24 5 0 256000 0 PO-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_08
> > 3F447770 25 5 0 256000 7 PO-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_09
> > 3F4478E8 26 5 0 512000 6 PO-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_10
> > 3F447A60 27 1 0 12800 12797 PO-- d:\if=
> > mxdata\ifmx00253\rootdbs_dat.001
> > 3F447BD8 28 1 0 250000 249997 PO-- D:\IF=
> > MXDATA\ifmx00253\rootdbs_dat.002
> > 3F447D50 29 6 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01_04
> > 3F448018 30 7 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02_04
> > 3F448190 31 5 0 256000 166960 PO-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_11
> > 31 active, 32766 maximum
> >
> > I tried to just restore the ddrrfls dbspace. After that happened more
> chun=
> > ks came back as down:
> >
> > Informix Dynamic Server Version 9.40.TC1 -- On-Line -- Up 02:26:50 -- 8=
> > 67072 Kbytes
> >
> > Dbspaces
> > address number flags fchunk nchunks flags owner name
> > 3EC8B7D8 1 0x1 1 3 N informix rootdbs
> > 3F446EC8 2 0x1 19 1 N informix plogdbs
> > 3F447EC8 4 0x1 4 1 N informix llogdbs01
> > 3F448308 5 0x40005 12 11 ND B informix ddrrdbs
> > 3F448458 6 0x2001 6 4 N T informix tempdbs01
> > 3F4485A8 7 0x2001 7 4 N T informix tempdbs02
> > 3F4486F8 8 0x40001 13 7 N B informix ddrrflsdbs
> > 7 active, 2047 maximum
> >
> > Chunks
> > address chunk/dbs offset size free bpages flags pathn=
> > ame
> > 3EC8B928 1 1 0 12800 11076 PO-- D:\IF=
> > MXDATA\ifmx00253\rootdbs_dat.000
> > 3F445318 2 6 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01_02
> > 3F445490 3 7 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02_02
> > 3F445608 4 4 0 51200 44647 PO-- d:\if=
> > mxdata\ifmx00253\llogdbs01
> > 3F445780 5 8 0 2048000 10747 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_02
> > 3F4458F8 6 6 0 512000 508757 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01
> > 3F445A70 7 7 0 512000 508813 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02
> > 3F445BE8 8 8 0 2048000 1128 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_03
> > 3F445D60 9 8 0 2048000 1670 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_04
> > 3F446018 10 8 0 1024000 6229 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_05
> > 3F446190 11 8 0 2023000 171011 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_06
> > 3F446308 12 5 0 1536000 0 PD-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_01
> > 3F446480 13 8 0 4096000 52937 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_01
> > 3F4465F8 14 8 0 2048000 1164797 PO-B e:\if=
> > mxdata\ifmx00253\datadbsddrrfls_07
> > 3F446770 15 5 0 512000 0 PD-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_02
> > 3F4468E8 16 5 0 512000 0 PD-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_03
> > 3F446A60 17 5 0 512000 0 PD-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_04
> > 3F446BD8 18 5 0 512000 0 PD-B e:\if=
> > mxdata\ifmx00253\datadbsddrr_05
> > 3F446D50 19 2 0 64025 1472 PO-- d:\if=
> > mxdata\ifmx00253\plogdbs01
> > 3F447018 20 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_06
> > 3F447190 21 6 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01_03
> > 3F447308 22 7 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02_03
> > 3F447480 23 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_07
> > 3F4475F8 24 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_08
> > 3F447770 25 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_09
> > 3F4478E8 26 5 0 512000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_10
> > 3F447A60 27 1 0 12800 12797 PO-- d:\if=
> > mxdata\ifmx00253\rootdbs_dat.001
> > 3F447BD8 28 1 0 250000 249997 PO-- D:\IF=
> > MXDATA\ifmx00253\rootdbs_dat.002
> > 3F447D50 29 6 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs01_04
> > 3F448018 30 7 0 512000 511997 PO-- d:\if=
> > mxdata\ifmx00253\tempdbs02_04
> > 3F448190 31 5 0 256000 0 PD-B d:\if=
> > mxdata\ifmx00253\datadbsddrr_11
> > 31 active, 32766 maximum
> >
> > Expanded chunk capacity mode: enabled
> >
> > I think tried to restore using an "ontape -r" but I got an error message
> > sa=
> > ying that the tape was bad, even though I had just used that same file
> for
> > =
> > the restore of the ddrrfls dbspace.
> >
> > Any ideas for what to do next? Do I need to get some new files and
> rename =
> > the dbspaces?
> >
> > We did have the SA do a scan of the drive these files are on and we got
> no
> > =
> > physical errors.
> >
> > This message, including any attachments, is the property of Sears
> Holdings
> > =
> > Corporation and/or one of its subsidiaries. It is confidential and may
> > cont=
> > ain proprietary or legally privileged information. If you are not the
> > inten=
> > ded recipient, please delete it without reading the contents. Thank you.
> >
> >
> >
> >
>
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> > This message, including any attachments, is the property of Sears
> Holdings
> > Corporation and/or one of its subsidiaries. It is confidential and may
> > contain
> > proprietary or legally privileged information. If you are not the
> intended
> > recipient, please delete it without reading the contents. Thank you.
> >
> >
> >
> >
>
>
> *******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --bcaec55554942f35b104d63d621b
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> This message, including any attachments, is the property of Sears Holdings
> Corporation and/or one of its subsidiaries. It is confidential and may
> contain
> proprietary or legally privileged information. If you are not the intended
> recipient, please delete it without reading the contents. Thank you.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--f46d04016b492f5e3904d63ea4da
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|
