chunk failed sanity check

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

Alejandro M.... said: > > I have no backup. It's usually at this point where I lose any sympathy and start laughing. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com

Dear Alejandro, It looks as if the power failure physically damaged the data on the raw device or the raw device is not accessible anymore. First try to make the raw device accessible again , ensure you can read it with lets say 'dd' . When you where succesful reading the device, you might try onspaces to set the chunk online again. If there is no real damage to the data, this should work. If there is damage to the data, you might want to restore , which is not possible as you said. You will have to recreate the tables and data in the dbspace then from an external source - if possible. -----Urspr|ngliche Nachricht----- Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] Im Auftrag von Alejandro M.... Gesendet: 16 December 2005 23:32 An: ids@iiug.org Betreff: 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