RE: Onbar dbspace restores by time of backup
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.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 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@@NL