Re: chunk failed sanity check
Posted in 2005
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