If we do a dbspace restore is it the timestamp of the full backup start or completed timestamp or the timestamp the dbspace completed it's backup?
2016-08-04 22:27:18 942204 1011838 Archive started 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_dt
l_n_dbs19, 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_d
tl_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_dbs
01, 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_dbs
01, 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, d
wa_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_ibe
a_dtl_dbs29, dwa_ober_dtl_dbs25, dwa_ober_dtl_dbs29, dwa_ober_dtl_dbs26, dwa_ober_dtl_dbs24, dwa_ibea_hdr_dbs07, dwa_ober_dtl_d
bs27, dwa_poe_hdr_dbs06, dwa_ober_dtl_dbs28, dwa_ibea_ih2_dbs01, dwa_ober_ih1_dbs01, dwa_iber_ih1_n_dbs01, dwa_poe_ih1_dbs01, d
wa_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_dbs07, 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_ibdr_hdr_dbs08, dwa_ibdr_hdr_dbs09, dwa_pod_dtl_dbs10, dwa_pod_dtl_dbs11, dwa_poe_dtl_n_dbs33, dwa_ibda_dtl_dbs13, dwa_ibd
r_dtl_dbs10, dwa_shp_dd_dbs12, dwa_ibea_ih1_dbs01, dwa_ibda_dtl_dbs12, dwa_ibda_dtl_dbs11, dwa_ibda_dtl_dbs10, dwa_manasn_dbs01
, dwa_ibda_hdr_dbs05, dwa_ibdr_hdr_dbs10, sysadmin, dwa_atcy_trla_dtl_dbs01, dwa_obes_ih1_dbs01, dwa_mtch_ix1_dbs01, dwa_vrelcu
rr_dbs01, dwa_pod_hdr_dbs04, dwa_mtch_ix2_dbs01, dwa_vrelprev_dbs01, dwa_ober_hdr_dbs12, dwa_atcy_trla_ix1_dbs01, scvdw_ref_dbs
01, 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_shp_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_sh
p_fsh_dbs14, dwa_shp_fsh_dbs15, dwa_shp_tw_dbs13, dwa_shp_tw_dbs14, dwa_shp_tw_dbs15, llogdbs, plogdbs, atc_ibea_trk01, dwa_pod
_rdt_dbs01, dwa_pod_rdt_dbs02, dwa_pod_rdt_dbs03, dwa_pod_rdt_dbs04 (Requested Level 0).
2016-08-04 22:27:19 942204 1011838 Begin level 0 backup rootdbs.
2016-08-04 22:27:19 942204 1011838 Successfully connected to Storage Manager.
2016-08-04 22:27:20 942204 1011838 Completed level 0 backup rootdbs (Storage Manager copy ID: 0 1890394589).
2016-08-04 22:27:20 1421394 942204 Process 1421394 942204 successfully forked.
2016-08-04 22:27:20 1298602 942204 Process 1298602 942204 successfully forked.
2016-08-04 22:27:20 893148 942204 Process 893148 942204 successfully forked.
2016-08-04 22:27:20 1261768 942204 Process 1261768 942204 successfully forked.
2016-08-04 22:27:20 1421394 942204 Begin level 0 backup scvdw_bkg_dbs01.
2016-08-04 22:27:20 1261768 942204 Begin level 0 backup dwa_poe_dtl_n_dbs28.
2016-08-04 22:27:20 1298602 942204 Begin level 0 backup dwa_poe_dtl_n_dbs27.
2016-08-04 22:27:20 893148 942204 Begin level 0 backup dwa_poe_dtl_n_dbs26.
2016-08-04 22:27:20 1421394 942204 Successfully connected to Storage Manager.
2016-08-04 22:27:20 1261768 942204 Successfully connected to Storage Manager.
2016-08-04 22:27:21 893148 942204 Successfully connected to Storage Manager.
2016-08-04 22:27:21 1298602 942204 Successfully connected to Storage Manager.
2016-08-04 22:28:57 1261768 942204 Completed level 0 backup dwa_poe_dtl_n_dbs28 (Storage Manager copy ID: 0 1890394592).
2016-08-04 22:28:57 1261768 942204 Process 1261768 942204 completed.
2016-08-04 22:28:57 1261770 942204 Process 1261770 942204 successfully forked.
2016-08-04 22:28:57 1261770 942204 Begin level 0 backup scvdw_dbs01.
2016-08-04 22:28:58 1261770 942204 Successfully connected to Storage Manager.
2016-08-04 22:29:28 893148 942204 Completed level 0 backup dwa_poe_dtl_n_dbs26 (Storage Manager copy ID: 0 1890394593).
2016-08-04 22:29:29 893148 942204 Process 893148 942204 completed.
2016-08-04 22:29:29 893150 942204 Process 893150 942204 successfully forked.
2016-08-04 22:29:29 893150 942204 Begin level 0 backup dwa_poe_dtl_n_dbs32.
2016-08-04 22:29:29 893150 942204 Successfully connected to Storage Manager.
2016-08-04 22:29:53 1421394 942204 Completed level 0 backup scvdw_bkg_dbs01 (Storage Manager copy ID: 0 1890394591).
2016-08-04 22:29:53 1421394 942204 Process 1421394 942204 completed.
2016-08-04 22:29:53 1421396 942204 Process 1421396 942204 successfully forked.
2016-08-04 22:29:53 1421396 942204 Begin level 0 backup dwa_poe_id1_n_dbs01.
2016-08-04 22:29:53 1421396 942204 Successfully connected to Storage Manager.
2016-08-04 22:30:35 1261770 942204 Completed level 0 backup scvdw_dbs01 (Storage Manager copy ID: 0 1890394743).
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.com>
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#DatabaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Database+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 to this Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>
Nominate this Associate for a Technology Excellence Award<http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default.aspx>
My Area:
" Yes we can make a Change! "
" IF you can think it, you can do it! "
" Sometimes to secure the future, you have to let go of the past! "
" IT'S always a great day to watch Sports: FOOTBALL "
GSU
MISSION:
" The focus of my life begins at home with family, loved ones, and friends. I want to use my resources to create a
secure environment that fosters love, learning, laughter, and mutual success. I will protect and value integrity. I
will admit and quickly correct my mistakes. I will be a self-starter. I will be a caring person. I will be a good listener
with an open mind. I will continue to grow and learn. I will facilitate and celebrate the success of others. "
******************************************************************************************
From: Knox, Ernest
Sent: Wednesday, August 17, 2016 1:42 AM
To: ids@iiug.org
Subject: Onbar dbspace restores by time of backup
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<mailto: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.com>
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#DatabaseManagement<http://wiki.intra.sears.com/confluence/display/TechStrag/Database+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 to this Associate<http://searslabs.intra.searshc.com/irlabs/recognition/>
Nominate this Associate for a Technology Excellence Award<http://support.searshc.com/it/Home/TechExcellenceAwards/tabid/4271/Default.aspx>
My Area:
" Yes we can make a Change! "
" IF you can think it, you can do it! "
" Sometimes to secure the future, you have to let go of the past! "
" IT'S always a great day to watch Sports: FOOTBALL "
GSU
MISSION:
" The focus of my life begins at home with family, loved ones, and friends. I want to use my resources to create a
secure environment that fosters love, learning, laughter, and mutual success. I will protect and value integrity. I
will admit and quickly correct my mistakes. I will be a self-starter. I will be a caring person. I will be a good listener
with an open mind. I will continue to grow and learn. I will facilitate and celebrate the success of others. "
******************************************************************************************
This message, including any attachments, is the property of Sears Holdings Corporation and/or one of its subsidiaries. It is confidential and may contain proprietary or legally privileged information. If you are not the intended recipient, please delete it without reading the contents. Thank you.
