论坛 › Informix › 求助informix 0级备份失败

ywmljr 发表于 2010-06-08 17:28

求助informix 0级备份失败

在之前先谢过各位了


备份到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:13Checkpoint Completed:duration was 0 seconds.
01:42:13Checkpoint loguniq 8833, logpos 0xe93018

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


02:02:52Informix 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:53Archive on rootdbs, logdbs, phydbs, workdbs ABORTED.
02:02:53ISAM error:An error has occurred during archive back up.


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

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

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

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

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

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

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

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

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

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

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

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

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

14:43:43Logical Log 8833 Complete.
14:43:48Process 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:27I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
15:43:51Checkpoint Completed:duration was 3 seconds.
15:43:51Checkpoint loguniq 8834, logpos 0x40f018

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

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

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

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

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

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

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

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


Thu May 27 00:12:32 2010

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

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

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

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

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

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

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

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

08:12:31I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
08:12:32Logical Log 8834 Complete.
08:12:37Process 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:35Checkpoint Completed:duration was 3 seconds.
08:45:35Checkpoint loguniq 8835, logpos 0x1de018

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

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

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

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

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

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

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

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

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

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

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

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

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

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

23:01:42Logical Log 8835 Complete.
23:01:48Process 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:29I/O read chunk 7, pagenum 374041, pagecnt 1 --> errno = 5
23:47:49Checkpoint Completed:duration was 4 seconds.
23:47:49Checkpoint loguniq 8836, logpos 0x28b20c


Fri May 28 00:12:28 2010

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

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

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

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

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

liaosnet 发表于 2010-06-08 21:10

本帖最后由 liaosnet 于 2010-06-08 21:13 编辑

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

可怜的孩子~{:3_196:}
这个lv应该是workdbs上的,应该是出现读取失败问题了..有可能的话先dbexport整个库出来;删除这个chunk

或者把在这个chunk上的表都先导出来;删除这些表;重建下chunk;再重建那些表..

最近存储做过什么操作没?

liaosnet 发表于 2010-06-08 21:15

尝试使用oncheck -cDI dbname 检查下这个库..看有什么错误...也许能定位到具体某个表的问题..

ywmljr 发表于 2010-06-09 09:02

最近更换过一块硬盘，现在datadg 上还有一块硬盘有错误
c2t2d0          Soft Errors: 0 Hard Errors: 7058 Transport Errors: 502
不过做的是镜像，另外一块盘一切正常.

ywmljr 发表于 2010-06-09 09:03

Disk group: datadg

DG NAME         NCONFIG      NLOG   MINORS   GROUP-ID
DM NAME         DEVICE       TYPE   PRIVLENPUBLEN   STATE
VNAME         USETYPE      KSTATE   STATE    LENGTH   READPOL   PREFPLEX
PL NAME         VOLUME       KSTATE   STATE    LENGTH   LAYOUT    NCOL/WID MODE
SD NAME         PLEX         DISK   DISKOFFS LENGTH   OFF DEVICE   MODE
SV NAME         PLEX         VOLNAMENVOLLAYR LENGTH   OFF AM/NM    MODE

dg datadg       default      default84000    1047712675.1061.smp1

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

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

vlvlogdbs   gen          ENABLEDACTIVE   2048000SELECT    -
pl lvlogdbs-01lvlogdbs   ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg01-03lvlogdbs-01datadg01 30750512 20497200         c1t2d0   ENA
pl lvlogdbs-02lvlogdbs   ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg02-03lvlogdbs-02datadg02 30750512 20497200         c2t2d0   ENA

vlvphydbs   gen          ENABLEDACTIVE   2048000SELECT    -
pl lvphydbs-01lvphydbs   ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg01-04lvphydbs-01datadg01 32800232 20497200         c1t2d0   ENA
pl lvphydbs-02lvphydbs   ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg02-04lvphydbs-02datadg02 32800232 20497200         c2t2d0   ENA

vlvrootdbs    gen          ENABLEDACTIVE   409600   SELECT    -
pl lvrootdbs-01 lvrootdbs    ENABLEDACTIVE   409944   CONCAT    -      RW
sd datadg01-02lvrootdbs-01 datadg01 4712   409944   0         c1t2d0   ENA
pl lvrootdbs-02 lvrootdbs    ENABLEDACTIVE   409944   CONCAT    -      RW
sd datadg02-02lvrootdbs-02 datadg02 4712   409944   0         c2t2d0   ENA

vlvtempdbs1   gen          ENABLEDACTIVE   2048000SELECT    -
pl lvtempdbs1-01 lvtempdbs1ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg01-05lvtempdbs1-01 datadg01 2054432 20497200         c1t2d0   ENA
pl lvtempdbs1-02 lvtempdbs1ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg02-05lvtempdbs1-02 datadg02 2054432 20497200         c2t2d0   ENA

