懂informix onbar备份的朋友帮忙看下bar_act.log
我初次部署informix备份，不熟悉informix，没有恢复测试环境，不确定备份是否可以恢复，请从onbar日志确认备份过程是否正常。能否用于恢复？谢谢了2012-05-08 10:54:16 336598550292 /opt/informix/bin/onbar_d -b -w -L 0
2012-05-08 10:54:16 336598550292 (-43336) Logical Logs cannot be backed-up because the database server is
dismissing the logical logs.
2012-05-08 10:54:16 336598550292 Implicit logical log backup has been disabled.
2012-05-08 10:54:16 336598550292 Working with veritas-netbackup as generic storage manager.
2012-05-08 10:54:16 336598550292 (-43060) The buffer BAR_XFER_BUF_SIZEexceeded maximum allowed limit. Changing size to 61440.
2012-05-08 10:54:35 336598550292 Archive started on rootdbs, apmdbs11, apmdbs13, apmdbs1, apmdbs2, apmdbs10, apmdbs9, apmdbs3, apmdbs4, apmdbs6, apmdbs5, apmdbs7, apmdbs8, apmdbs12, nrmdbs, npmdbs, dpmdbs1, dpmdbs8, dpmdbs2, dpmdbs6, dpmdbs7, dpmdbs3, dpmdbs4, cmdbs04, cmdbs03, dpmdbs5, cmdbs01, cmdbs02, cmdbs12, cmdbs11, cmdbs08, cmdbs10, cmdbs09, cmdbs07, cmdbs06, cmdbs05, llogdbs, plogdbs (Requested Level 0).
2012-05-08 10:54:46 336598550292 Begin level 0 backup rootdbs.
2012-05-08 10:54:46 336598550292 Successfully connected to Storage Manager.
2012-05-08 10:55:13 336598550292 Completed level 0 backup rootdbs (Storage Manager copy ID: 1 1336445842).
2012-05-08 10:55:14 349020336598 Process 349020336598 successfully forked.
2012-05-08 10:55:14 407088336598 Process 407088336598 successfully forked.
2012-05-08 10:55:14 374276336598 Process 374276336598 successfully forked.
2012-05-08 10:55:14 332830336598 Process 332830336598 successfully forked.
2012-05-08 10:55:14 422536336598 Process 422536336598 successfully forked.
2012-05-08 10:55:14 475926336598 Process 475926336598 successfully forked.
2012-05-08 10:55:14 366120336598 Process 366120336598 successfully forked.
2012-05-08 10:55:14 583050336598 Process 583050336598 successfully forked.
2012-05-08 10:55:14 431874336598 Process 431874336598 successfully forked.
2012-05-08 10:55:14 566616336598 Process 566616336598 successfully forked.
2012-05-08 10:55:14 296016336598 Process 296016336598 successfully forked.
2012-05-08 10:55:14 427296336598 Process 427296336598 successfully forked.
2012-05-08 10:55:14 353078336598 Process 353078336598 successfully forked.
2012-05-08 10:55:14 467740336598 Process 467740336598 successfully forked.
2012-05-08 10:55:14 353436336598 Process 353436336598 successfully forked.
2012-05-08 10:55:14 345096336598 Process 345096336598 successfully forked.
2012-05-08 10:55:14 340798336598 Process 340798336598 successfully forked.
2012-05-08 10:55:14 374276336598 Begin level 0 backup apmdbs1.
2012-05-08 10:55:14 349020336598 Begin level 0 backup apmdbs13.
2012-05-08 10:55:14 407088336598 Begin level 0 backup apmdbs11.
2012-05-08 10:55:14 452180336598 Process 452180336598 successfully forked.
2012-05-08 10:55:14 336688336598 Process 336688336598 successfully forked.
2012-05-08 10:55:14 374276336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 349020336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 463660336598 Process 463660336598 successfully forked.
2012-05-08 10:55:14 407088336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 337046336598 Process 337046336598 successfully forked.
2012-05-08 10:55:14 831664336598 Process 831664336598 successfully forked.
2012-05-08 10:55:14 332830336598 Begin level 0 backup apmdbs2.
2012-05-08 10:55:14 489060336598 Process 489060336598 successfully forked.
2012-05-08 10:55:14 259668336598 Process 259668336598 successfully forked.
2012-05-08 10:55:14 366120336598 Begin level 0 backup apmdbs4.
2012-05-08 10:55:14 480638336598 Process 480638336598 successfully forked.
2012-05-08 10:55:14 340520336598 Process 340520336598 successfully forked.
2012-05-08 10:55:14 583050336598 Begin level 0 backup apmdbs5.
2012-05-08 10:55:14 336688336598 Begin level 0 backup cmdbs01.
2012-05-08 10:55:14 475926336598 Begin level 0 backup apmdbs3.
2012-05-08 10:55:14 332830336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 366120336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 431874336598 Begin level 0 backup apmdbs8.
2012-05-08 10:55:14 389532336598 Process 389532336598 successfully forked.
2012-05-08 10:55:14 324526336598 Process 324526336598 successfully forked.
2012-05-08 10:55:14 390726336598 Process 390726336598 successfully forked.
2012-05-08 10:55:14 365026336598 Process 365026336598 successfully forked.
2012-05-08 10:55:14 484294336598 Process 484294336598 successfully forked.
2012-05-08 10:55:14 583050336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 427296336598 Begin level 0 backup npmdbs.
2012-05-08 10:55:14 296016336598 Begin level 0 backup apmdbs7.
2012-05-08 10:55:14 309224336598 Process 309224336598 successfully forked.
2012-05-08 10:55:14 336688336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 721132336598 Process 721132336598 successfully forked.
2012-05-08 10:55:14 422536336598 Begin level 0 backup apmdbs10.
2012-05-08 10:55:14 475926336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 279750336598 Process 279750336598 successfully forked.
2012-05-08 10:55:14 431874336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 831664336598 Begin level 0 backup dpmdbs2.
2012-05-08 10:55:14 509408336598 Process 509408336598 successfully forked.
2012-05-08 10:55:14 353436336598 Begin level 0 backup dpmdbs8.
2012-05-08 10:55:14 395070336598 Process 395070336598 successfully forked.
2012-05-08 10:55:14 337046336598 Begin level 0 backup cmdbs02.
2012-05-08 10:55:14 427296336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 489060336598 Begin level 0 backup dpmdbs5.
2012-05-08 10:55:14 422536336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 255708336598 Process 255708336598 successfully forked.
2012-05-08 10:55:14 452180336598 Begin level 0 backup apmdbs12.
2012-05-08 10:55:14 340798336598 Begin level 0 backup nrmdbs.
2012-05-08 10:55:14 480638336598 Begin level 0 backup dpmdbs4.
2012-05-08 10:55:14 296016336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 566616336598 Begin level 0 backup apmdbs9.
2012-05-08 10:55:14 390726336598 Begin level 0 backup dpmdbs7.
2012-05-08 10:55:14 509408336598 Begin level 0 backup cmdbs12.
2012-05-08 10:55:14 389532336598 Begin level 0 backup cmdbs05.
2012-05-08 10:55:14 365026336598 Begin level 0 backup cmdbs03.
2012-05-08 10:55:14 463660336598 Begin level 0 backup dpmdbs6.
2012-05-08 10:55:14 484294336598 Begin level 0 backup cmdbs09.
2012-05-08 10:55:14 279750336598 Begin level 0 backup cmdbs07.
2012-05-08 10:55:14 340520336598 Begin level 0 backup dpmdbs1.
2012-05-08 10:55:14 353436336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 309224336598 Begin level 0 backup plogdbs.
2012-05-08 10:55:14 395070336598 Begin level 0 backup cmdbs08.
2012-05-08 10:55:14 259668336598 Begin level 0 backup cmdbs10.
2012-05-08 10:55:14 353078336598 Begin level 0 backup cmdbs04.
2012-05-08 10:55:14 337046336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 467740336598 Begin level 0 backup apmdbs6.
2012-05-08 10:55:14 831664336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 345096336598 Begin level 0 backup dpmdbs3.
2012-05-08 10:55:14 489060336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 324526336598 Begin level 0 backup llogdbs.
2012-05-08 10:55:14 340798336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 452180336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 721132336598 Begin level 0 backup cmdbs11.
2012-05-08 10:55:14 480638336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 255708336598 Begin level 0 backup cmdbs06.
2012-05-08 10:55:14 390726336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 566616336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 509408336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 365026336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 389532336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 463660336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 279750336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 484294336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 345096336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 467740336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 353078336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 395070336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 259668336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 309224336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 340520336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 255708336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 721132336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 324526336598 Successfully connected to Storage Manager.
2012-05-08 11:07:14 407088336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 11:07:14 336688336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 11:07:14 475926336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 13:47:18 721132336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 13:47:18 324526336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 13:48:31 279750336598 Completed level 0 backup cmdbs07 (Storage Manager copy ID: 1 1336455834).
2012-05-08 13:48:31 279750336598 Process 279750336598 completed.
2012-05-08 13:58:09 353436336598 Completed level 0 backup dpmdbs8 (Storage Manager copy ID: 1 1336455005).
2012-05-08 13:58:09 353436336598 Process 353436336598 completed.
2012-05-08 14:06:55 463660336598 Completed level 0 backup dpmdbs6 (Storage Manager copy ID: 1 1336455796).
2012-05-08 14:06:56 463660336598 Process 463660336598 completed.
2012-05-08 14:09:20 480638336598 Completed level 0 backup dpmdbs4 (Storage Manager copy ID: 1 1336456261).
2012-05-08 14:09:20 480638336598 Process 480638336598 completed.
2012-05-08 14:14:51 336688336598 Completed level 0 backup cmdbs01 (Storage Manager copy ID: 1 1336457364).
2012-05-08 14:14:51 336688336598 Process 336688336598 completed.
2012-05-08 14:16:10 484294336598 Completed level 0 backup cmdbs09 (Storage Manager copy ID: 1 1336457509).
2012-05-08 14:16:10 484294336598 Process 484294336598 completed.
2012-05-08 14:23:30 337046336598 Completed level 0 backup cmdbs02 (Storage Manager copy ID: 1 1336457920).
2012-05-08 14:23:30 337046336598 Process 337046336598 completed.
2012-05-08 14:27:14 431874336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 340520336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 255708336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 721132336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 324526336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:29:57 395070336598 Completed level 0 backup cmdbs08 (Storage Manager copy ID: 1 1336458357).
2012-05-08 14:29:57 395070336598 Process 395070336598 completed.
2012-05-08 14:32:46 340798336598 Completed level 0 backup nrmdbs (Storage Manager copy ID: 1 1336456028).
2012-05-08 14:32:46 340798336598 Process 340798336598 completed.
2012-05-08 14:33:02 309224336598 Completed level 0 backup plogdbs (Storage Manager copy ID: 1 1336458915).
2012-05-08 14:33:02 309224336598 Process 309224336598 completed.
2012-05-08 14:36:29 259668336598 Completed level 0 backup cmdbs10 (Storage Manager copy ID: 1 1336458747).
2012-05-08 14:36:29 259668336598 Process 259668336598 completed.
2012-05-08 15:02:42 345096336598 Completed level 0 backup dpmdbs3 (Storage Manager copy ID: 1 1336459138).
2012-05-08 15:02:42 345096336598 Process 345096336598 completed.
2012-05-08 15:07:14 427296336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:14 422536336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 340520336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 255708336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 324526336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 721132336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 427296336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 422536336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 365026336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 389532336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:15 353078336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 340520336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 255708336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 324526336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 721132336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:57:43 475926336598 Completed level 0 backup apmdbs3 (Storage Manager copy ID: 1 1336455302).
2012-05-08 15:57:44 475926336598 Process 475926336598 completed.
2012-05-08 15:58:48 407088336598 Completed level 0 backup apmdbs11 (Storage Manager copy ID: 1 1336454014).
2012-05-08 15:58:48 407088336598 Process 407088336598 completed.
2012-05-08 16:06:31 452180336598 Completed level 0 backup apmdbs12 (Storage Manager copy ID: 1 1336456838).
2012-05-08 16:06:31 452180336598 Process 452180336598 completed.
2012-05-08 16:06:38 353078336598 Completed level 0 backup cmdbs04 (Storage Manager copy ID: 1 1336464077).
2012-05-08 16:06:38 353078336598 Process 353078336598 completed.
2012-05-08 16:10:42 255708336598 Completed level 0 backup cmdbs06 (Storage Manager copy ID: 1 1336464540).
2012-05-08 16:10:42 255708336598 Process 255708336598 completed.
2012-05-08 16:14:55 365026336598 Completed level 0 backup cmdbs03 (Storage Manager copy ID: 1 1336464548).
2012-05-08 16:14:56 365026336598 Process 365026336598 completed.
2012-05-08 16:27:14 389532336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 16:27:18 324526336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 16:27:18 721132336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 16:38:45 427296336598 Completed level 0 backup npmdbs (Storage Manager copy ID: 1 1336464014).
2012-05-08 16:38:46 427296336598 Process 427296336598 completed.
2012-05-08 16:41:41 566616336598 Completed level 0 backup apmdbs9 (Storage Manager copy ID: 1 1336457840).
2012-05-08 16:41:42 566616336598 Process 566616336598 completed.
2012-05-08 16:41:51 389532336598 Completed level 0 backup cmdbs05 (Storage Manager copy ID: 1 1336466475).
2012-05-08 16:41:51 389532336598 Process 389532336598 completed.
2012-05-08 16:42:07 324526336598 Completed level 0 backup llogdbs (Storage Manager copy ID: 1 1336466662).
2012-05-08 16:42:07 324526336598 Process 324526336598 completed.
2012-05-08 16:42:42 431874336598 Completed level 0 backup apmdbs8 (Storage Manager copy ID: 1 1336458932).
2012-05-08 16:42:42 431874336598 Process 431874336598 completed.
2012-05-08 16:48:19 721132336598 Completed level 0 backup cmdbs11 (Storage Manager copy ID: 1 1336466652).
2012-05-08 16:48:19 721132336598 Process 721132336598 completed.
2012-05-08 16:49:28 340520336598 Completed level 0 backup dpmdbs1 (Storage Manager copy ID: 1 1336465045).
2012-05-08 16:49:28 340520336598 Process 340520336598 completed.
2012-05-08 17:09:39 467740336598 Completed level 0 backup apmdbs6 (Storage Manager copy ID: 1 1336460711).
2012-05-08 17:09:40 467740336598 Process 467740336598 completed.
2012-05-08 17:39:24 422536336598 Completed level 0 backup apmdbs10 (Storage Manager copy ID: 1 1336464792).
2012-05-08 17:39:25 422536336598 Process 422536336598 completed.
2012-05-08 17:39:25 336598550292 Archive on rootdbs, apmdbs11, apmdbs13, apmdbs1, apmdbs2, apmdbs10, apmdbs9, apmdbs3, apmdbs4, apmdbs6, apmdbs5, apmdbs7, apmdbs8, apmdbs12, nrmdbs, npmdbs, dpmdbs1, dpmdbs8, dpmdbs2, dpmdbs6, dpmdbs7, dpmdbs3, dpmdbs4, cmdbs04, cmdbs03, dpmdbs5, cmdbs01, cmdbs02, cmdbs12, cmdbs11, cmdbs08, cmdbs10, cmdbs09, cmdbs07, cmdbs06, cmdbs05, llogdbs, plogdbs Completed (Requested Level 0).
2012-05-08 17:39:26 336598550292 Successfully connected to Storage Manager.
2012-05-08 17:39:48 336598550292 /opt/informix/bin/onbar_d complete, returning 0 (0x00)
提示备份成功，一般来说可以恢复。。（不是一定，需要测试备份才知道onbar -v） 回复 2# liaosnet
我是用dbexport备份的
回复 2# liaosnet
我是用dbexport备份的，提示dbexport completed
恢复的时候用dbimport
提示：
*** create database
330 - Cannot create or rename the database.
100 - ISAM error:duplicate value for a record with unique key.
回复 4# 45888225hui
..这个。。。这个英文很容易吧。。你那实例上还有相同名字的库。。
dbexport备份并不会删除原来的库！ 回复 5# liaosnet
这个我删了
dbaccess→dababase→drop→（对应的数据库）
回复 5# liaosnet
这个我删了
dbaccess→dababase→drop→（对应的数据库）
然后导入数据 提示错误：
9810 - Smart-large-object error.
12053 - Smart Large Objects: No sbspace number specified.
No sbspace number specified. No sbspace number specified.
怎么解决呢？
页:
[1]