DBSpace is disabled
A user on AIX with Informix OnLine 7.12 had a dbspace disabled (chunk 6 marked inconsistent) and no archive to restore from; the server panicked during logical recovery at startup, so onspaces -s ... -O couldn't be used while the instance was offline. Respondents explained that a dbspace holding logical/physical logs can't be skipped during recovery and that Informix technical support has an internal tool to force an inconsistent chunk/dbspace back online. The poster reported that Informix support in England resolved it.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Informix ODS v.7.12 Thanks in advance. Sorry for my english. Saulius Raudys, Lithuania, Vilnius
Call tech support and they can dial in and force the chunk and dbspace online. Art S. Kagel Saulius wrote: > Hello. > I've a big problem: > one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is > off-line and I dont have an archive. > I think exists an utility, that brings that inconsistent chunk On-Line. > May be some body can give me it . Operating system is AIX 4.2.1.0, Informix > ODS v.7.12 > > Thanks in advance. > Sorry for my english. > > Saulius Raudys, > Lithuania, > Vilnius
I can't run onspaces command, because server is in off-line mode.
When i try to start the server, it shuts down and online.log has such
records:
08:29:05 Physical Recovery Started.
08:29:05 Physical Recovery Complete: 192 Pages Restored.
08:29:05 Logical Recovery Started.
08:29:33 Assert Failed: Buffer modified in inconsistent chunk.
08:29:33 Who: Session(5, informix@, 0, 5)
Thread(24, fast_rec, 4000acac, 1)
08:29:33 Results: Chunk 6 is being taken OFFLINE.
08:29:33 Action: Restore chunk from archive.
08:29:33 See Also: /tmp/af.b81a52a, shmem.b81a52a.0
08:29:34 Assert Failed: WARNING! Chunk 6 is being taken OFFLINE.
08:29:34 Who: Session(5, informix@, 0, 5)
Thread(24, fast_rec, 4000acac, 1)
08:29:34 Results: DBspace rastine is disabled.
08:29:34 Action: Restore DBspace rastine
08:29:34 See Also: /tmp/af.b81a52a
08:29:34 Assert Failed: Page Check Error in bfput
08:29:34 Who: Session(5, informix@, 0, 5)
Thread(24, fast_rec, 4000acac, 1)
08:29:34 Results: Possible inconsistencies in 'TBLSpace 5243005'
08:29:34 Action: Run 'oncheck -cDI 5243005'
08:29:34 See Also: /tmp/af.b81a52a
08:29:34 rsbuff.c, line 1945, thread 24, proc id 16260, OnLine must abort.
08:29:34 PANIC: Attempting to bring system down
Saulius Raudys
Lithuania
Erik Stahlhut <isr-est@t-online.de> wrote in message
news:8elrui$okm$1@news08.btx.dtag.de...
> Hello,
>
> if the disks are ok, please check it, you can transfer the chunks to
> online-mode with the onspaces-command
>
> onspaces -s spacename -p pathname -p offset -O>
> O: Online
>
> regards
> Erik Stahlhut
> ISR Software-Consulting GmbH
> www.isr-gruppe.de
>
>
>
> Saulius schrieb in Nachricht <8e90qh$pf12@www.informix.com>...
> >Hello.
> >I've a big problem:
> >one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is
> >off-line and I dont have an archive.
> >I think exists an utility, that brings that inconsistent chunk On-Line.
> >May be some body can give me it . Operating system is AIX 4.2.1.0,
Informix
> >ODS v.7.12
> >
> >Thanks in advance.
> >Sorry for my english.
> >
> >Saulius Raudys,
> >Lithuania,
> >Vilnius
> >
> >
> >
> >
>
>
Hello,
if the disks are ok, please check it, you can transfer the chunks to
online-mode with the onspaces-command
onspaces -s spacename -p pathname -p offset -O
O: Online
regards
Erik Stahlhut
ISR Software-Consulting GmbH
www.isr-gruppe.de
Saulius schrieb in Nachricht <8e90qh$pf12@www.informix.com>...
>Hello.
>I've a big problem:
>one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is
>off-line and I dont have an archive.
>I think exists an utility, that brings that inconsistent chunk On-Line.
>May be some body can give me it . Operating system is AIX 4.2.1.0, Informix
>ODS v.7.12
>
>Thanks in advance.
>Sorry for my english.
>
>Saulius Raudys,
>Lithuania,
>Vilnius
>
>
>
>
It´s seems that you have some logical logs in that dbspace. If so its not
possible to start a logical recovery from the last checkpoint.
Generaly it is not possible to bring the IDS online if one of the three
critical dbspaces is down.
a) root
b) logical logs
c) physical logs
I know that the informix-support has a tool to restart such a critical
dbspace. so I hope you have an Support-Contract.
Do you have a dbexport available ???
regards
Erik Stahlhut
ISR Software-Consulting GmbH
www.isr-gruppe.de
Saulius schrieb in Nachricht <8elsor$b032@www.informix.com>...
>I can't run onspaces command, because server is in off-line mode.
>When i try to start the server, it shuts down and online.log has such
>records:
>
>
>08:29:05 Physical Recovery Started.
>08:29:05 Physical Recovery Complete: 192 Pages Restored.
>08:29:05 Logical Recovery Started.
>08:29:33 Assert Failed: Buffer modified in inconsistent chunk.
>08:29:33 Who: Session(5, informix@, 0, 5)
> Thread(24, fast_rec, 4000acac, 1)
>08:29:33 Results: Chunk 6 is being taken OFFLINE.
>08:29:33 Action: Restore chunk from archive.
>08:29:33 See Also: /tmp/af.b81a52a, shmem.b81a52a.0
>08:29:34 Assert Failed: WARNING! Chunk 6 is being taken OFFLINE.
>08:29:34 Who: Session(5, informix@, 0, 5)
> Thread(24, fast_rec, 4000acac, 1)
>08:29:34 Results: DBspace rastine is disabled.
>08:29:34 Action: Restore DBspace rastine
>...
Englands tech support help us. Saulius <saulius@snt.lt> wrote in message news:8e90qh$pf12@www.informix.com... > Hello. > I've a big problem: > one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is > off-line and I dont have an archive. > I think exists an utility, that brings that inconsistent chunk On-Line. > May be some body can give me it . Operating system is AIX 4.2.1.0, Informix > ODS v.7.12 > > Thanks in advance. > Sorry for my english. > > Saulius Raudys, > Lithuania, > Vilnius > > > >
Thanks very much to all of you. Saulius <saulius@snt.lt> wrote in message news:8e90qh$pf12@www.informix.com... > Hello. > I've a big problem: > one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is > off-line and I dont have an archive. > I think exists an utility, that brings that inconsistent chunk On-Line. > May be some body can give me it . Operating system is AIX 4.2.1.0, Informix > ODS v.7.12 > > Thanks in advance. > Sorry for my english. > > Saulius Raudys, > Lithuania, > Vilnius > > > >