求助informix 0級備份失敗

ywmljr

在之前先謝過各位了


備份到20%的時候就直接跳到100% 錯誤提示為

smp%1 ontape -s -L 0
Please mount tape 1 on /dev/rmt/0m and press Return to continue ...
10 percent done.
20 percent done
100 percent done
Archive failed - ISAM error:  An error has occurred during archive back up





smp1% more *log
01:42:13  Checkpoint Completed:  duration was 0 seconds.
01:42:13  Checkpoint loguniq 8833, logpos 0xe93018

01:42:14  Level 0 Archive started on rootdbs, logdbs, phydbs, workdbs
02:02:52  I/O read chunk 7, pagenum 314478, pagecnt 8 --> errno = 5
02:02:52  Assert Failed: ISAM error:  An error has occurred during archive back
up.


02:02:52  Informix Dynamic Server Version 7.31.UD2R1
02:02:52   Who: Session(17671825, informix@smp1, 17126, 411952392)
                Thread(17741010, arcbackup1, 188ba560, 1)
                File: rsarcutl.c Line: 127
02:02:52   Action: arc_pages()/bfphysio()
02:02:53   See Also: /opt/informix/temp/af.b8ba10cc
02:02:53  Archive on rootdbs, logdbs, phydbs, workdbs ABORTED.
02:02:53  ISAM error:  An error has occurred during archive back up.


02:13:19  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
02:42:24  Checkpoint Completed:  duration was 0 seconds.
02:42:24  Checkpoint loguniq 8833, logpos 0x113e018

03:12:37  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
03:42:28  Checkpoint Completed:  duration was 0 seconds.
03:42:28  Checkpoint loguniq 8833, logpos 0x13e8018

04:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
04:42:32  Checkpoint Completed:  duration was 0 seconds.
04:42:32  Checkpoint loguniq 8833, logpos 0x168d018

05:12:32  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
05:42:36  Checkpoint Completed:  duration was 0 seconds.
05:42:36  Checkpoint loguniq 8833, logpos 0x1937018

06:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
06:42:41  Checkpoint Completed:  duration was 0 seconds.
06:42:41  Checkpoint loguniq 8833, logpos 0x1be9018

07:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
07:42:46  Checkpoint Completed:  duration was 1 seconds.
07:42:46  Checkpoint loguniq 8833, logpos 0x1ece018

08:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
08:42:53  Checkpoint Completed:  duration was 2 seconds.
08:42:53  Checkpoint loguniq 8833, logpos 0x2216018

09:12:30  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
09:43:01  Checkpoint Completed:  duration was 3 seconds.
09:43:01  Checkpoint loguniq 8833, logpos 0x25e9154

10:12:30  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
10:43:10  Checkpoint Completed:  duration was 4 seconds.
10:43:10  Checkpoint loguniq 8833, logpos 0x2a05018

11:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
11:43:18  Checkpoint Completed:  duration was 4 seconds.
11:43:18  Checkpoint loguniq 8833, logpos 0x2e73018

12:12:26  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
12:43:27  Checkpoint Completed:  duration was 5 seconds.
12:43:27  Checkpoint loguniq 8833, logpos 0x32cc018

13:12:28  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
13:43:36  Checkpoint Completed:  duration was 4 seconds.
13:43:36  Checkpoint loguniq 8833, logpos 0x36c2018

14:12:26  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
14:43:43  Checkpoint Completed:  duration was 3 seconds.
14:43:43  Checkpoint loguniq 8833, logpos 0x3a97534

14:43:43  Logical Log 8833 Complete.
14:43:48  Process exited with return code 142: /bin/sh /bin/sh -c /opt/informix/
etc/log_full.sh 2 23 "Logical Log 8833 Complete." "Logical Log 8833 Complete."
15:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
15:43:51  Checkpoint Completed:  duration was 3 seconds.
15:43:51  Checkpoint loguniq 8834, logpos 0x40f018

16:12:25  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
16:43:58  Checkpoint Completed:  duration was 3 seconds.
16:43:58  Checkpoint loguniq 8834, logpos 0x7ea018

17:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
17:44:05  Checkpoint Completed:  duration was 4 seconds.
17:44:05  Checkpoint loguniq 8834, logpos 0xbb3018

18:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
18:44:14  Checkpoint Completed:  duration was 4 seconds.
18:44:14  Checkpoint loguniq 8834, logpos 0xfa9018

19:12:29  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
19:44:23  Checkpoint Completed:  duration was 4 seconds.
19:44:23  Checkpoint loguniq 8834, logpos 0x1392018

20:12:30  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
20:44:32  Checkpoint Completed:  duration was 5 seconds.
20:44:32  Checkpoint loguniq 8834, logpos 0x178b018

21:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
21:44:43  Checkpoint Completed:  duration was 6 seconds.
21:44:43  Checkpoint loguniq 8834, logpos 0x1b98018

22:13:08  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
22:44:48  Checkpoint Completed:  duration was 5 seconds.
22:44:48  Checkpoint loguniq 8834, logpos 0x1f93018

23:13:05  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
23:44:52  Checkpoint Completed:  duration was 4 seconds.
23:44:52  Checkpoint loguniq 8834, logpos 0x2325018


Thu May 27 00:12:32 2010

00:12:32  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
00:44:58  Checkpoint Completed:  duration was 1 seconds.
00:44:58  Checkpoint loguniq 8834, logpos 0x2600018

01:12:33  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
01:45:02  Checkpoint Completed:  duration was 0 seconds.
01:45:02  Checkpoint loguniq 8834, logpos 0x28ba018

02:12:28  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
02:45:06  Checkpoint Completed:  duration was 0 seconds.
02:45:06  Checkpoint loguniq 8834, logpos 0x2b68018

03:12:30  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
03:45:10  Checkpoint Completed:  duration was 0 seconds.
03:45:10  Checkpoint loguniq 8834, logpos 0x2e15018

04:12:33  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
04:45:15  Checkpoint Completed:  duration was 0 seconds.
04:45:15  Checkpoint loguniq 8834, logpos 0x30be018

05:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
05:45:19  Checkpoint Completed:  duration was 0 seconds.
05:45:19  Checkpoint loguniq 8834, logpos 0x3365154

06:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
06:45:23  Checkpoint Completed:  duration was 0 seconds.
06:45:23  Checkpoint loguniq 8834, logpos 0x3619154

07:12:30  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
07:45:28  Checkpoint Completed:  duration was 1 seconds.
07:45:28  Checkpoint loguniq 8834, logpos 0x38fc018

08:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
08:12:32  Logical Log 8834 Complete.
08:12:37  Process exited with return code 142: /bin/sh /bin/sh -c /opt/informix/
etc/log_full.sh 2 23 "Logical Log 8834 Complete." "Logical Log 8834 Complete."
08:45:35  Checkpoint Completed:  duration was 3 seconds.
08:45:35  Checkpoint loguniq 8835, logpos 0x1de018

09:12:30  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
09:45:43  Checkpoint Completed:  duration was 3 seconds.
09:45:43  Checkpoint loguniq 8835, logpos 0x5a2018

10:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
10:45:51  Checkpoint Completed:  duration was 4 seconds.
10:45:51  Checkpoint loguniq 8835, logpos 0x9a3018

11:12:32  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
11:46:00  Checkpoint Completed:  duration was 4 seconds.
11:46:00  Checkpoint loguniq 8835, logpos 0xde0018

12:12:33  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
12:46:09  Checkpoint Completed:  duration was 5 seconds.
12:46:09  Checkpoint loguniq 8835, logpos 0x120c018

13:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
13:46:18  Checkpoint Completed:  duration was 5 seconds.
13:46:18  Checkpoint loguniq 8835, logpos 0x15f1018

14:12:28  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
14:46:27  Checkpoint Completed:  duration was 3 seconds.
14:46:27  Checkpoint loguniq 8835, logpos 0x19b4018

15:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
15:46:34  Checkpoint Completed:  duration was 4 seconds.
15:46:34  Checkpoint loguniq 8835, logpos 0x1db2154

16:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
16:46:43  Checkpoint Completed:  duration was 4 seconds.
16:46:43  Checkpoint loguniq 8835, logpos 0x21b2018

17:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
17:46:52  Checkpoint Completed:  duration was 5 seconds.
17:46:52  Checkpoint loguniq 8835, logpos 0x25ec018

18:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
18:47:01  Checkpoint Completed:  duration was 5 seconds.
18:47:01  Checkpoint loguniq 8835, logpos 0x29b5018

19:12:32  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
19:47:10  Checkpoint Completed:  duration was 5 seconds.
19:47:10  Checkpoint loguniq 8835, logpos 0x2d8d018

20:12:26  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
20:47:19  Checkpoint Completed:  duration was 5 seconds.
20:47:19  Checkpoint loguniq 8835, logpos 0x316f018

21:12:31  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
21:47:30  Checkpoint Completed:  duration was 6 seconds.
21:47:30  Checkpoint loguniq 8835, logpos 0x358c018

22:12:28  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
22:47:40  Checkpoint Completed:  duration was 6 seconds.
22:47:40  Checkpoint loguniq 8835, logpos 0x39b2018

23:01:42  Logical Log 8835 Complete.
23:01:48  Process exited with return code 142: /bin/sh /bin/sh -c /opt/informix/
etc/log_full.sh 2 23 "Logical Log 8835 Complete." "Logical Log 8835 Complete."
23:12:29  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
23:47:49  Checkpoint Completed:  duration was 4 seconds.
23:47:49  Checkpoint loguniq 8836, logpos 0x28b20c


Fri May 28 00:12:28 2010

00:12:28  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
00:47:54  Checkpoint Completed:  duration was 1 seconds.
00:47:54  Checkpoint loguniq 8836, logpos 0x56b018

01:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
01:48:00  Checkpoint Completed:  duration was 0 seconds.
01:48:00  Checkpoint loguniq 8836, logpos 0x824018

02:12:26  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
02:48:05  Checkpoint Completed:  duration was 0 seconds.
02:48:05  Checkpoint loguniq 8836, logpos 0xad2018

03:12:27  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
03:48:09  Checkpoint Completed:  duration was 0 seconds.
03:48:09  Checkpoint loguniq 8836, logpos 0xd7b018

04:12:25  I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
--More--(15%)

liaosnet

I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5

可憐的孩子~{:3_196:}
這個lv應(yīng)該是workdbs上的,應(yīng)該是出現(xiàn)讀取失敗問題了..有可能的話先dbexport整個庫出來;刪除這個chunk

或者把在這個chunk上的表都先導(dǎo)出來;刪除這些表;重建下chunk;再重建那些表..

最近存儲做過什么操作沒?

liaosnet

嘗試使用oncheck -cDI dbname 檢查下這個庫..看有什么錯誤...也許能定位到具體某個表的問題..

ywmljr

最近更換過一塊硬盤，現(xiàn)在datadg 上還有一塊硬盤有錯誤
c2t2d0          Soft Errors: 0 Hard Errors: 7058 Transport Errors: 502
不過做的是鏡像，另外一塊盤一切正常.

ywmljr

Disk group: datadg

DG NAME         NCONFIG      NLOG     MINORS   GROUP-ID
DM NAME         DEVICE       TYPE     PRIVLEN  PUBLEN   STATE
V  NAME         USETYPE      KSTATE   STATE    LENGTH   READPOL   PREFPLEX
PL NAME         VOLUME       KSTATE   STATE    LENGTH   LAYOUT    NCOL/WID MODE
SD NAME         PLEX         DISK     DISKOFFS LENGTH   [COL/]OFF DEVICE   MODE
SV NAME         PLEX         VOLNAME  NVOLLAYR LENGTH   [COL/]OFF AM/NM    MODE

dg datadg       default      default  84000    1047712675.1061.smp1

