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:\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.
>
*******************************************************************************
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.
