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.
