懂informix onbar备份的朋友帮忙看下bar_act.log

liujian135

我初次部署informix备份，不熟悉informix，没有恢复测试环境，不确定备份是否可以恢复，请从onbar日志确认备份过程是否正常。能否用于恢复？谢谢了
2012-05-08 10:54:16 336598  550292 /opt/informix/bin/onbar_d -b -w -L 0
2012-05-08 10:54:16 336598  550292 (-43336) Logical Logs cannot be backed-up because the database server is
dismissing the logical logs.
2012-05-08 10:54:16 336598  550292 Implicit logical log backup has been disabled.
2012-05-08 10:54:16 336598  550292 Working with veritas-netbackup as generic storage manager.
2012-05-08 10:54:16 336598  550292 (-43060) The buffer BAR_XFER_BUF_SIZE  exceeded maximum allowed limit. Changing size to 61440.
2012-05-08 10:54:35 336598  550292 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 336598  550292 Begin level 0 backup rootdbs.
2012-05-08 10:54:46 336598  550292 Successfully connected to Storage Manager.
2012-05-08 10:55:13 336598  550292 Completed level 0 backup rootdbs (Storage Manager copy ID: 1 1336445842).
2012-05-08 10:55:14 349020  336598 Process 349020  336598 successfully forked.
2012-05-08 10:55:14 407088  336598 Process 407088  336598 successfully forked.
2012-05-08 10:55:14 374276  336598 Process 374276  336598 successfully forked.
2012-05-08 10:55:14 332830  336598 Process 332830  336598 successfully forked.
2012-05-08 10:55:14 422536  336598 Process 422536  336598 successfully forked.
2012-05-08 10:55:14 475926  336598 Process 475926  336598 successfully forked.
2012-05-08 10:55:14 366120  336598 Process 366120  336598 successfully forked.
2012-05-08 10:55:14 583050  336598 Process 583050  336598 successfully forked.
2012-05-08 10:55:14 431874  336598 Process 431874  336598 successfully forked.
2012-05-08 10:55:14 566616  336598 Process 566616  336598 successfully forked.
2012-05-08 10:55:14 296016  336598 Process 296016  336598 successfully forked.
2012-05-08 10:55:14 427296  336598 Process 427296  336598 successfully forked.
2012-05-08 10:55:14 353078  336598 Process 353078  336598 successfully forked.
2012-05-08 10:55:14 467740  336598 Process 467740  336598 successfully forked.
2012-05-08 10:55:14 353436  336598 Process 353436  336598 successfully forked.
2012-05-08 10:55:14 345096  336598 Process 345096  336598 successfully forked.
2012-05-08 10:55:14 340798  336598 Process 340798  336598 successfully forked.
2012-05-08 10:55:14 374276  336598 Begin level 0 backup apmdbs1.
2012-05-08 10:55:14 349020  336598 Begin level 0 backup apmdbs13.
2012-05-08 10:55:14 407088  336598 Begin level 0 backup apmdbs11.
2012-05-08 10:55:14 452180  336598 Process 452180  336598 successfully forked.
2012-05-08 10:55:14 336688  336598 Process 336688  336598 successfully forked.
2012-05-08 10:55:14 374276  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 349020  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 463660  336598 Process 463660  336598 successfully forked.
2012-05-08 10:55:14 407088  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 337046  336598 Process 337046  336598 successfully forked.
2012-05-08 10:55:14 831664  336598 Process 831664  336598 successfully forked.
2012-05-08 10:55:14 332830  336598 Begin level 0 backup apmdbs2.
2012-05-08 10:55:14 489060  336598 Process 489060  336598 successfully forked.
2012-05-08 10:55:14 259668  336598 Process 259668  336598 successfully forked.
2012-05-08 10:55:14 366120  336598 Begin level 0 backup apmdbs4.
2012-05-08 10:55:14 480638  336598 Process 480638  336598 successfully forked.
2012-05-08 10:55:14 340520  336598 Process 340520  336598 successfully forked.
2012-05-08 10:55:14 583050  336598 Begin level 0 backup apmdbs5.
2012-05-08 10:55:14 336688  336598 Begin level 0 backup cmdbs01.
2012-05-08 10:55:14 475926  336598 Begin level 0 backup apmdbs3.
2012-05-08 10:55:14 332830  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 366120  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 431874  336598 Begin level 0 backup apmdbs8.
2012-05-08 10:55:14 389532  336598 Process 389532  336598 successfully forked.
2012-05-08 10:55:14 324526  336598 Process 324526  336598 successfully forked.
2012-05-08 10:55:14 390726  336598 Process 390726  336598 successfully forked.
2012-05-08 10:55:14 365026  336598 Process 365026  336598 successfully forked.
2012-05-08 10:55:14 484294  336598 Process 484294  336598 successfully forked.
2012-05-08 10:55:14 583050  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 427296  336598 Begin level 0 backup npmdbs.
2012-05-08 10:55:14 296016  336598 Begin level 0 backup apmdbs7.
2012-05-08 10:55:14 309224  336598 Process 309224  336598 successfully forked.
2012-05-08 10:55:14 336688  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 721132  336598 Process 721132  336598 successfully forked.
2012-05-08 10:55:14 422536  336598 Begin level 0 backup apmdbs10.
2012-05-08 10:55:14 475926  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 279750  336598 Process 279750  336598 successfully forked.
2012-05-08 10:55:14 431874  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 831664  336598 Begin level 0 backup dpmdbs2.
2012-05-08 10:55:14 509408  336598 Process 509408  336598 successfully forked.
2012-05-08 10:55:14 353436  336598 Begin level 0 backup dpmdbs8.
2012-05-08 10:55:14 395070  336598 Process 395070  336598 successfully forked.
2012-05-08 10:55:14 337046  336598 Begin level 0 backup cmdbs02.
2012-05-08 10:55:14 427296  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 489060  336598 Begin level 0 backup dpmdbs5.
2012-05-08 10:55:14 422536  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 255708  336598 Process 255708  336598 successfully forked.
2012-05-08 10:55:14 452180  336598 Begin level 0 backup apmdbs12.
2012-05-08 10:55:14 340798  336598 Begin level 0 backup nrmdbs.
2012-05-08 10:55:14 480638  336598 Begin level 0 backup dpmdbs4.
2012-05-08 10:55:14 296016  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 566616  336598 Begin level 0 backup apmdbs9.
2012-05-08 10:55:14 390726  336598 Begin level 0 backup dpmdbs7.
2012-05-08 10:55:14 509408  336598 Begin level 0 backup cmdbs12.
2012-05-08 10:55:14 389532  336598 Begin level 0 backup cmdbs05.
2012-05-08 10:55:14 365026  336598 Begin level 0 backup cmdbs03.
2012-05-08 10:55:14 463660  336598 Begin level 0 backup dpmdbs6.
2012-05-08 10:55:14 484294  336598 Begin level 0 backup cmdbs09.
2012-05-08 10:55:14 279750  336598 Begin level 0 backup cmdbs07.
2012-05-08 10:55:14 340520  336598 Begin level 0 backup dpmdbs1.
2012-05-08 10:55:14 353436  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 309224  336598 Begin level 0 backup plogdbs.
2012-05-08 10:55:14 395070  336598 Begin level 0 backup cmdbs08.
2012-05-08 10:55:14 259668  336598 Begin level 0 backup cmdbs10.
2012-05-08 10:55:14 353078  336598 Begin level 0 backup cmdbs04.
2012-05-08 10:55:14 337046  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 467740  336598 Begin level 0 backup apmdbs6.
2012-05-08 10:55:14 831664  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 345096  336598 Begin level 0 backup dpmdbs3.
2012-05-08 10:55:14 489060  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 324526  336598 Begin level 0 backup llogdbs.
2012-05-08 10:55:14 340798  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 452180  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 721132  336598 Begin level 0 backup cmdbs11.
2012-05-08 10:55:14 480638  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 255708  336598 Begin level 0 backup cmdbs06.
2012-05-08 10:55:14 390726  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 566616  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 509408  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 365026  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 389532  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 463660  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 279750  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:14 484294  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 345096  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 467740  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 353078  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 395070  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 259668  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:15 309224  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 340520  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 255708  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 721132  336598 Successfully connected to Storage Manager.
2012-05-08 10:55:18 324526  336598 Successfully connected to Storage Manager.
2012-05-08 11:07:14 407088  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 11:07:14 336688  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 11:07:14 475926  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 13:47:18 721132  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 13:47:18 324526  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 13:48:31 279750  336598 Completed level 0 backup cmdbs07 (Storage Manager copy ID: 1 1336455834).
2012-05-08 13:48:31 279750  336598 Process 279750  336598 completed.
2012-05-08 13:58:09 353436  336598 Completed level 0 backup dpmdbs8 (Storage Manager copy ID: 1 1336455005).
2012-05-08 13:58:09 353436  336598 Process 353436  336598 completed.
2012-05-08 14:06:55 463660  336598 Completed level 0 backup dpmdbs6 (Storage Manager copy ID: 1 1336455796).
2012-05-08 14:06:56 463660  336598 Process 463660  336598 completed.
2012-05-08 14:09:20 480638  336598 Completed level 0 backup dpmdbs4 (Storage Manager copy ID: 1 1336456261).
2012-05-08 14:09:20 480638  336598 Process 480638  336598 completed.
2012-05-08 14:14:51 336688  336598 Completed level 0 backup cmdbs01 (Storage Manager copy ID: 1 1336457364).
2012-05-08 14:14:51 336688  336598 Process 336688  336598 completed.
2012-05-08 14:16:10 484294  336598 Completed level 0 backup cmdbs09 (Storage Manager copy ID: 1 1336457509).
2012-05-08 14:16:10 484294  336598 Process 484294  336598 completed.
2012-05-08 14:23:30 337046  336598 Completed level 0 backup cmdbs02 (Storage Manager copy ID: 1 1336457920).
2012-05-08 14:23:30 337046  336598 Process 337046  336598 completed.
2012-05-08 14:27:14 431874  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 340520  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 255708  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 721132  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:27:18 324526  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 14:29:57 395070  336598 Completed level 0 backup cmdbs08 (Storage Manager copy ID: 1 1336458357).
2012-05-08 14:29:57 395070  336598 Process 395070  336598 completed.
2012-05-08 14:32:46 340798  336598 Completed level 0 backup nrmdbs (Storage Manager copy ID: 1 133645602.
2012-05-08 14:32:46 340798  336598 Process 340798  336598 completed.
2012-05-08 14:33:02 309224  336598 Completed level 0 backup plogdbs (Storage Manager copy ID: 1 1336458915).
2012-05-08 14:33:02 309224  336598 Process 309224  336598 completed.
2012-05-08 14:36:29 259668  336598 Completed level 0 backup cmdbs10 (Storage Manager copy ID: 1 1336458747).
2012-05-08 14:36:29 259668  336598 Process 259668  336598 completed.
2012-05-08 15:02:42 345096  336598 Completed level 0 backup dpmdbs3 (Storage Manager copy ID: 1 133645913.
2012-05-08 15:02:42 345096  336598 Process 345096  336598 completed.
2012-05-08 15:07:14 427296  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:14 422536  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 340520  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 255708  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 324526  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:07:18 721132  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 427296  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 422536  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 365026  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:14 389532  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:15 353078  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 340520  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 255708  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 324526  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:47:18 721132  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 15:57:43 475926  336598 Completed level 0 backup apmdbs3 (Storage Manager copy ID: 1 1336455302).
2012-05-08 15:57:44 475926  336598 Process 475926  336598 completed.
2012-05-08 15:58:48 407088  336598 Completed level 0 backup apmdbs11 (Storage Manager copy ID: 1 1336454014).
2012-05-08 15:58:48 407088  336598 Process 407088  336598 completed.
2012-05-08 16:06:31 452180  336598 Completed level 0 backup apmdbs12 (Storage Manager copy ID: 1 133645683.
2012-05-08 16:06:31 452180  336598 Process 452180  336598 completed.
2012-05-08 16:06:38 353078  336598 Completed level 0 backup cmdbs04 (Storage Manager copy ID: 1 1336464077).
2012-05-08 16:06:38 353078  336598 Process 353078  336598 completed.
2012-05-08 16:10:42 255708  336598 Completed level 0 backup cmdbs06 (Storage Manager copy ID: 1 1336464540).
2012-05-08 16:10:42 255708  336598 Process 255708  336598 completed.
2012-05-08 16:14:55 365026  336598 Completed level 0 backup cmdbs03 (Storage Manager copy ID: 1 133646454.
2012-05-08 16:14:56 365026  336598 Process 365026  336598 completed.
2012-05-08 16:27:14 389532  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 16:27:18 324526  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 16:27:18 721132  336598 (-43296) WARNING: BAR_TIMEOUT Storage Manager Progress may be stalled.
2012-05-08 16:38:45 427296  336598 Completed level 0 backup npmdbs (Storage Manager copy ID: 1 1336464014).
2012-05-08 16:38:46 427296  336598 Process 427296  336598 completed.
2012-05-08 16:41:41 566616  336598 Completed level 0 backup apmdbs9 (Storage Manager copy ID: 1 1336457840).
2012-05-08 16:41:42 566616  336598 Process 566616  336598 completed.
2012-05-08 16:41:51 389532  336598 Completed level 0 backup cmdbs05 (Storage Manager copy ID: 1 1336466475).
2012-05-08 16:41:51 389532  336598 Process 389532  336598 completed.
2012-05-08 16:42:07 324526  336598 Completed level 0 backup llogdbs (Storage Manager copy ID: 1 1336466662).
2012-05-08 16:42:07 324526  336598 Process 324526  336598 completed.
2012-05-08 16:42:42 431874  336598 Completed level 0 backup apmdbs8 (Storage Manager copy ID: 1 1336458932).
2012-05-08 16:42:42 431874  336598 Process 431874  336598 completed.
2012-05-08 16:48:19 721132  336598 Completed level 0 backup cmdbs11 (Storage Manager copy ID: 1 1336466652).
2012-05-08 16:48:19 721132  336598 Process 721132  336598 completed.
2012-05-08 16:49:28 340520  336598 Completed level 0 backup dpmdbs1 (Storage Manager copy ID: 1 1336465045).
2012-05-08 16:49:28 340520  336598 Process 340520  336598 completed.
2012-05-08 17:09:39 467740  336598 Completed level 0 backup apmdbs6 (Storage Manager copy ID: 1 1336460711).
2012-05-08 17:09:40 467740  336598 Process 467740  336598 completed.
2012-05-08 17:39:24 422536  336598 Completed level 0 backup apmdbs10 (Storage Manager copy ID: 1 1336464792).
2012-05-08 17:39:25 422536  336598 Process 422536  336598 completed.
2012-05-08 17:39:25 336598  550292 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 336598  550292 Successfully connected to Storage Manager.
2012-05-08 17:39:48 336598  550292 /opt/informix/bin/onbar_d complete, returning 0 (0x00)

liaosnet

提示备份成功，一般来说可以恢复。。（不是一定，需要测试备份才知道  onbar -v）

45888225hui

回复 2# liaosnet

我是用dbexport备份的


   

45888225hui

回复 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.

   

liaosnet

回复 4# 45888225hui


    ..这个。。。这个英文很容易吧。。你那实例上还有相同名字的库。。

dbexport备份并不会删除原来的库！

45888225hui

回复 5# liaosnet


这个我删了
    dbaccess→dababase→drop→（对应的数据库）

45888225hui

回复 5# liaosnet



这个我删了
    dbaccess→dababase→drop→（对应的数据库）

然后导入数据 提示错误：

9810 - Smart-large-object error.

12053 - Smart Large Objects: No sbspace number specified.

   

hugolin168

No sbspace number specified.

45888225hui

No sbspace number specified.

怎么解决呢？