dm datadg01     c1t2d0s2     sliced   4711     35363560 -
dm datadg02     c2t2d0s2     sliced   4711     35363560 -

v  datadg-stat  fsgen        ENABLED  ACTIVE   4096     SELECT    -
pl datadg-stat-01 datadg-stat ENABLED ACTIVE   4712     CONCAT    -        RW
sd datadg01-01  datadg-stat-01 datadg01 0      4712     0         c1t2d0   ENA
pl datadg-stat-02 datadg-stat ENABLED ACTIVE   4712     CONCAT    -        RW
sd datadg02-01  datadg-stat-02 datadg02 0      4712     0         c2t2d0   ENA

v  lvlogdbs     gen          ENABLED  ACTIVE   2048000  SELECT    -
pl lvlogdbs-01  lvlogdbs     ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg01-03  lvlogdbs-01  datadg01 30750512 2049720  0         c1t2d0   ENA
pl lvlogdbs-02  lvlogdbs     ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg02-03  lvlogdbs-02  datadg02 30750512 2049720  0         c2t2d0   ENA

v  lvphydbs     gen          ENABLED  ACTIVE   2048000  SELECT    -
pl lvphydbs-01  lvphydbs     ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg01-04  lvphydbs-01  datadg01 32800232 2049720  0         c1t2d0   ENA
pl lvphydbs-02  lvphydbs     ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg02-04  lvphydbs-02  datadg02 32800232 2049720  0         c2t2d0   ENA

v  lvrootdbs    gen          ENABLED  ACTIVE   409600   SELECT    -
pl lvrootdbs-01 lvrootdbs    ENABLED  ACTIVE   409944   CONCAT    -        RW
sd datadg01-02  lvrootdbs-01 datadg01 4712     409944   0         c1t2d0   ENA
pl lvrootdbs-02 lvrootdbs    ENABLED  ACTIVE   409944   CONCAT    -        RW
sd datadg02-02  lvrootdbs-02 datadg02 4712     409944   0         c2t2d0   ENA

v  lvtempdbs1   gen          ENABLED  ACTIVE   2048000  SELECT    -
pl lvtempdbs1-01 lvtempdbs1  ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg01-05  lvtempdbs1-01 datadg01 2054432 2049720  0         c1t2d0   ENA
pl lvtempdbs1-02 lvtempdbs1  ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg02-05  lvtempdbs1-02 datadg02 2054432 2049720  0         c2t2d0   ENA

v  lvtempdbs2   gen          ENABLED  ACTIVE   2048000  SELECT    -
pl lvtempdbs2-01 lvtempdbs2  ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg01-06  lvtempdbs2-01 datadg01 4104152 2049720  0         c1t2d0   ENA
pl lvtempdbs2-02 lvtempdbs2  ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg02-06  lvtempdbs2-02 datadg02 4104152 2049720  0         c2t2d0   ENA

v  lvworkdbs1   gen          ENABLED  ACTIVE   4096000  SELECT    -
pl lvworkdbs1-01 lvworkdbs1  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg01-07  lvworkdbs1-01 datadg01 6153872 4099440  0         c1t2d0   ENA
pl lvworkdbs1-02 lvworkdbs1  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg02-07  lvworkdbs1-02 datadg02 6153872 4099440  0         c2t2d0   ENA

v  lvworkdbs2   gen          ENABLED  ACTIVE   4096000  SELECT    -
pl lvworkdbs2-01 lvworkdbs2  DETACHED STALE    4099440  CONCAT    -        WO
sd datadg01-08  lvworkdbs2-01 datadg01 10253312 4099440 0         c1t2d0   RLOC
pl lvworkdbs2-02 lvworkdbs2  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg02-08  lvworkdbs2-02 datadg02 10253312 4099440 0         c2t2d0   ENA

v  lvworkdbs3   gen          ENABLED  ACTIVE   4096000  SELECT    -
pl lvworkdbs3-01 lvworkdbs3  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg01-09  lvworkdbs3-01 datadg01 14352752 4099440 0         c1t2d0   ENA
pl lvworkdbs3-02 lvworkdbs3  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg02-09  lvworkdbs3-02 datadg02 14352752 4099440 0         c2t2d0   ENA

