- 论坛徽章:
- 0
|
对不起啊，我现在把online.log贴上：
17:40:10 Checkpoint loguniq 17748, logpos 0x9d9300, timestamp: 0x458d16dc
17:40:10 Maximum server connections 48
17:41:25 DR: Sending log 17748, size 5120 pages, 50.61 percent used
17:41:25 Logical Log 17748 Complete, timestamp: 0x458d1f99.
17:41:27 Logical Log 17748 - Backup Started
17:41:27 Logical Log 17748 - Backup Completed
17:43:40 Checkpoint Completed: duration was 0 seconds.
17:43:40 Checkpoint loguniq 17749, logpos 0xc48d0, timestamp: 0x458d4d44
17:43:40 Maximum server connections 48
17:47:11 Checkpoint Completed: duration was 0 seconds.
17:47:11 Checkpoint loguniq 17749, logpos 0x1ec018, timestamp: 0x458d9ff8
17:47:11 Maximum server connections 48
17:50:41 Checkpoint Completed: duration was 0 seconds.
17:50:41 Checkpoint loguniq 17749, logpos 0x318dd0, timestamp: 0x458dfcbb
17:50:41 Maximum server connections 48
17:54:11 Checkpoint Completed: duration was 0 seconds.
17:54:11 Checkpoint loguniq 17749, logpos 0x45ef6c, timestamp: 0x458e57b6
17:54:11 Maximum server connections 48
17:57:41 Checkpoint Completed: duration was 0 seconds.
17:57:41 Checkpoint loguniq 17749, logpos 0x546018, timestamp: 0x458e8b70
17:57:41 Maximum server connections 48
17:58:53 DR: Sending log 17749 (current), size 5120 pages, 28.50 percent used
此时已堵塞,下面是重启数据库
18:09:30 WARNING: Checkpoint appears stalled and may not complete
before the database server shuts down.
18:09:31 IBM Informix Dynamic Server Stopped.
18:09:45 IBM Informix Dynamic Server Started.
18:09:45 WARNING: If you intend to use J/Foundation or GLS for Unicode feature(GLU) with this Server instance, please make sure that your SHMBASE value specifies in onconfig is 0x700000010000000 or above. Otherwise you will have problems while attaching or dynamimically adding virtual shared memory segments. Please refer to Server machine notes for more information.
Tue Mar 2 18:09:47 2010
18:09:47 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure permissions
18:09:47 Event alarms enabled. ALARMPROG = '/usr/informix/etc/alarmprogram.sh'
18:09:47 Dynamically allocated new virtual shared memory segment (size 512000KB)
18:09:47 Memory sizes:resident:9288208 KB, virtual:528000 KB, no SHMTOTAL limit
18:09:47 Booting Language <c> from module <>
18:09:47 Loading Module <CNULL>
18:09:47 Booting Language <builtin> from module <>
18:09:47 Loading Module <BUILTINNULL>
18:09:52 DR: DRAUTO is 0 (Off)
18:09:52 AIX MP latch code enabled
18:09:52 IBM Informix Dynamic Server Version 10.00.FC8 Software Serial Number AAA#B000000
18:09:53 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
18:09:53 DR: Reservation of the last logical log for log backup turned on
18:09:53 DR: Trying to connect to secondary server = db_s
18:09:57 (7) connection rejected - no calls allowed for sqlexec
18:09:57 (13) connection rejected - no calls allowed for sqlexec
18:10:57 DR: Cannot connect to secondary server
18:10:57 DR: Turned off on primary server
18:10:57 DR: Cannot connect to secondary server
18:10:58 Physical Recovery Started at Page (3:222476).
18:10:59 Physical Recovery Complete: 317 Pages Examined, 317 Pages Restored.
18:10:59 Logical Recovery Started.
18:10:59 10 recovery worker threads will be started.
18:11:04 Logical Recovery has reached the transaction cleanup phase.
18:11:04 Logical Recovery Complete.
141 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
18:11:05 Onconfig parameter TAPEDEV modified from pzh520:/backup/data/bakdat to /dev/rmt0.
18:11:05 Dataskip is now OFF for all dbspaces
18:11:05 Checkpoint Completed: duration was 0 seconds.
18:11:05 Checkpoint loguniq 17749, logpos 0x5b4018, timestamp: 0x877a488e
18:11:05 Maximum server connections 0
18:11:05 On-Line Mode
18:11:05 Affinitied VP 1 to phys proc 2
18:11:05 Affinitied VP 5 to phys proc 5
18:11:05 Affinitied VP 4 to phys proc 4
18:11:05 Affinitied VP 8 to phys proc 8
18:11:05 Affinitied VP 6 to phys proc 6
18:11:05 Affinitied VP 3 to phys proc 3
18:11:05 Affinitied VP 7 to phys proc 7
18:11:34 Checkpoint Completed: duration was 0 seconds.
18:11:34 Checkpoint loguniq 17749, logpos 0x5dc018, timestamp: 0x877a5881
18:11:34 Maximum server connections 5
18:11:35 DR: Primary server connected
18:11:35 DR: Secondary server needs failure recovery
18:11:38 DR: Sending log 17749, size 5120 pages, 29.47 percent used
18:11:38 Logical Log 17749 Complete, timestamp: 0x877a5a1f.
18:14:22 DR: Sending log 17750 (current), size 5120 pages, 6.93 percent used
18:14:26 DR: Sending Logical Logs Completed
18:14:27 DR: Primary server operational
18:14:27 Checkpoint Completed: duration was 0 seconds.
18:14:27 Checkpoint loguniq 17750, logpos 0x166018, timestamp: 0x877af03c
18:14:27 Maximum server connections 6
18:18:04 Checkpoint Completed: duration was 0 seconds.
18:18:04 Checkpoint loguniq 17750, logpos 0x2ce018, timestamp: 0x877b42a1
18:18:04 Maximum server connections 6
18:19:53 Logical Log 17749 - Backup Started
18:19:53 Logical Log 17749 - Backup Completed
18:21:35 Checkpoint Completed: duration was 0 seconds.
18:21:35 Checkpoint loguniq 17750, logpos 0x3db018, timestamp: 0x877b8cbd
18:21:35 Maximum server connections 6 |
|
免费注册
发表于 2010-03-03 09:19
