informix逻辑日志损坏启动失败,如何截取至正常日志拉起数据库。

16:17:57 IBM Informix Dynamic Server Version 11.50.FC9W3 Software Serial Number AAA#B00000016:18:01 Bad Primary Chunk '/opt/informix/npmchks/npmchk1'.16:18:01 Bad Primary Chunk '/opt/informix/npmchks/npmchk2'.。。。。。。。。。。。。。。。。。。。...显示全部

16:17:57 IBM Informix Dynamic Server Version 11.50.FC9W3 Software Serial Number AAA#B000000
16:18:01 Bad Primary Chunk '/opt/informix/npmchks/npmchk1'.
16:18:01 Bad Primary Chunk '/opt/informix/npmchks/npmchk2'.
。。。。。。。。。。。
。。。。。。。。。。。
16:18:17 Bad Primary Chunk '/opt/informix/npmchks/npmchk46'.
16:18:34 Bad Primary Chunk '/opt/informix/npmchks/npmdbsc'.
16:18:34 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

16:18:34 Started 1 B-tree scanners.
16:18:34 B-tree scanner threshold set at 5000.
16:18:34 B-tree scanner range scan size set to -1.
16:18:34 B-tree scanner ALICE mode set to 6.
16:18:34 B-tree scanner index compression level set to med.
16:18:34 Physical Recovery Started at Page (1022:23618316).
16:19:07 Physical Recovery Complete: 580065 Pages Examined, 374368 Pages Restored.
16:19:07 Assert Warning: pthdrpage:ptalloc:bad bfget
16:19:07 IBM Informix Dynamic Server Version 11.50.FC9W3
16:19:07 Who: Session(1, informix@zjm9k6, 0, a27c39028)

    Thread(7, main_loop(), a27bf6028, 13)
    File: rspartn.c Line: 7309

16:19:07 Results: Cannot use TBLSpace page for TBLSpace 4194305
16:19:07 Action: Run 'oncheck -pt 4194305'
16:19:07 stack trace for pid 11011 written to /opt/informix/tmp/af.3efcffa
16:19:07 See Also: /opt/informix/tmp/af.3efcffa
16:19:07 pthdrpage:ptalloc:bad bfget
16:19:07 Assert Failed: Chunk 11 is being taken OFFLINE.
16:19:07 IBM Informix Dynamic Server Version 11.50.FC9W3
16:19:07 Who: Session(1, informix@zjm9k6, 0, a27c39028)

    Thread(7, main_loop(), a27bf6028, 13)
    File: rspartn.c Line: 7333

16:19:07 Results: Cannot Open DBspace 4.
16:19:07 Action: Restore space containing this chunk from the archive.
16:19:07 stack trace for pid 11011 written to /opt/informix/tmp/af.3efcffa
16:19:07 See Also: /opt/informix/tmp/af.3efcffa
16:19:14 Chunk 11 is being taken OFFLINE.
16:19:14 Assert Warning: Chunk 11 is being taken OFFLINE.
16:19:14 IBM Informix Dynamic Server Version 11.50.FC9W3
16:19:14 Who: Session(1, informix@zjm9k6, 0, a27c39028)

    Thread(7, main_loop(), a27bf6028, 13)
    File: rsmirror.c Line: 1932

16:19:14 Results: Dynamic Server will block at next checkpoint
16:19:14 Action: Shutdown (onmode -k) or override (onmode -O)
16:19:14 stack trace for pid 11011 written to /opt/informix/tmp/af.3efcffa
16:19:14 See Also: /opt/informix/tmp/af.3efcffa
16:19:14 Chunk 11 is being taken OFFLINE.
16:19:14 Cannot Open DBspace 4.
16:19:46 Assert Failed: Dbspace npmdbs, has not been physically restored
16:19:46 IBM Informix Dynamic Server Version 11.50.FC9W3
16:19:46 Who: Session(1, informix@zjm9k6, 0, a27c39028)

    Thread(7, main_loop(), a27bf6028, 14)
    File: hdr/hdrUtil.c Line: 3465

16:19:46 Action: Restore all dbspaces, before starting DR pair
16:19:46 stack trace for pid 11012 written to /opt/informix/tmp/af.3efcffa
16:19:46 See Also: /opt/informix/tmp/af.3efcffa
16:19:52 hdr/hdrUtil.c, line 3465, thread 7, proc id 11012, Dbspace npmdbs, has not been physically restored.
16:19:52 Fatal error in ADM VP at mt.c:14069
16:19:52 Unexpected virtual processor termination, pid = 11012, exit = 0x100

16:19:53 PANIC: Attempting to bring system down
16:25:00 IBM Informix Dynamic Server Started.
16:25:00 Requested shared memory segment size rounded from 38089728KB to 38109184KB
16:25:00 Shared memory segment will use large pages with intimate shared memory (ISM) if available
16:25:28 Segment locked: addr=10a000000, size=39023804416

Sat Jul 15 16:25:32 2017

