论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2007-04-04 12:45 |只看该作者 |倒序浏览

求救：

  机器突然坏了，恢复后的硬盘数据可以找回来，但数据库日志不一致，应该是crash吧。connect的时候报错。是循环日志。
2007-04-04-09.57.29.941467+480 I31199153G368    LEVEL: Warning
PID    : 7843                TID  : 8192       PROC : db2agent (REMCLOB)
INSTANCE: db2inst1          NODE : 000       DB : REMCLOB
APPHDL  : 0-7                APPID: *LOCAL.db2inst1.070404015729
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2007-04-04-09.57.29.993322+480 I31199522G431    LEVEL: Warning
PID    : 7843                TID  : 8192       PROC : db2agent (REMCLOB)
INSTANCE: db2inst1          NODE : 000       DB : REMCLOB
APPHDL  : 0-7                APPID: *LOCAL.db2inst1.070404015729
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000000036B00629 MinbuffLSN
      0000000036B005A4

2007-04-04-09.57.30.103094+480 I31199954G409    LEVEL: Warning
PID    : 7843                TID  : 8192       PROC : db2agent (REMCLOB)
INSTANCE: db2inst1          NODE : 000       DB : REMCLOB
APPHDL  : 0-7                APPID: *LOCAL.db2inst1.070404015729
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 3 QSets 9 queues and 2 chunks

2007-04-04-09.57.33.520742+480 I31200364G319    LEVEL: Severe
PID    : 7855                TID  : 8192       PROC : db2shred (REMCLOB)
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpshrBuildRecord, probe:1040
MESSAGE : Invalid record type in log file S0000002.LOG

2007-04-04-09.57.33.521085+480 I31200684G160    LEVEL: Severe
PID:7855 TID:8192 NODE:000 Title: SQLP_LRH
Dump File:/home/db2inst1/sqllib/db2dump/78558192.000

2007-04-04-09.57.33.569359+480 I31200845G388    LEVEL: Severe
PID    : 7855                TID  : 8192       PROC : db2shred (REMCLOB)
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpshrBuildRecord, probe:1040
MESSAGE : rc -2028994521, pageByteCount 4080, pageLsn 000036B90FFB, lookForLsn
      0000000036B88EEF, Bp 0x0x50a2c000

2007-04-04-09.57.33.569484+480 I31201234G161    LEVEL: Severe
PID:7855 TID:8192 NODE:000 Title: SQLP_LFPB
Dump File:/home/db2inst1/sqllib/db2dump/78558192.000

2007-04-04-09.57.33.885836+480 I31201396G441    LEVEL: Error
PID    : 7854                TID  : 8192       PROC : db2redom (REMCLOB)
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1280
RETCODE : ZRC=0x87100027=-2028994521=SQLP_TRECTYPERR
      "A record other than those expected has been read during abort"
      DIA8536C A bad record type was encountered.

2007-04-04-09.57.34.170772+480 I31201838G497    LEVEL: Error
PID    : 7843                TID  : 8192       PROC : db2agent (REMCLOB)
INSTANCE: db2inst1          NODE : 000       DB : REMCLOB
APPHDL  : 0-7                APPID: *LOCAL.db2inst1.070404015729
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 140 bytes
Crash recovery failed with rc -2028994521
LowtranLSN 0000000036B69173 MinbuffLSN 0000000036B005A4
Recovery started on log file S0000002.LOG.