vlvtempdbs2   gen          ENABLEDACTIVE   2048000SELECT    -
pl lvtempdbs2-01 lvtempdbs2ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg01-06lvtempdbs2-01 datadg01 4104152 20497200         c1t2d0   ENA
pl lvtempdbs2-02 lvtempdbs2ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg02-06lvtempdbs2-02 datadg02 4104152 20497200         c2t2d0   ENA

vlvworkdbs1   gen          ENABLEDACTIVE   4096000SELECT    -
pl lvworkdbs1-01 lvworkdbs1ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg01-07lvworkdbs1-01 datadg01 6153872 40994400         c1t2d0   ENA
pl lvworkdbs1-02 lvworkdbs1ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg02-07lvworkdbs1-02 datadg02 6153872 40994400         c2t2d0   ENA

vlvworkdbs2   gen          ENABLEDACTIVE   4096000SELECT    -
pl lvworkdbs2-01 lvworkdbs2DETACHED STALE    4099440CONCAT    -      WO
sd datadg01-08lvworkdbs2-01 datadg01 10253312 4099440 0         c1t2d0   RLOC
pl lvworkdbs2-02 lvworkdbs2ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg02-08lvworkdbs2-02 datadg02 10253312 4099440 0         c2t2d0   ENA

vlvworkdbs3   gen          ENABLEDACTIVE   4096000SELECT    -
pl lvworkdbs3-01 lvworkdbs3ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg01-09lvworkdbs3-01 datadg01 14352752 4099440 0         c1t2d0   ENA
pl lvworkdbs3-02 lvworkdbs3ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg02-09lvworkdbs3-02 datadg02 14352752 4099440 0         c2t2d0   ENA

vlvworkdbs4   gen          ENABLEDACTIVE   4096000SELECT    -
pl lvworkdbs4-01 lvworkdbs4ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg01-10lvworkdbs4-01 datadg01 18452192 4099440 0         c1t2d0   ENA
pl lvworkdbs4-02 lvworkdbs4ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg02-10lvworkdbs4-02 datadg02 18452192 4099440 0         c2t2d0   ENA

vlvworkdbs5   gen          ENABLEDACTIVE   4096000SELECT    -
pl lvworkdbs5-01 lvworkdbs5ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg01-11lvworkdbs5-01 datadg01 22551632 4099440 0         c1t2d0   ENA
pl lvworkdbs5-02 lvworkdbs5ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg02-11lvworkdbs5-02 datadg02 22551632 4099440 0         c2t2d0   ENA

vlvworkdbs6   gen          ENABLEDACTIVE   4096000SELECT    -
pl lvworkdbs6-01 lvworkdbs6DETACHED STALE    4099440CONCAT    -      WO
sd datadg01-12lvworkdbs6-01 datadg01 26651072 4099440 0         c1t2d0   RLOC
pl lvworkdbs6-02 lvworkdbs6ENABLEDACTIVE   4099440CONCAT    -      RW
sd datadg02-12lvworkdbs6-02 datadg02 26651072 4099440 0         c2t2d0   ENA

vlvworkdbs7   gen          ENABLEDACTIVE   2048000SELECT    -
pl lvworkdbs7-01 lvworkdbs7ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg01-13lvworkdbs7-01 datadg01 41465616397760         c1t2d0   ENA
sd datadg01-14lvworkdbs7-01 datadg01 34849952 4099441639776   c1t2d0   ENA
pl lvworkdbs7-02 lvworkdbs7ENABLEDACTIVE   2049720CONCAT    -      RW
sd datadg02-13lvworkdbs7-02 datadg02 41465616397760         c2t2d0   ENA
sd datadg02-14lvworkdbs7-02 datadg02 34849952 4099441639776   c2t2d0   ENA

ywmljr 发表于 2010-06-09 09:08

还有就是双机现在运行正常，只是备份出问题。先谢谢各位了

ywmljr 发表于 2010-06-09 10:50

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 发表于 2010-06-09 11:10

还有就是双机现在运行正常，只是备份出问题。先谢谢各位了
ywmljr 发表于 2010-06-09 09:08 http://bbs3.chinaunix.net/images/common/back.gif


    你这SMP是冷双机的..事实上的数据库就只有一个的..还是做下oncheck -cDI smpdb看下吧~

ywmljr 发表于 2010-06-09 13:27

本帖最后由 ywmljr 于 2010-06-09 13:29 编辑

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 发表于 2010-06-09 14:39

尝试修复ix_statet.. oncheck -cI smpdb:smpstatinfo#ix_statet      

要不修复不成功,删除ix_statet,然后重建即可...如果没有别的问题,0级备份应该可以正常.

再:重建后记得对该表做次update statistics

查看完整版本: 求助informix 0级备份失败