IDS Forum

Re: chunk failed sanity check

Posted By: Victor Miramontes
Date: Saturday, 17 December 2005, at 4:08 a.m.

In Response To: Re: chunk failed sanity check (Lavoie, Diane)

Can you physically access to the chunk ?
If you can you shoud solve the problem
using onspaces.

onspaces -s dbspace -p /bd/RAW/dbspace -o 0 -O -y

Regards,



-----Original Message-----
From: forum.subscriber@iiug.org
To: ids@iiug.org
Sent: Fri Dec 16 17:32:21 2005
Subject: chunk failed sanity check [6132]

Hi all!



I have a big problem.



I was create an IDS2000 V 9.21 Intance database 10 days ago over UnixWare
7.1.3 OS. A database dbspace was damage by power failure and

I have no backup.



There is a way to recover the damaged dbspace??





I hope anybody help me!





List errors during database instance starting up:



$ oninit -v



Checking group membership to determine server run modesucceeded

Reading configuration file '/usr/informix/etc/onconfig10'...succeeded

Creating /INFORMIXTMP/.infxdirs ... succeeded

Creating infos file "/usr/informix/etc/.infos.deneb10" ...
"/usr/informix/etc/.c

onf.deneb10" ... succeeded

Writing to infos file ... succeeded

Checking config parameters...succeeded

Allocating and attaching to shared memory...succeeded

Creating resident pool 2272 kbytes...succeeded

Creating buffer pool 16002 kbytes...succeeded

Initializing rhead structure...succeeded

Initializing ASF ...succeeded

Initializing Dictionary Cache and SPL Routine Cache...succeeded

Bringing up ADM VP...succeeded

Creating VP classes...succeeded

Onlining 0 additional cpu vps...succeeded

Onlining 2 IO vps...succeeded

Forking main_loop thread...succeeded

Initializing DR structures...succeeded

Forking 1 'tlitcp' listener threads...succeeded

Starting tracing...succeeded

Initializing 1 flushers...succeeded

Initializing log/checkpoint information...succeeded

Opening primary chunks...Bad Primary Chunk '/bd/RAW/dbspace'.

succeeded

Opening mirror chunks...succeeded

Initializing dbspaces...succeeded

Validating chunks...succeeded

Initialize Async Log Flusher...succeeded

Forking btree cleaner...succeeded

Initializing DBSPACETEMP list

Checking database partition index...succeeded

Checking location of physical log...succeeded

Initializing dataskip structure...succeeded

Checking for temporary tables to drop

Forking onmode_mon thread...succeeded

Verbose output complete: mode = 5





$ onstat -d



Informix Dynamic Server 2000 Version 9.21.UC4 -- On-Line -- Up 00:00:52
-- 3

4812 Kbytes



Dbspaces

address number flags fchunk nchunks flags owner name

b33b7d0 1 0x1 1 1 N informix rootdbs

b37a6f8 2 0x2001 2 1 N T informix dbtemp

b37a840 3 0x1 3 1 N informix dblog

b37a988 4 0x5 4 1 ND informix dbspace

4 active, 2047 maximum



Chunks

address chk/dbs offset size free bpages flags pathname

b33b918 1 1 0 25000 22732 PO- /bd/RAW/rootdbs

b37a2a8 2 2 0 512000 511947 PO- /bd/RAW/dbtemp

b37a418 3 3 0 512000 201947 PO- /bd/RAW/dblog

b37a588 4 4 0 1048575 0 PD- /bd/RAW/dbspace

4 active, 2047 maximum





AMM



Vmctor Fabian Miramontes
DBA Proyecto SAP
Cencosud S.A.
TE: 54-11-4733-1000 int. 4158

Messages In This Thread

• chunk failed sanity check
  Alejandro Mtz Mejia -- Friday, 16 December 2005, at 5:32 p.m.
  • Re: chunk failed sanity check
    Obnoxio The Clown -- Friday, 16 December 2005, at 7:54 p.m.
  • AW: chunk failed sanity check
    Model-Bosch, Tilman -- Monday, 19 December 2005, at 3:38 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.