16:25:32 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
16:25:32 Booting Language <c> from module <>
16:25:32 Loading Module <CNULL>
16:25:32 Booting Language <builtin> from module <>
16:25:32 Loading Module <BUILTINNULL>
16:25:40 DR: DRAUTO is 0 (Off)
16:25:40 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
16:25:40 Requested shared memory segment size rounded from 3224KB to 4096KB
16:25:40 Requested shared memory segment size rounded from 3224KB to 4096KB
16:25:40 Dynamically allocated new message shared memory segment (size 4096KB)
16:25:40 Memory sizes:resident:38109184 KB, virtual:8200192 KB, no SHMTOTAL limit
16:25:40 Requested shared memory segment size rounded from 3224KB to 4096KB
16:25:40 Dynamically allocated new message shared memory segment (size 4096KB)
16:25:40 Memory sizes:resident:38109184 KB, virtual:8204288 KB, no SHMTOTAL limit
16:25:40 Fast poll /dev/poll enabled.
16:25:40 IBM Informix Dynamic Server Version 11.50.FC9W3 Software Serial Number AAA#B000000
16:25:59 (18) connection rejected - no calls allowed for sqlexec
16:25:59 (19) connection rejected - no calls allowed for sqlexec
16:26:13 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.

16:26:13 Started 1 B-tree scanners.
16:26:13 B-tree scanner threshold set at 5000.
16:26:13 B-tree scanner range scan size set to -1.
16:26:13 B-tree scanner ALICE mode set to 6.
16:26:13 B-tree scanner index compression level set to med.
16:26:13 Physical Recovery Started at Page (1022:23618316).
16:26:48 Physical Recovery Complete: 580065 Pages Examined, 374368 Pages Restored.
16:27:02 DR: Trying to connect to primary server = nmosserver1
16:27:02 Onconfig parameter LOCKS modified from 15000000 to 30000000.
16:27:02 Onconfig parameter BUFFERPOOL modified from
size=2K,buffers=800000,lrus=64,lru_min_dirty=50.000000,lru_max_dirty=60.000000 to
size=2K,buffers=8000000,lrus=64,lru_min_dirty=50.000000,lru_max_dirty=60.000000.
16:27:02 Onconfig parameter BUFFERPOOL modified from
size=16K,buffers=800000,lrus=128,lru_min_dirty=10.000000,lru_max_dirty=20.000000 to
size=16K,buffers=1000000,lrus=128,lru_min_dirty=10.000000,lru_max_dirty=20.000000.
16:27:02 Onconfig parameter SHMVIRTSIZE modified from 4096000 to 8192000.
16:27:02 Dataskip is now OFF for all dbspaces
16:27:02 Restartable Restore has been ENABLED
16:27:02 Recovery Mode
16:32:37 Skipping failover callback.
16:32:37 Logical Recovery Started.
16:32:37 10 recovery worker threads will be started.
16:32:38 Checkpoint Completed: duration was 1 seconds.
16:32:38 Sat Jul 15 - loguniq 3051469, logpos 0x6494a06c, timestamp: 0x56a2faf7 Interval: 685718

16:32:38 Maximum server connections 0
16:32:38 Start Logical Recovery - Start Log 3051469, End Log ?
16:32:38 Starting Log Position - 3051469 0x6494a06c
16:32:39 rsrecvr.c 4706 set EOF
16:32:39 Started 1 B-tree scanners.
16:32:39 B-tree scanner threshold set at 5000.
16:32:39 B-tree scanner range scan size set to -1.
16:32:39 B-tree scanner ALICE mode set to 6.
16:32:39 B-tree scanner index compression level set to med.
16:32:39 DR: Reservation of the last logical log for log backup turned on
16:32:39 SCHAPI: "INFORMIXDIR/etc/sysadmin/stop" file is present.

      Bypassing dbScheduler and dbWorker threads startup.

16:32:39 DR: new type = standard
16:32:40 No logical log restore will be performed.
16:32:40 Clearing the physical and logical logs has started
16:47:28 Cleared 78911 MB of the physical and logical logs in 887 seconds
16:47:44 Physical Recovery Started at Page (1022:24200797).
16:47:44 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
16:47:45 Logical Recovery Started.
16:47:45 10 recovery worker threads will be started.
16:47:58 Logical Recovery has reached the transaction cleanup phase.
16:47:58 Assert Failed: Dynamic Server must abort
16:47:58 IBM Informix Dynamic Server Version 11.50.FC9W3
16:47:58 Who: Session(34, informix@zjm9k6, 0, a2a404ac8)

    Thread(199, fast_recovery, a2a3bdbf0, 9)
    File: rslog.c Line: 3660

16:47:58 Results: Dynamic Server must abort
16:47:58 Action: Reinitialize shared memory
16:47:58 stack trace for pid 14818 written to /opt/informix/tmp/af.4afd6be
16:47:58 See Also: /opt/informix/tmp/af.4afd6be
16:48:05 rslog.c, line 3660, thread 199, proc id 14818, Dynamic Server must abort.
16:48:05 Fatal error in ADM VP at mt.c:14069
16:48:05 Unexpected virtual processor termination, pid = 14818, exit = 0x100

如何截取日志至故障发生前,正常检查点,拉起数据库。

收起
参与6

查看其它 1 个回答大力水手的回答

大力水手大力水手  售前技术支持 , 北京南天软件股份有限公司

没有最新的备份吗?

系统集成 · 2017-07-18
浏览3555

回答者

大力水手
售前技术支持北京南天软件股份有限公司
擅长领域: 存储服务器数据库

大力水手 最近回答过的问题

回答状态

  • 发布时间:2017-07-18
  • 关注会员:3 人
  • 回答浏览:3555
  • X社区推广