|
IDS Forum
Re: how to enable dbspace
Posted By: Yunyao (Frank) Qu Date: Thursday, 11 May 2006, at 11:50 a.m.
In Response To: how to enable dbspace (CHANATIP LAONGSIRIWONG)
you must restore from level 0 backup.
Thanks,
Frank
CHANATIP LA.... wrote:
>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.
>
>
>
>
--
Yunyao "Frank" Qu
Computer Sciences Corporation(CSC)
NOAA/CLASS, (301)817-4696
Messages In This Thread
IDS Forum is maintained by Administrator with WebBBS 5.12.
|
|