informix7.3.1UD5备份问题
数据库版本7.3.1 UD5 ，操作系统HPUX11.11 双机MC,采用DP做数据备份。 逻辑日志满了后自动备份。刚开始的时候好好的，逻辑日志和0级备份都没问题，后来随着数据量越来越大，会出现有时候0级备份无法做的问题，但有时候就能成功。
下面是onbar（bar_act.log）相关日志。
0级备份能做成功的时候的日志: 2011-01-03 01:17:29 55265524 /usr/informix/bin/onbar_d -b -L 0
2011-01-03 01:17:30 55265524 Begin level 0 backup rootdbs.
2011-01-03 01:17:30 55265524 Successfully connected to Storage Manager.
2011-01-03 01:20:39 55265524 Completed level 0 backup rootdbs.
2011-01-03 01:20:42 92345526 Process 92345526 successfully forked.
2011-01-03 01:20:43 92335526 Process 92335526 successfully forked.
2011-01-03 01:20:43 92345526 Begin level 0 backup workdbs.
2011-01-03 01:20:43 92345526 Successfully connected to Storage Manager.
2011-01-03 01:20:44 92335526 Begin level 0 backup logdbs.
2011-01-03 01:20:44 92335526 Successfully connected to Storage Manager.
2011-01-03 01:20:44 92335526 Completed level 0 backup logdbs.
2011-01-03 01:20:46 92335526 Process 92335526 completed.
2011-01-03 02:26:11 92345526 Completed level 0 backup workdbs.
2011-01-03 02:26:15 92345526 Process 92345526 completed. 本帖最后由 fringker 于 2011-01-10 13:02 编辑
0级备份不能成功的时候的日志，有几种情况： 2011-01-03 20:25:01 85478545 /usr/informix/bin/onbar_d -b -L 0
2011-01-03 20:25:03 85478545 Begin level 0 backup rootdbs.
2011-01-03 20:25:03 85478545 Successfully connected to Storage Manager.
2011-01-03 20:27:49 85478545 Completed level 0 backup rootdbs.
2011-01-03 20:27:51 115718547 Process 115718547 successfully forked.
2011-01-03 20:27:52 115718547 Begin level 0 backup logdbs.
2011-01-03 20:27:52 115718547 Successfully connected to Storage Manager.
2011-01-03 20:27:52 115718547 Completed level 0 backup logdbs.
2011-01-03 20:27:53 115728547 Process 115728547 successfully forked.
2011-01-03 20:27:55 115728547 Begin level 0 backup workdbs.
2011-01-03 20:27:55 115728547 Successfully connected to Storage Manager.
2011-01-03 20:27:55 115718547 Process 115718547 completed.
2011-01-03 22:46:03 85478545 Process 8547 received signal 3. Process will exit after cleanup.
2011-01-03 22:46:03 115728547 Process 11572 received signal 3. Process will exit after cleanup.
2011-01-03 22:46:03 115728547 Process 11639 received signal 3. Process will exit after cleanup.
2011-01-03 22:46:05 85478545 Process 8547 received signal 15. Process will exit after cleanup.
2011-01-03 23:45:13 1290112899 /usr/informix/bin/onbar_d -l
2011-01-03 23:45:14 1290112899 Begin backup logical log 50491.
2011-01-03 23:45:14 1290112899 Successfully connected to Storage Manager.
2011-01-03 23:59:55 2797727975 /usr/informix/bin/onbar_d -l
2011-01-03 23:59:55 2797727975 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:00:00 2797727975 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:10:16 84288426 /usr/informix/bin/onbar_d -l
2011-01-04 00:10:16 84288426 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:10:21 84288426 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:16:29 1416814166 /usr/informix/bin/onbar_d -l
2011-01-04 00:16:29 1416814166 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:16:34 1416814166 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:19:41 1670116695 /usr/informix/bin/onbar_d -l
2011-01-04 00:19:41 1670116695 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:19:46 1670116695 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:23:59 2163121629 /usr/informix/bin/onbar_d -l
2011-01-04 00:23:59 2163121629 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:24:04 2163121629 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:24:34 2219522193 /usr/informix/bin/onbar_d -l
2011-01-04 00:24:34 2219522193 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:24:39 2219522193 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:24:59 2268222680 /usr/informix/bin/onbar_d -l
2011-01-04 00:25:00 2268222680 WARNING: A log backup is already running. Can't start another.
2011-01-04 00:25:05 2268222680 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 00:45:41 1290112899 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 00:45:46 1290112899 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 00:51:10 2157221570 /usr/informix/bin/onbar_d -l
2011-01-04 00:51:10 2157221570 Begin backup logical log 50491.
2011-01-04 00:51:10 2157221570 Successfully connected to Storage Manager.
2011-01-04 01:51:37 2157221570 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 01:51:42 2157221570 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 04:18:49 1396213960 /usr/informix/bin/onbar_d -b -L 0
2011-01-04 04:18:51 1396213960 Begin level 0 backup rootdbs.
2011-01-04 04:18:51 1396213960 Successfully connected to Storage Manager.
2011-01-04 04:22:38 1827918277 /usr/informix/bin/onbar_d -l
2011-01-04 04:22:38 1827918277 Begin backup logical log 50491.
2011-01-04 04:22:38 1827918277 Successfully connected to Storage Manager.
2011-01-04 04:22:51 1396213960 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 04:22:52 1396213960 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 05:23:05 1827918277 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 05:23:11 1827918277 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 08:45:45 1158211579 /usr/informix/bin/onbar_d -l
2011-01-04 08:45:46 1158211579 Begin backup logical log 50491.
2011-01-04 08:45:46 1158211579 Successfully connected to Storage Manager.
2011-01-04 08:59:28 2682726825 /usr/informix/bin/onbar_d -l
2011-01-04 08:59:29 2682726825 WARNING: A log backup is already running. Can't start another.
2011-01-04 08:59:34 2682726825 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 09:40:14 1319713195 /usr/informix/bin/onbar_d -l
2011-01-04 09:40:14 1319713195 WARNING: A log backup is already running. Can't start another.
2011-01-04 09:40:19 1319713195 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 09:46:14 1158211579 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 09:46:19 1158211579 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 10:02:09 82138211 /usr/informix/bin/onbar_d -l
2011-01-04 10:02:09 82138211 Begin backup logical log 50491.
2011-01-04 10:02:09 82138211 Successfully connected to Storage Manager.
2011-01-04 10:48:35 124122 /usr/informix/bin/onbar_d -l
2011-01-04 10:48:35 124122 WARNING: A log backup is already running. Can't start another.
2011-01-04 10:48:40 124122 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 11:02:36 82138211 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 11:02:41 82138211 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 11:11:18 2507125069 /usr/informix/bin/onbar_d -l
2011-01-04 11:11:19 2507125069 Begin backup logical log 50491.
2011-01-04 11:11:19 2507125069 Successfully connected to Storage Manager.
2011-01-04 11:43:50 2927229270 /usr/informix/bin/onbar_d -l
2011-01-04 11:43:50 2927229270 WARNING: A log backup is already running. Can't start another.
2011-01-04 11:43:55 2927229270 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 12:11:46 2507125069 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 12:11:51 2507125069 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 12:19:28 43694367 /usr/informix/bin/onbar_d -l
2011-01-04 12:19:28 43694367 Begin backup logical log 50491.
2011-01-04 12:19:28 43694367 Successfully connected to Storage Manager.
2011-01-04 12:31:49 1712817126 /usr/informix/bin/onbar_d -l
2011-01-04 12:31:49 1712817126 WARNING: A log backup is already running. Can't start another.
2011-01-04 12:31:54 1712817126 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 12:43:41 2981329811 /usr/informix/bin/onbar_d -l
2011-01-04 12:43:42 2981329811 WARNING: A log backup is already running. Can't start another.
2011-01-04 12:43:47 2981329811 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 13:06:29 2500825003 /usr/informix/bin/onbar_d -l
2011-01-04 13:06:29 2500825003 WARNING: A log backup is already running. Can't start another.
2011-01-04 13:06:34 2500825003 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 13:19:55 43694367 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 13:20:00 43694367 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 14:25:43 1915219150 /usr/informix/bin/onbar_d -l
2011-01-04 14:25:44 1915219150 Begin backup logical log 50491.
2011-01-04 14:25:44 1915219150 Successfully connected to Storage Manager.
2011-01-04 15:02:53 2632026318 /usr/informix/bin/onbar_d -l
2011-01-04 15:02:53 2632026318 WARNING: A log backup is already running. Can't start another.
2011-01-04 15:02:58 2632026318 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 15:26:11 1915219150 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 15:26:16 1915219150 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 15:29:26 2330523303 /usr/informix/bin/onbar_d -l
2011-01-04 15:29:26 2330523303 Begin backup logical log 50491.
2011-01-04 15:29:26 2330523303 Successfully connected to Storage Manager.
2011-01-04 15:55:35 2170121699 /usr/informix/bin/onbar_d -l
2011-01-04 15:55:35 2170121699 WARNING: A log backup is already running. Can't start another.
2011-01-04 15:55:40 2170121699 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 16:15:11 1458314581 /usr/informix/bin/onbar_d -l
2011-01-04 16:15:11 1458314581 WARNING: A log backup is already running. Can't start another.
2011-01-04 16:15:16 1458314581 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 16:29:53 2330523303 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 16:29:58 2330523303 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 16:39:08 1588915887 /usr/informix/bin/onbar_d -l
2011-01-04 16:39:10 1588915887 Begin backup logical log 50491.
2011-01-04 16:39:10 1588915887 Successfully connected to Storage Manager.
2011-01-04 17:00:20 1255612554 /usr/informix/bin/onbar_d -l
2011-01-04 17:00:20 1255612554 WARNING: A log backup is already running. Can't start another.
2011-01-04 17:00:25 1255612554 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 17:39:37 1588915887 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 17:39:45 1588915887 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 17:46:55 94289426 /usr/informix/bin/onbar_d -l
2011-01-04 17:46:55 94289426 Begin backup logical log 50491.
2011-01-04 17:46:55 94289426 Successfully connected to Storage Manager.
2011-01-04 18:47:22 94289426 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 18:47:27 94289426 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 19:18:38 1438314381 /usr/informix/bin/onbar_d -l
2011-01-04 19:18:38 1438314381 Begin backup logical log 50491.
2011-01-04 19:18:38 1438314381 Successfully connected to Storage Manager.
2011-01-04 20:19:05 1438314381 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 20:19:10 1438314381 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 20:46:41 1911619114 /usr/informix/bin/onbar_d -b -L 0
2011-01-04 20:46:42 1911619114 Begin level 0 backup rootdbs.
2011-01-04 20:46:42 1911619114 Successfully connected to Storage Manager.
2011-01-04 20:50:42 1911619114 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 20:50:43 1911619114 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 22:03:56 1140011397 /usr/informix/bin/onbar_d -l
2011-01-04 22:03:56 1140011397 Begin backup logical log 50491.
2011-01-04 22:03:56 1140011397 Successfully connected to Storage Manager.
2011-01-04 23:04:23 1140011397 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-04 23:04:28 1140011397 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-04 23:11:33 2146321461 /usr/informix/bin/onbar_d -l
2011-01-04 23:11:34 2146321461 Begin backup logical log 50491.
2011-01-04 23:11:34 2146321461 Successfully connected to Storage Manager.
2011-01-04 23:12:40 2278322781 /usr/informix/bin/onbar_d -l
2011-01-04 23:12:40 2278322781 WARNING: A log backup is already running. Can't start another.
2011-01-04 23:12:45 2278322781 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 23:13:58 2437724375 /usr/informix/bin/onbar_d -l
2011-01-04 23:13:58 2437724375 WARNING: A log backup is already running. Can't start another.
2011-01-04 23:14:03 2437724375 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 23:14:14 2470224700 /usr/informix/bin/onbar_d -l
2011-01-04 23:14:14 2470224700 WARNING: A log backup is already running. Can't start another.
2011-01-04 23:14:19 2470224700 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 23:21:30 26312625 /usr/informix/bin/onbar_d -l
2011-01-04 23:21:30 26312625 WARNING: A log backup is already running. Can't start another.
2011-01-04 23:21:35 26312625 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 23:21:57 31483146 /usr/informix/bin/onbar_d -l
2011-01-04 23:21:57 31483146 WARNING: A log backup is already running. Can't start another.
2011-01-04 23:22:02 31483146 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-04 23:39:37 2255322551 /usr/informix/bin/onbar_d -l
2011-01-04 23:39:37 2255322551 WARNING: A log backup is already running. Can't start another.
2011-01-04 23:39:42 2255322551 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-05 00:12:01 2146321461 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 00:12:07 2146321461 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 02:07:51 60866084 /usr/informix/bin/onbar_d -b -L 0
2011-01-05 02:07:52 60866084 Begin level 0 backup rootdbs.
2011-01-05 02:07:52 60866084 Successfully connected to Storage Manager.
2011-01-05 02:11:52 60866084 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 02:11:53 60866084 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 02:17:55 1717117169 /usr/informix/bin/onbar_d -l
2011-01-05 02:17:55 1717117169 Begin backup logical log 50491.
2011-01-05 02:17:55 1717117169 Successfully connected to Storage Manager.
2011-01-05 02:19:37 1879818796 /usr/informix/bin/onbar_d -l
2011-01-05 02:19:37 1879818796 WARNING: A log backup is already running. Can't start another.
2011-01-05 02:19:42 1879818796 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-05 04:01:26 1717117169 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 04:01:31 1717117169 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 08:48:09 2858628584 /usr/informix/bin/onbar_d -l
2011-01-05 08:48:10 2858628584 Begin backup logical log 50491.
2011-01-05 08:48:11 2858628584 Successfully connected to Storage Manager.
2011-01-05 09:26:57 98109808 /usr/informix/bin/onbar_d -l
2011-01-05 09:26:58 98109808 WARNING: A log backup is already running. Can't start another.
2011-01-05 09:27:03 98109808 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-05 09:48:38 2858628584 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 09:48:43 2858628584 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 10:22:03 85518549 /usr/informix/bin/onbar_d -l
2011-01-05 10:22:03 85518549 Begin backup logical log 50491.
2011-01-05 10:22:03 85518549 Successfully connected to Storage Manager.
2011-01-05 10:59:27 115728547 Process 115728547 completed.
2011-01-05 10:59:27 85478545 The ON-Bar process 11572 exited with a problem (exit code 141 (0x8d), signal 0).
2011-01-05 10:59:27 85478545 /usr/informix/bin/onbar_d: process exit 141 (0x8d)
2011-01-05 10:59:47 85518549 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 10:59:52 85518549 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 11:01:31 2017420172 /usr/informix/bin/onbar_d -l
2011-01-05 11:01:31 2017420172 Begin backup logical log 50491.
2011-01-05 11:01:31 2017420172 Successfully connected to Storage Manager.
2011-01-05 11:04:26 2017420172 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 11:04:31 2017420172 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 11:05:53 2489124889 /usr/informix/bin/onbar_d -l
2011-01-05 11:05:53 2489124889 Begin backup logical log 50491.
2011-01-05 11:05:53 2489124889 Successfully connected to Storage Manager.
2011-01-05 11:09:11 2489124889 Completed backup logical log 50491.
……这之间的逻辑日志备份都成功
下续
2011-01-05 20:31:01 15071505 /usr/informix/bin/onbar_d -b -L 0
2011-01-05 20:31:05 15071505 Begin level 0 backup rootdbs.
2011-01-05 20:31:05 15071505 Successfully connected to Storage Manager.
2011-01-05 21:46:01 1987919877 /usr/informix/bin/onbar_d -l
2011-01-05 21:46:03 1987919877 Begin backup logical log 50548.
2011-01-05 21:46:03 1987919877 Successfully connected to Storage Manager.
2011-01-05 21:46:33 2045720455 /usr/informix/bin/onbar_d -l
2011-01-05 21:46:33 2045720455 WARNING: A log backup is already running. Can't start another.
2011-01-05 21:46:38 2045720455 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-05 21:47:21 2113321131 /usr/informix/bin/onbar_d -l
2011-01-05 21:47:21 2113321131 WARNING: A log backup is already running. Can't start another.
2011-01-05 21:47:27 2113321131 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-05 22:36:34 15071505 Process 1507 received signal 3. Process will exit after cleanup.
2011-01-05 22:36:37 15071505 Process 1507 received signal 15. Process will exit after cleanup.
2011-01-05 22:46:31 1987919877 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-05 22:46:36 1987919877 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-05 23:51:54 980976 /usr/informix/bin/onbar_d -l
2011-01-05 23:51:54 980976 Begin backup logical log 50548.
2011-01-05 23:51:54 980976 Successfully connected to Storage Manager.
2011-01-06 00:05:31 1427214270 /usr/informix/bin/onbar_d -l
2011-01-06 00:05:31 1427214270 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:05:36 1427214270 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:06:54 1610716105 /usr/informix/bin/onbar_d -l
2011-01-06 00:06:55 1610716105 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:07:00 1610716105 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:08:11 1764517639 /usr/informix/bin/onbar_d -l
2011-01-06 00:08:11 1764517639 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:08:16 1764517639 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:08:38 1824518243 /usr/informix/bin/onbar_d -l
2011-01-06 00:08:38 1824518243 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:08:43 1824518243 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:11:34 2132821326 /usr/informix/bin/onbar_d -l
2011-01-06 00:11:34 2132821326 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:11:39 2132821326 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:12:08 2196321961 /usr/informix/bin/onbar_d -l
2011-01-06 00:12:08 2196321961 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:12:13 2196321961 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:12:34 2242822425 /usr/informix/bin/onbar_d -l
2011-01-06 00:12:35 2242822425 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:12:40 2242822425 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:13:08 2298822986 /usr/informix/bin/onbar_d -l
2011-01-06 00:13:08 2298822986 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:13:13 2298822986 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:14:10 2373523733 /usr/informix/bin/onbar_d -l
2011-01-06 00:14:10 2373523733 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:14:15 2373523733 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:36:29 1781817811 /usr/informix/bin/onbar_d -l
2011-01-06 00:36:29 1781817811 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:36:34 1781817811 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:50:44 33013299 /usr/informix/bin/onbar_d -l
2011-01-06 00:50:47 33013299 WARNING: A log backup is already running. Can't start another.
2011-01-06 00:50:52 33013299 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 00:52:21 980976 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-06 00:52:27 980976 /usr/informix/bin/onbar_d: process exit 3 (0x03)
……之间的逻辑日志备份都是这样的提示，到下次0级备份的时候，又有了新情况。下续
2011-01-06 02:34:45 2519825196 /usr/informix/bin/onbar_d -b -L 0
2011-01-06 02:34:47 2519825196 ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.
2011-01-06 02:34:47 2519825196 SQL -408 Invalid message type received from the sqlexec process.
2011-01-06 02:34:47 2519825196 /usr/informix/bin/onbar_d: process exit 131 (0x83)
2011-01-06 03:26:49 1645616454 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-06 03:26:56 1645616454 /usr/informix/bin/onbar_d: process exit 3 (0x03)
2011-01-06 08:57:07 2395723955 /usr/informix/bin/onbar_d -l
2011-01-06 08:57:07 2395723955 Begin backup logical log 50548.
2011-01-06 08:57:07 2395723955 Successfully connected to Storage Manager.
2011-01-06 09:16:13 1200212000 /usr/informix/bin/onbar_d -l
2011-01-06 09:16:13 1200212000 WARNING: A log backup is already running. Can't start another.
2011-01-06 09:16:18 1200212000 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 09:48:49 1347113469 /usr/informix/bin/onbar_d -l
2011-01-06 09:48:50 1347113469 WARNING: A log backup is already running. Can't start another.
2011-01-06 09:48:55 1347113469 /usr/informix/bin/onbar_d: process exit 152 (0x98)
2011-01-06 09:57:34 2395723955 XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.
2011-01-06 09:57:39 2395723955 /usr/informix/bin/onbar_d: process exit 3 (0x03)
可以看到，在做workdbs的0级备份的时候，有个提示：8545 Process 8547 received signal 3. Process will exit after cleanup.然后后面的逻辑日志备份和0级备份都无法成功，一直到1月5日11:05:53，再次做逻辑日志的备份的时候才成功。晚上20:31分作0级备份又不成功，无尽的WARNING: A log backup is already running. Can't start another.提示。最后到XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session然后退出进程。后来的新情况就是ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.和SQL -408 Invalid message type received from the sqlexec process.这样的提示，不知道这是什么原因造成的，可以保证的是，中间没什么误操作，都是通过脚本完成的，脚本是以前早就写好的，刚开始数据量不大的时候是没问题的，而且以前数据库是可以手工dbexport出来的，现在根本没办法做出来，遇到那几个大表的时候就死在那，不动了。请各位大牛们帮小弟分析下，多谢~~ 逻辑日志备份建议使用ALARMPROGRAM指定脚本做～
WARNING: A log backup is already running. Can't start another.
在做逻辑日志备份时，若有别的程序已经启动了逻辑日志备份，再启一个备份程序时就会报这个错误。。这个怀疑是跟你的脚本相关。 onbar备份逻辑日志只有一个onbar进程，如果上一个逻辑日志没有备份完成下一个逻辑日志满了启动onbar备份就会提示
WARNING: A log backup is already running. Can't start another. 感谢两位的回复，也就是说，当前正在备份一个逻辑日志的时候，另外一个逻辑日志满了，会启动自动备份，但是由于只能启动一个进程，所以会提示：WARNING: A log backup is already running. Can't start another.那么，当前正在做的这个逻辑日志备份完毕后，会按照顺序继续下一个已满的逻辑日志的备份吧？
另外，打个比方，如果id为30的逻辑日志备份在备份的时候，由于数据量大或者操作量大，31之后的逻辑日志迅速写满，需要备份，那么会报那个错，但是如果30之后的迅速写满需要备份的逻辑日志太多了，会不会导致意外结果？会导致这个
XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.报错出现吗？
再有，如果正在备份当前一个逻辑日志的时候，此时启动了0级备份，会不会由于0级备份会先备份所有的逻辑日志，而由于当前正存在一个正在备份的逻辑日志进程，就会导致0级备份由于等待逻辑日志备份而时间很长，最后报XBSA Error (BSACreateObject): A system error occurred. Aborting XBSA session.不成功？
下面的这个报错又是怎么回事呢？
ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.和SQL -408 Invalid message type received from the sqlexec process. 使用ALARMPROGRAM指定脚本来做也可以，但在DP里应该怎么设置呢？ 感谢两位的回复，也就是说，当前正在备份一个逻辑日志的时候，另外一个逻辑日志满了，会启动自动备份，但是 ...
fringker 发表于 2011-01-11 10:25 http://bbs3.chinaunix.net/images/common/back.gif
DP这个不知道～～
只是提醒下，使用ALARMPROGRAM，在逻辑日志满的会自动备份。
即便是报了已经启动了另外一个逻辑日志备份程序的话，这权当是个警示，在下次逻辑日志备份的时候总会备份的。 现在也是没办法啊，用DP备份恢复还是比较方便的，最起码什么都不用去记，用了另外的备份方法到时候还要记得什么时候备份的，备份文件在哪儿等等，所以如果有其他方法还是想纳入DP的。
liaosnet大神，这两个报错有研究嘛？
ERROR: Unable to start the DB/BLOBspace backup: buc_fe.c : Archive API processing failed at line 246 for *logid.和SQL -408 Invalid message type received from the sqlexec process.
页:
[1]
2