Hi,
Did you restore the down spaces using onbar ?
If not, you cannot bring the chunk online, cause the data is missing (disks
are replaced, as you said).
If you do not have a onbar backup for the missing dbspaces, you cannot bring
the chunks back online.
In case you have an ontape backup, the only choice I know of is to restore
the entire system from the last backup where
the missing chunks were active. After the cold-restore, you have to restore
the logs from you (hopefully existing) log-Backup. Looking at the amount of
data which is stored there, this might be a long operation, depending on
your backup mechanisms.
To prevent such a problem in the future, consider to do mirroring either on
Informix level or OS level.
Hope this helps,
Marcus
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
CHANATIP LA....
Sent: Friday, May 05, 2006 10:03 AM
To: ids@iiug.org
Subject: how to enable dbspace [6668]
How to enable dbspace? dbspace3 be disble from I/O error. Now disks were
replace already.
N740-Informix > onstat -d
Informix Dynamic Server Version 9.30.HC3 -- On-Line -- Up 03:03:32 -- 367852
Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
e06d97e8 1 0x1001 1 1 N informix rootdbs_psc
e0de2748 2 0x2001 41 2 N T informix tempdbs
e0de2898 3 0x1 3 1 N informix logicaldbs
e0de29e8 4 0x1 4 9 N informix dbspace1
e0de2b38 5 0x1 6 51 N informix dbspace2
e0de2c88 6 0x5 73 62 ND informix dbspace3
e0de2dd8 7 0x1 75 1 N informix psc_tmp1
e0de3018 8 0x11 12 1 N B informix blobspace1
e0de3168 9 0x1 13 1 N informix index1
e0de32b8 10 0x1 64 1 N informix dptraining1 10 active, 2047 maximum
Note: For BLOB chunks, the number of free pages shown is out of date.
Run 'onstat -d update' for current stats.
Chunks
address chk/dbs offset size free bpages flags pathname
e06d9938 1 1 0 25000 21014 PO- /home/informix/psck5701/dpchk01
e0dd2a98 2 5 0 1024000 127235 PO- /home/informix/psck5701/dpchk02
e0dd2c08 3 3 0 1000000 129947 PO- /home/informix/psck5701/dpchk03
e0dd2d78 4 4 0 1000000 272 PO- /home/informix/psck5701/dpchk06
e0dd3018 5 4 0 1000000 432 PO- /home/informix/psck5701/dpchk07
e0dd3188 6 5 0 1000000 4972 PO- /home/informix/psck5701/dpchk11
e0dd32f8 7 5 0 1000000 14662 PO- /home/informix/psck5701/dpchk12
e0dd3468 8 5 0 1024000 26702 PO- /home/informix/psck5701/dpchk16
e0dd35d8 9 5 0 1024000 15113 PO- /home/informix/psck5701/dpchk17
e0dd3748 10 5 0 1024000 9114 PO- /home/informix/psck5701/dpchk35
e0dd38b8 11 5 0 1024000 4435 PO- /home/informix/psck5701/dpchk38
e0dd3a28 12 8 0 1000000 ~200 200 POB /home/informix/psck5701/dpchk39
e0dd3b98 13 9 0 1000000 999569 PO- /home/informix/psck5701/dpchk36
e0dd3d08 14 5 0 1024000 540541 PO- /home/informix/psck5701/dpchk18
e0dd3e78 15 5 0 1024000 349453 PO- /home/informix/psck5701/dpchk21
e0dd4018 16 4 0 1000000 309 PO- /home/informix/psck5701/dpchk08
e0dd4188 17 4 0 1000000 128 PO- /home/informix/psck5701/dpchk09
e0dd42f8 18 5 0 1024000 220856 PO- /home/informix/psck5701/dpchk26
e0dd4468 19 5 0 1000000 8955 PO- /home/informix/psck5701/dpchk13
e0dd45d8 20 5 0 1000000 9520 PO- /home/informix/psck5701/dpchk14
e0dd4748 21 6 0 1024000 0 PD- /backup/INFORMIX/data33.dat
e0dd48b8 22 6 0 1024000 0 PD- /backup/INFORMIX/data34.dat
e0dd4a28 23 5 0 1024000 12180 PO- /home/informix/psck5701/dpchk20
e0dd4b98 24 5 0 1024000 13568 PO- /home/informix/psck5701/dpchk22
e0dd4d08 25 6 0 1024000 0 PD- /backup/INFORMIX/data35.dat
e0dd4e78 26 6 0 1024000 0 PD- /backup/INFORMIX/data36.dat
e0dd5018 27 5 0 1024000 12370 PO- /home/informix/psck5701/dpchk24
e0dd5188 28 4 0 1024000 153 PO- /home/informix/psck5701/dpchk25
e0dd52f8 29 5 0 1000000 21095 PO- /home/informix/psck5701/dpchk41
e0dd5468 30 5 0 1024000 12484 PO- /home/informix/psck5701/dpchk31
e0dd55d8 31 5 0 1024000 7515 PO- /home/informix/psck5701/dpchk32
e0dd5748 32 6 0 1024000 0 PD- /backup/INFORMIX/data37.dat
e0dd58b8 33 6 0 1024000 0 PD- /backup/INFORMIX/data38.dat
e0dd5a28 34 5 0 1000000 26838 PO- /home/informix/psck5701/dpchk15
e0dd5b98 35 5 0 1000000 21645 PO- /home/informix/psck5701/dpchk23
e0dd5d08 36 6 0 1024000 0 PD- /backup/INFORMIX/data39.dat
e0dd5e78 37 6 0 1024000 0 PD- /backup/INFORMIX/data40.dat
e0dd6018 38 5 0 1024000 283225 PO- /home/informix/psck5701/dpchk33
e0dd6188 39 5 0 1024000 434343 PO- /home/informix/psck5701/dpchk37
e0dd62f8 40 5 0 1024000 1007685 PO- /home/informix/psck5701/dpchk40
e0dd6468 41 2 0 50000 49947 PO- /home/informix/psck5701/dpchk04
e0dd65d8 42 5 0 1024000 560387 PO- /home/informix/psck5701/dpchk42
e0dd6748 43 6 0 1024000 0 PD- /backup/INFORMIX/data41.dat
e0dd68b8 44 6 0 1024000 0 PD- /backup/INFORMIX/data42.dat
e0dd6a28 45 5 0 1024000 11935 PO- /home/informix/psck5701/dpchk47
e0dd6b98 46 6 0 1024000 0 PD- /backup/INFORMIX/data43.dat
e0dd6d08 47 6 0 1024000 0 PD- /backup/INFORMIX/data44.dat
e0dd6e78 48 6 0 1024000 0 PD- /backup/INFORMIX/data45.dat
e0dd7018 49 6 0 1024000 0 PD- /backup/INFORMIX/data46.dat
e0dd7188 50 5 0 512000 2293 PO- /home/informix/psck5701/dpchk52
e0dd72f8 51 6 0 1024000 0 PD- /backup/INFORMIX/data47.dat
e0dd7468 52 6 0 1024000 0 PD- /backup/INFORMIX/data48.dat
e0dd75d8 53 6 0 1024000 0 PD- /backup/INFORMIX/data49.dat
e0dd7748 54 5 0 512000 5232 PO- /home/informix/psck5701/dpchk56
e0dd78b8 55 5 0 512000 3648 PO- /home/informix/psck5701/dpchk57
e0dd7a28 56 6 0 1024000 0 PD- /backup/INFORMIX/data50.dat
e0dd7b98 57 6 0 1024000 0 PD- /backup/INFORMIX/data51.dat
e0dd7d08 58 6 0 1024000 0 PD- /backup/INFORMIX/data52.dat
e0dd7e78 59 6 0 1024000 0 PD- /backup/INFORMIX/data53.dat
e0dd8018 60 6 0 1024000 0 PD- /backup/INFORMIX/data54.dat
e0dd8188 61 5 0 1024000 1012 PO- /home/informix/psck5701/dpchk62
e0dd82f8 62 5 0 1024000 8886 PO- /home/informix/psck5701/dpchk63
e0dd8468 63 6 0 1024000 0 PD- /backup/INFORMIX/data55.dat
e0dd85d8 64 10 0 1024000 783683 PO- /home/informix/psck5701/dpchk64
e0dd8748 65 5 0 1024000 342365 PO- /backup/INFORMIX/data56.dat
e0dd88b8 66 6 0 1024000 0 PD- /backup/INFORMIX/data57.dat
e0dd8a28 67 5 0 1024000 541245 PO- /home/informix/psck5701/dpchk05
e0dd8b98 68 5 0 1024000 462653 PO- /home/informix/psck5701/dpchk10
e0dd8d08 69 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk19
e0dd8e78 70 4 0 1024000 1 PO- /home/informix/psck5701/dpchk43
e0dd9018 71 4 0 1024000 0 PO- /home/informix/psck5701/dpchk34
e0dd9188 72 2 512001 500000 499997 PO- /home/informix/psck5701/dpchk52
e0dd92f8 73 6 0 1024000 0 PD- /backup/INFORMIX/data1.dat
e0dd9468 74 6 0 1024000 0 PD- /backup/INFORMIX/data2.dat
e0dd95d8 75 7 0 400000 380417 PO- /home/informix/psck5701/dpchk67
e0dd9748 76 6 0 1024000 0 PD- /backup/INFORMIX/data3.dat
e0dd98b8 77 6 0 1024000 0 PD- /backup/INFORMIX/data4.dat
e0dd9a28 78 6 0 1024000 0 PD- /backup/INFORMIX/data5.dat
e0dd9b98 79 6 0 1024000 0 PD- /backup/INFORMIX/data6.dat
e0dd9d08 80 6 0 1024000 0 PD- /backup/INFORMIX/data7.dat
e0dd9e78 81 6 0 1024000 0 PD- /backup/INFORMIX/data8.dat
e0dda018 82 6 0 1024000 0 PD- /backup/INFORMIX/data9.dat
e0dda188 83 6 0 1024000 0 PD- /backup/INFORMIX/data10.dat
e0dda2f8 84 6 0 1024000 0 PD- /backup/INFORMIX/data11.dat
e0dda468 85 6 0 1024000 0 PD- /backup/INFORMIX/data12.dat
e0dda5d8 86 6 0 1024000 0 PD- /backup/INFORMIX/data13.dat
e0dda748 87 6 0 1024000 0 PD- /backup/INFORMIX/data14.dat
e0dda8b8 88 6 0 1024000 0 PD- /backup/INFORMIX/data15.dat
e0ddaa28 89 6 0 1024000 0 PD- /backup/INFORMIX/data16.dat
e0ddab98 90 6 0 1024000 0 PD- /backup/INFORMIX/data17.dat
e0ddad08 91 6 0 1024000 0 PD- /backup/INFORMIX/data18.dat
e0ddae78 92 6 0 1024000 0 PD- /backup/INFORMIX/data19.dat
e0ddb018 93 6 0 1024000 0 PD- /backup/INFORMIX/data20.dat
e0ddb188 94 6 0 1024000 0 PD- /backup/INFORMIX/data21.dat
e0ddb2f8 95 6 0 1024000 0 PD- /backup/INFORMIX/data22.dat
e0ddb468 96 6 0 1024000 0 PD- /backup/INFORMIX/data23.dat
e0ddb5d8 97 6 0 1024000 0 PD- /backup/INFORMIX/data24.dat
e0ddb748 98 6 0 1024000 0 PD- /backup/INFORMIX/data25.dat
e0ddb8b8 99 6 0 1024000 0 PD- /backup/INFORMIX/data26.dat
e0ddba28 100 6 0 1024000 0 PD- /backup/INFORMIX/data27.dat
e0ddbb98 101 6 0 1024000 0 PD- /backup/INFORMIX/data28.dat
e0ddbd08 102 6 0 1024000 0 PD- /backup/INFORMIX/data29.dat
e0ddbe78 103 6 0 1024000 0 PD- /backup/INFORMIX/data30.dat
e0ddc018 104 6 0 1024000 0 PD- /backup/INFORMIX/data31.dat
e0ddc188 105 6 0 1024000 0 PD- /backup/INFORMIX/data32.dat
e0ddc2f8 106 4 0 1024000 789685 PO- /home/informix/psck5701/dpchk44
e0ddc468 107 4 0 1024000 1023997 PO- /home/informix/psck5701/dpchk45
e0ddc5d8 108 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk46
e0ddc748 109 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk48
e0ddc8b8 110 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk49
e0ddca28 111 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk50
e0ddcb98 112 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk53
e0ddcd08 113 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk54
e0ddce78 114 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk55
e0ddd018 115 5 0 512000 511997 PO- /home/informix/psck5701/dpchk58
e0ddd188 116 5 0 512000 511997 PO- /home/informix/psck5701/dpchk59
e0ddd2f8 117 5 0 512000 511997 PO- /home/informix/psck5701/dpchk60
e0ddd468 118 5 0 512000 511997 PO- /home/informix/psck5701/dpchk61
e0ddd5d8 119 5 0 512000 511997 PO- /home/informix/psck5701/dpchk65
e0ddd748 120 5 0 512000 511997 PO- /home/informix/psck5701/dpchk66
e0ddd8b8 121 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk27
e0ddda28 122 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk28
e0dddb98 123 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk29
e0dddd08 124 5 0 1024000 1023997 PO- /home/informix/psck5701/dpchk30
e0ddde78 125 6 0 1024000 0 PD- /backup/INFORMIX/data58.dat
e0de2018 126 6 0 1024000 0 PD- /backup/INFORMIX/data59.dat
e0de2188 127 6 0 1024000 0 PD- /backup/INFORMIX/data60.dat
e0de22f8 128 6 0 1024000 0 PD- /backup/INFORMIX/data61.dat
e0de2468 129 6 0 1024000 0 PD- /backup/INFORMIX/data62.dat
e0de25d8 130 6 0 1024000 0 PD- /backup/INFORMIX/data63.dat 130 active, 2047
maximum
I cut some part from online.log.
20:16:22 Maximum server connections 104 20:19:50 Logical Log 299852
Complete.
20:22:14 Assert Failed: I/O error, Primary Chunk
'/backup/INFORMIX/data63.dat'
-- Offline
20:22:14 Informix Dynamic Server Version 9.30.HC3
20:22:14 Who: Thread(19, flush_sub(0), dfbd6624, 1)
File: rsbuff.c Line: 4086
20:22:14 Results: Chunk is now unusable
20:22:14 Action: Repair and restore from mirror or archive
20:22:14 stack trace for pid 20455 written to /tmp/af.3fba075
20:22:14 See Also: /tmp/af.3fba075
20:22:15 I/O error, Primary Chunk '/backup/INFORMIX/data63.dat' -- Offline
20:23:18 Assert Failed: Chunk 130 is being taken OFFLINE.
20:23:18 Informix Dynamic Server Version 9.30.HC3
20:23:18 Who: Thread(19, flush_sub(0), dfbd6624, 1)
File: rsmirror.c Line: 1847
20:23:18 Results: Dynamic Server will block at next checkpoint
20:23:18 Action: Shutdown (onmode -k) or override (onmode -O)
20:23:18 stack trace for pid 20455 written to /tmp/af.3fba075
20:23:18 See Also: /tmp/af.3fba075
20:23:18 Chunk 130 is being taken OFFLINE.
20:23:34 I/O write chunk 130, pagenum 584917, pagecnt 1 --> errno = 2
20:23:34 Checkpoint blocked by down space, waiting for override or shutdown
Thu May 4 19:04:05 2006
19:04:05 Event alarms enabled. ALARMPROG = '/home/informix/logs/log_full.sh'
19:04:06 Booting Language <c> from module <>
19:04:06 Loading Module <CNULL>
19:04:06 Booting Language <builtin> from module <>
19:04:06 Loading Module <BUILTINNULL>
19:04:12 Dynamically allocated new virtual shared memory segment (size
8000KB)
19:04:12 Informix Dynamic Server Version 9.30.HC3 Software Serial Number
AAD#A361521
19:04:14 Informix Dynamic Server Initialized -- Shared Memory Initialized.
19:04:14 Physical Recovery Started at Page(1:757).
19:04:15 Physical Recovery Complete: 601 Pages Examined 599 Pages Restored.
19:04:15 Logical Recovery Started.
19:04:15 10 recovery worker threads will be started.
19:09:16 I/O read chunk 130, pagenum 584916, pagecnt 1 --> errno = 5
19:09:16 Rollforward of log record failed. iserrno = 126
19:09:16 Log Record: log = 299852, pos = 0x154445c, type =
OLDRSAM:HINSERT(40), trans = 20
19:09:17 Ignoring the ONDBSPACEDOWN option during logical recovery. Dynamic
Server will NOT BLOCK at the next checkpoint
19:10:19 Assert Failed: Chunk 73 is being taken OFFLINE.
19:10:19 Informix Dynamic Server Version 9.30.HC3
19:10:19 Who: Session(11, informix@pscrp740, 0, -571108388)
Thread(29, xchg_1.3, ddf2b29c, 1)
File: rsmirror.c Line: 1854
19:10:19 Results: DBspace dbspace3 is disabled.
19:10:19 Action: Restore DBspace dbspace3
19:10:19 stack trace for pid 3551 written to /tmp/af.405e0db
19:10:19 See Also: /tmp/af.405e0db
19:10:19 Chunk 73 is being taken OFFLINE.
19:10:19 Rollforward of log record failed. iserrno = 126
I try to do some command. But got error.
> onspaces -s dbspace3 -p /backup/INFORMIX/data1.dat -o 0 -O
Warning: Bringing chunk back online.
Do you really want to continue? (y/n)y
Verifying physical disk space, please wait ...
Cannot change chunk status.
ISAM error: illegal argument to ISAM function.
Please help me. Thank you.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
