|
IDS Forum
RE: Problems with restore on Windows
Posted By: Andrew Grantham Date: Thursday, 21 February 2013, at 10:03 a.m.
In Response To: RE: Problems with restore on Windows (Schleicher, Keith)
Keith,
If it helps another dbspace ( and its chunks ) are marked as down ( ddrrflsdbs ). Sorry for coming into this late but I guess all links are correct? The backup you are using was taken on this version of Informix? If this a level 0 restoration using ontape?
> To: ids@iiug.org
> From: Keith.Schleicher@searshc.com
> Subject: RE: Problems with restore on Windows [29558]
> Date: Thu, 21 Feb 2013 09:55:06 -0500
>
> 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.
>
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|