onbar恢复出错一例记录

数据库出现页错误,不得以进行整库恢复,但恢复的时候报错

 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,以免影响正常的备份恢复。

标签: none

添加新评论

Free Web Hosting