Onbar dbspace restores by time of backup
Posted in 2016
OS: 6.1.3.0
IDS: 11.50.FC5
We are trying to restore specific dbspaces from and onbar backup by timestamp.
We don't need to restore the full database, but just specific dbspaces. We are
receiving dbspaces are not down.
Bar_log.act:
2016-08-04 22:41:41 942204 1011838 Archive on rootdbs, dwa_poe_dtl_n_dbs27,
scvdw_bkg_dbs01, dwa_poe_dtl_n_dbs26, dwa_poe_dtl
_n_dbs28, scvdw_dbs01, dwa_poe_dtl_n_dbs32, dwa_poe_id1_n_dbs01,
dwa_poe_dtl_n_dbs31, dwa_iber_dtl_n_dbs20, dwa_iber_dtl_n_dbs1
9, dwa_poe_dtl_n_dbs29, dwa_iber_dtl_n_dbs21, dwa_poe_dtl_n_dbs30,
dwa_iber_dtl_n_dbs18, dwa_obes_dtl_dbs24, dwa_obes_dtl_dbs23
, dwa_iber_dtl_n_dbs22, dwa_ibea_id2_dbs01, dwa_ober_id1_dbs01,
dwa_ibea_id1_dbs01, dwa_obes_dtl_dbs22, dwa_dos_idx_dbs01, dwa_
iber_id1_n_dbs01, dwa_iber_hdr_n_dbs16, dwa_iber_hdr_n_dbs17,
dwa_iber_hdr_n_dbs18, dwa_obes_id1_dbs01, dwa_poe_ih2_dbs01, dwa_
iber_hdr_n_dbs15, dwa_ibea_dtl_dbs25, dwa_ibea_dtl_dbs26, dwa_ibea_dtl_dbs27,
dwa_obes_dtl_dbs25, dwa_ibea_dtl_dbs28, dwa_ober_
ih2_dbs01, dwa_ober_hdr_dbs11, dwa_ober_hdr_dbs09, dwa_poe_hdr_dbs07,
dwa_iber_ih2_n_dbs01, dwa_ober_hdr_dbs10, dwa_ibea_dtl_db
s29, dwa_ober_dtl_dbs25, dwa_ober_dtl_dbs29, dwa_ober_dtl_dbs26,
dwa_ober_dtl_dbs24, dwa_ibea_hdr_dbs07, dwa_ober_dtl_dbs27, dw
a_poe_hdr_dbs06, dwa_ober_dtl_dbs28, dwa_ibea_ih2_dbs01, dwa_ober_ih1_dbs01,
dwa_iber_ih1_n_dbs01, dwa_poe_ih1_dbs01, dwa_obes_
hdr_dbs04, dwa_shp_tw_dbs12, dwa_shp_emp_dbs12, dwa_mtch_tbl_dbs01,
dwa_iber_ih3_n_dbs01, dwa_ibdr_dtl_dbs09, dwa_ibdr_dtl_dbs0
7, dwa_ibdr_dtl_dbs08, dwa_iber_hdr_n_dbs19, dwa_pod_dtl_dbs12,
dwa_pod_dtl_dbs09, scvdw_wrk_dbs01, dwa_ibdr_hdr_dbs07, dwa_ibd
r_hdr_dbs08, dwa_ibdr_hdr_dbs09, dwa_pod_dtl_dbs10, dwa_pod_dtl_dbs11,
dwa_poe_dtl_n_dbs33, dwa_ibda_dtl_dbs13, dwa_ibdr_dtl_db
s10, dwa_shp_dd_dbs12, dwa_ibea_ih1_dbs01, dwa_ibda_dtl_dbs12,
dwa_ibda_dtl_dbs11, dwa_ibda_dtl_dbs10, dwa_manasn_dbs01, dwa_ib
da_hdr_dbs05, dwa_ibdr_hdr_dbs10, sysadmin, dwa_atcy_trla_dtl_dbs01,
dwa_obes_ih1_dbs01, dwa_mtch_ix1_dbs01, dwa_vrelcurr_dbs01
, dwa_pod_hdr_dbs04, dwa_mtch_ix2_dbs01, dwa_vrelprev_dbs01,
dwa_ober_hdr_dbs12, dwa_atcy_trla_ix1_dbs01, scvdw_ref_dbs01, dwa_
mtch_ix3_dbs01, dwa_eman_xref_ix1_dbs01, dwa_eman_xref_dbs01,
dwa_mtch_ix4_dbs01, dwa_mtch_ix5_dbs01, dwa_shp_ixd_dbs01, dwa_sh
p_ixe_dbs01, dwa_shp_ixf_dbs01, dwa_shp_ixt_dbs01, dwa_ibea_dtl_dbs30,
dwa_ober_dtl_dbs30, dwa_shp_dd_dbs13, dwa_shp_dd_dbs14,
dwa_shp_dd_dbs15, dwa_shp_emp_dbs13, dwa_shp_emp_dbs14, dwa_shp_emp_dbs15,
dwa_shp_fsh_dbs12, dwa_shp_fsh_dbs13, dwa_shp_fsh_db
s14, dwa_shp_fsh_dbs15, dwa_shp_tw_dbs13, dwa_shp_tw_dbs14, dwa_shp_tw_dbs15,
llogdbs, plogdbs, atc_ibea_trk01, dwa_pod_rdt_dbs
01, dwa_pod_rdt_dbs02, dwa_pod_rdt_dbs03, dwa_pod_rdt_dbs04 Completed
(Requested Level 0).
Receiving error now:
2016-08-17 02:17:56 1241164 1339588 Process 1241164 1339588 successfully
forked.
2016-08-17 02:17:56 954540 1339588 Process 954540 1339588 successfully forked.
2016-08-17 02:17:56 1241164 1339588 Successfully connected to Storage Manager.
2016-08-17 02:17:56 954540 1339588 Successfully connected to Storage Manager.
2016-08-17 02:17:56 1241164 1339588 XBSA Error: (BSAGetObject) Backup object
does not exist in Storage Manager.
2016-08-17 02:17:56 1241164 1339588 Object information: bar_objdesc
obj_id 109 obj_name 'dwa_shp_ixt_dbs01' obj_type 'ND' act_id 0 act_type 2
act_status 0
act_start '2016-08-17 02:17:56' act_end ''
ins_time 0 rsam_time -1247026752 seal_time 1470276739 prev_seal_time
1470191224 level 0 copyid hi:lo 0:1890122735 req_act_id 3785
logstream 0 est_pages hi:lo 0:0 first_log 1938 chpt_log 1938 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 1 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host '' backup_order 0
2016-08-17 02:17:56 954540 1339588 XBSA Error: (BSAGetObject) Backup object
does not exist in Storage Manager.
2016-08-17 02:17:56 954540 1339588 Object information: bar_objdesc
obj_id 83 obj_name 'dwa_shp_ixf_dbs01' obj_type 'ND' act_id 0 act_type 2
act_status 0
act_start '2016-08-17 02:17:56' act_end ''
ins_time 0 rsam_time -1247026752 seal_time 1470276739 prev_seal_time
1470191224 level 0 copyid hi:lo 0:1890122734 req_act_id 3785
logstream 0 est_pages hi:lo 0:0 first_log 1938 chpt_log 1938 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 1 in_catalog 0 in_bootfile 0 child_pid 0 child_state 0
bkup_host '' backup_order 0
2016-08-17 02:17:57 999450 1339588 (-43260) ON-Bar was unable to get backup
record of dwa_shp_ixe_dbs01 from storage manager.
2016-08-17 02:17:57 999450 1339588 Process 999450 1339588 completed.
2016-08-17 02:17:57 1241164 1339588 (-43260) ON-Bar was unable to get backup
record of dwa_shp_ixt_dbs01 from storage manager.
2016-08-17 02:17:57 1241164 1339588 Process 1241164 1339588 completed.
2016-08-17 02:17:57 1339588 950438 (-43246) The ON-Bar process 999450 exited
with a problem (exit code 100 (0x64),
signal 0).
2016-08-17 02:17:57 1339588 950438 (-43246) The ON-Bar process 1241164 exited
with a problem (exit code 100 (0x64),
signal 0).
2016-08-17 02:17:58 954540 1339588 (-43260) ON-Bar was unable to get backup
record of dwa_shp_ixf_dbs01 from storage manager.
2016-08-17 02:17:58 954540 1339588 Process 954540 1339588 completed.
2016-08-17 02:17:58 1339588 950438 (-43246) The ON-Bar process 954540 exited
with a problem (exit code 100 (0x64),
signal 0).
2016-08-17 02:17:58 1339588 950438 /dbengines/informix_11.50FC5/bin/onbar_d
complete, returning 100 (0x64)
Thanks,
********************************************************************************
**********
Ernie Knox
Sr. Technologist, Member Technology - Database Management
Sears Holdings Management Corp
3333 Beverly Rd.
Hoffman Estates, IL. 60179
Office: (847) 286-5735
Email: Ernest.Knox@searshc.com<mailto:Ernest.Knox@searshc.com>
Cell: (847) 665-0722
Corp. Cell: 224-465-0553
Corp. Text: 2244650553@txt.att.net
Informix Email: ifmxdba@searshc.com<mailto:ifmxdba@searshc.com> and Team:
InformixDBA@searshc.com<mailto:InformixDBA@searshc.com>
Informix Primary:
INFORMIXDBAPrimaryPager@searshc.com<mailto:INFORMIXDBAPrimaryPager@searshc.com>
Informix Secondary:
INFORMIXDBASecondaryPager@searshc.com<mailto:INFORMIXDBASecondaryPager@searshc.c
om>
MySQL Email: MYSQLDBAe@searshc.com<mailto:MYSQLDBAe@searshc.com> and Team:
MySQLDBA2@searshc.com<mailto:MySQLDBA2@searshc.com>
MySQL Primary:
MYSQLDBAPrimaryPager@searshc.com<mailto:MYSQLDBAPrimaryPager@searshc.com>
MySQL Secondary:
MYSQLDBASecondaryPager@searshc.com<mailto:MYSQLDBASecondaryPager@searshc.com>
For more information, view our DBA Wiki page link below:
http://wiki.intra.sears.com/confluence/display/TechStrag/Database+Management#Dat
abaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Databas
e+Management>
For creating ServiceNow request, use the link below:
https://sears.service-now.com<https://sears.service-now.com/>
Have I provided a WOW member experience today?
Send a Members' First Recognition