blogger

    blogger
  • hot log

  • comment

    twitter

    • 12.10.xC6出来时候碰到"Could not determine encryption mode from page zero",竟果然是BUG!http://www-01.ibm.com/support/docview.wss?rs=630&uid=swg21973408

      2015-12-21 20:15

    • 空间已经转移到新加坡,希望会好一些。

      2015-11-16 14:34

    • 增加新域名liaosnet.cc,与liaosnet.com同指向。

      2015-10-09 15:25

    • 空间迁移到香港。或许速度会快一点。。

      2014-02-13 20:10

    • 解决个问题:NBU配置Storage时的目录在系统分区上,导致备份失败,最终原因是目录在系统分区上时,需要在 This directory can exist on the root file system or system disk. 这个选项前打上勾。

      2012-09-26 22:21

    • More»

    blog sort

    links

    record

    banner

    onbar恢复出错一例记录

    暗夜星空's Memory from Dec 1 , 2015 at 17:02 PM , under Category:INFORMIX
    数据库出现页错误,不得以进行整库恢复,但恢复的时候报错
     2015-11-26 01:19:39 9699838  8978918 /export/home/informix/bin/onbar_d -r -w
     2015-11-26 01:19:39 9699838  8978918 Working with veritas-netbackup as generic storage manager.
     2015-11-26 01:19:39 9699838  8978918 Successfully connected to Storage Manager.
     2015-11-26 01:19:39 9699838  8978918 Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 26922  Current log id: 26935
     2015-11-26 01:19:40 9699838  8978918 Successfully connected to Storage Manager.
     2015-11-26 01:19:43 9699838  8978918 XBSA Error: (BSAGetObject) A system error occurred. Aborting XBSA session.
     2015-11-26 01:19:43 9699838  8978918 Object information: bar_objdesc
         obj_id 0 obj_name 'rootdbs' obj_type 'R' act_id 9235 act_type 3 act_status 0
         act_start '2015-11-26 01:19:40'  act_end '2015-11-18 14:00:27'
         ins_time 0 rsam_time -814932752 seal_time 1447826427 prev_seal_time 1447826400 level 0 copyid hi:lo 1:1447826448 req_act_id 9235
         logstream 0 est_pages hi:lo 0:0 first_log 35155 chpt_log 35155 last_log 0
         partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
         ins_verify 0 ins_verify_date '' restore order 0:0
         objInfo ''
         retry 0 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
         bkup_host '' backup_order 359
     2015-11-26 01:19:43 9699838  8978918 (-43342) Cannot read reserved pages from rootdbs object.
     2015-11-26 01:19:43 9699838  8978918 /export/home/informix/bin/onbar_d complete, returning 3 (0x03)
    从出错信息上看,显示不能从rootdbs上读取保留页,但是我们是整库恢复,关保留页什么事?
    从官网找到一个类似的案例:http://www-01.ibm.com/support/docview.wss?uid=swg21656166
    corrupt, incomplete or misnamed ixbar file copied to target server
    onconfig file not duplicated from Source to Target server
    environment variable ISM_CLIENT not set to the machine name where the backup was taken.
    依据提示 与 当前日志 
    Warning: The ixbar file is missing an entry for one or more logical logs. Last log id: 26922  Current log id: 26935
    检查发现ixbar.10中果然没有26922到26935之间的记录(虽然这个记录很遥远),考虑到ixbar比较大,于是手式将ixbar.10的内容清理到最后一次备份前几天(由于数据库未启动,无法使用onsmsync方式进行清理)。
    再次尝试恢复,数据库能正常运行
     2015-11-26 01:25:30 42401796  8061430 onsmsync -t 2015-11-01 00:00:00
     2015-11-26 01:26:31 42401796  8061430 (-43207) Unable to open connection to database server: .
     2015-11-26 01:26:31 42401796  8061430 onsmsync complete, returning 155 (0x9b)
     2015-11-26 01:31:01 48365816  8978922 /export/home/informix/bin/onbar_d -r -w
     2015-11-26 01:31:01 48365816  8978922 Working with veritas-netbackup as generic storage manager.
     2015-11-26 01:31:01 48365816  8978922 Successfully connected to Storage Manager.
     2015-11-26 01:31:01 48365816  8978922 Successfully connected to Storage Manager.
     2015-11-26 01:33:07 48365816  8978922 Begin reserved pages read (level 0 of rootdbs, Storage Manager copy ID: 1 1447826448).
     2015-11-26 01:33:09 48365816  8978922 Completed reserved pages read (level 0 of rootdbs).
     2015-11-26 01:33:10 48365816  8978922 Successfully connected to Storage Manager.
     2015-11-26 01:33:22 48365816  8978922 Begin cold level 0 restore rootdbs (Storage Manager copy ID: 1 1447826448).
     2015-11-26 01:37:02 48365816  8978922 Completed cold level 0 restore rootdbs.
     2015-11-26 01:38:42 48365816  8978922 Begin cold level 0 restore nmosdbs (Storage Manager copy ID: 1 1447826607).

    使用onbar进行备份恢复时,需要及时清理ixbar.10,以免影响正常的备份恢复。

    Post a comment:

    Your email address will not be published. Required fields are marked﹡