v  lvworkdbs4   gen          ENABLED  ACTIVE   4096000  SELECT    -
pl lvworkdbs4-01 lvworkdbs4  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg01-10  lvworkdbs4-01 datadg01 18452192 4099440 0         c1t2d0   ENA
pl lvworkdbs4-02 lvworkdbs4  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg02-10  lvworkdbs4-02 datadg02 18452192 4099440 0         c2t2d0   ENA

v  lvworkdbs5   gen          ENABLED  ACTIVE   4096000  SELECT    -
pl lvworkdbs5-01 lvworkdbs5  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg01-11  lvworkdbs5-01 datadg01 22551632 4099440 0         c1t2d0   ENA
pl lvworkdbs5-02 lvworkdbs5  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg02-11  lvworkdbs5-02 datadg02 22551632 4099440 0         c2t2d0   ENA

v  lvworkdbs6   gen          ENABLED  ACTIVE   4096000  SELECT    -
pl lvworkdbs6-01 lvworkdbs6  DETACHED STALE    4099440  CONCAT    -        WO
sd datadg01-12  lvworkdbs6-01 datadg01 26651072 4099440 0         c1t2d0   RLOC
pl lvworkdbs6-02 lvworkdbs6  ENABLED  ACTIVE   4099440  CONCAT    -        RW
sd datadg02-12  lvworkdbs6-02 datadg02 26651072 4099440 0         c2t2d0   ENA

v  lvworkdbs7   gen          ENABLED  ACTIVE   2048000  SELECT    -
pl lvworkdbs7-01 lvworkdbs7  ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg01-13  lvworkdbs7-01 datadg01 414656  1639776  0         c1t2d0   ENA
sd datadg01-14  lvworkdbs7-01 datadg01 34849952 409944  1639776   c1t2d0   ENA
pl lvworkdbs7-02 lvworkdbs7  ENABLED  ACTIVE   2049720  CONCAT    -        RW
sd datadg02-13  lvworkdbs7-02 datadg02 414656  1639776  0         c2t2d0   ENA
sd datadg02-14  lvworkdbs7-02 datadg02 34849952 409944  1639776   c2t2d0   ENA

ywmljr

還有就是雙機現(xiàn)在運行正常，只是備份出問題。先謝謝各位了

ywmljr

FREE                                                        357899         6
        smpdb:smpsys.basetab_ccs                         357905     12800
        smpdb:smpsys.basetab_230_dump                370705      2896
        smpdb:smpsys.smpstatinfo                          373601      1376
        smpdb:smpsys.aps_transferlog                     374977        48
        smpdb:smpsys.basetab_213                        375025        16
        smpdb:smpsys.deadlockpro_log                    375041         8
        smpdb:smpsys.gettable                              375049         8
        smpdb:sysman.batch_pinnum_225                375057         8

liaosnet

還有就是雙機現(xiàn)在運行正常，只是備份出問題。先謝謝各位了
ywmljr 發(fā)表于 2010-06-09 09:08

    你這SMP是冷雙機的..事實上的數(shù)據(jù)庫就只有一個的..還是做下oncheck -cDI smpdb看下吧~

ywmljr

Could not check rowids and perform data<->index check
ISAM error: Primary and Mirror chunks are bad
                Index ix_statet





Could not bfget pagenum eeba, iserrno 0
ERROR:  Index ix_statet for smpdb:smpsys.smpstatinfo is bad.

WARNING: Check of index ix_statst was not completed.

Index ix_statet is bad.  OK to repair it?

liaosnet

嘗試修復(fù)ix_statet.. oncheck -cI smpdb:smpstatinfo#ix_statet      

要不修復(fù)不成功,刪除ix_statet,然后重建即可...如果沒有別的問題,0級備份應(yīng)該可以正常.

再:重建后記得對該表做次update statistics