Problems with restore on Windows
A Windows 2000 box running IDS 9.40.TC1 had chunks go down (dbspaces ddrrdbs/ddrrflsdbs). The poster tried a single-dbspace ontape restore, after which even more chunks were marked down; a subsequent 'ontape -r' complained the tape/file was bad, and restarting left the instance stuck in Fast Recovery for hours with repeated 'Rollforward of log record failed' errors (iserrno 101 and 135). One reply asked whether links were right and whether the archive matched the version/was a level 0. Art Kagel advised abandoning the piecemeal approach and doing a full cold restore of the whole server from the last known good archive plus all subsequent logical log backups. No confirmation of the outcome is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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.
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
3F
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
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 1024
Andrew,
Thank you for responding. All of the links are correct, and the backup was
taken on this version with this server. It is a level 0 backup.
We are looking at restoring the actual files from a backup, but we aren't sure
that those files themselves were backed up.
Does the fact that I got an error trying to do an "ontape -r" and getting an
error message that the tape was bad mean that I can't restore this entire
instance using this file?
________________________________________
From: ids-bounces@iiug.org [ids-bounces@iiug.org] on behalf of Andrew Grantham
[agrantha@hotmail.com]
Sent: Thursday, February 21, 2013 10:03 AM
To: ids@iiug.org
Subject: RE: Problems with restore on Windows [29559]
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:
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 512
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: id
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