NBU备份rac恢复到single

xiaoxiao2021-03-25 89

1. 根据生产spfile,创建恢复数据库pfile

2. *.audit_file_dest='/u01/app8/oracle/admin/zjyw/adump'

3. *.audit_trail='NONE'

4. *.cluster_database=false

5. *.compatible='11.2.0.4.0'

6. *.control_files='/orabak_data1/zjyw38/controlfile/control01..ctl'

7. *.db_block_size=8192

8. *.db_create_file_dest='/orabak_data1/zjyw38/datafile/'

9. *.db_domain=''

10. *.db_name='zjyw'

11. *.diagnostic_dest='/u01/app8/oracle'

12. *.dispatchers='(PROTOCOL=TCP) (SERVICE=zjywXDB)'

13. *.event='10298 trace name context forever,level 32'

14. *.instance_number=1

15. *.log_archive_dest_1='LOCATION='/orabak_data1/zjyw38/arch'

16. *.log_archive_format='%t_%s_%r.arch'

17. *.memory_target=17436770304

18. *.open_cursors=2000

19. *.pga_aggregate_target=4294967296

20. *.processes=2000

21. *.remote_login_passwordfile='exclusive'

22. *.sessions=1655

23. *.undo_tablespace='UNDOTBS1'

2.启动数据库到nomont并恢复控制文件

从NBU备份里面恢复出日期为2017-03-06 的控制文件

RMAN> run {

2> allocate channel ch1 type 'SBT_TAPE';

3> send 'NB_ORA_SERV=nbuserver,NB_ORA_CLIENT=kaafa0db003r_nbu';

4> restore controlfile from '/cntrl_ZJYW_20170306_32729_upruebe4_1_1';

5> release channel ch1;

6> }

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=2270 device type=SBT_TAPE

channel ch1: Veritas NetBackup for Oracle - Release 7.6 (2014102802)

sent command to channel: ch1

Starting restore at 2017-03-08 15:48:20

channel ch1: restoring control file

channel ch1: restore complete, elapsed time: 00:01:25

output file name=/orabak_data1/zjyw38/controlfile/control01..ctl

Finished restore at 2017-03-08 15:49:46

released channel: ch1

3.将数据库起到mount，并restore数据库

run {

allocate channel ch1 type 'SBT_TAPE';

allocate channel ch2 type 'SBT_TAPE';

allocate channel ch3 type 'SBT_TAPE';

allocate channel ch4 type 'SBT_TAPE';

allocate channel ch5 type 'SBT_TAPE';

allocate channel ch6 type 'SBT_TAPE';

allocate channel ch7 type 'SBT_TAPE';

allocate channel ch8 type 'SBT_TAPE';

send 'NB_ORA_SERV=nbuserver,NB_ORA_CLIENT=kaafa0db003r_nbu';

set newname for datafile 1 to '/orabak_data1/zjyw38/datafile/system.463.929198409';

set newname for datafile 2 to '/orabak_data1/zjyw38/datafile/sysaux.285.929205129';

set newname for datafile 3 to '/orabak_data1/zjyw38/datafile/undotbs1.350.929202661';

set newname for datafile 4 to '/orabak_data1/zjyw38/datafile/undotbs2.349.929202661';

set newname for datafile 5 to '/orabak_data1/zjyw38/datafile/users.290.929205043 ';

set newname for datafile 6 to '/orabak_data1/zjyw38/datafile/afadata.439.929199071 ';

set newname for datafile 7 to '/orabak_data1/zjyw38/datafile/lcdata.438.929199079';

set newname for datafile 8 to '/orabak_data1/zjyw38/datafile/dsdfdata.445.929198065';

set newname for datafile 9 to '/orabak_data1/zjyw38/datafile/xnbdata_fz.313.929204251';

set newname for datafile 10 to '/orabak_data1/zjyw38/datafile/xnbdata_xm.308.929204389';

set newname for datafile 11 to '/orabak_data1/zjyw38/datafile/xnbdata_pt.303.929204413';

set newname for datafile 12 to '/orabak_data1/zjyw38/datafile/xnbdata_sm.293.929205007';

set newname for datafile 13 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.298.929204949';

set newname for datafile 14 to '/orabak_data1/zjyw38/datafile/xnbdata_zz.328.929203547';

set newname for datafile 15 to '/orabak_data1/zjyw38/datafile/xnbdata_np.339.929203363';

set newname for datafile 16 to '/orabak_data1/zjyw38/datafile/xnbdata_nd.334.929203407';

set newname for datafile 17 to '/orabak_data1/zjyw38/datafile/xnbdata_ly.319.929204207';

set newname for datafile 18 to '/orabak_data1/zjyw38/datafile/xnbdata_fz.283.929205133';

set newname for datafile 19 to '/orabak_data1/zjyw38/datafile/xnbdata_fz.288.929205047';

set newname for datafile 20 to '/orabak_data1/zjyw38/datafile/dsdfdata.384.929200957';

set newname for datafile 21 to '/orabak_data1/zjyw38/datafile/xnbdata_np.391.929200945';

set newname for datafile 22 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.390.929200947';

set newname for datafile 23 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.282.929205133';

set newname for datafile 24 to '/orabak_data1/zjyw38/datafile/dsdfdata.287.929205049';

set newname for datafile 25 to '/orabak_data1/zjyw38/datafile/dsdfdata.417.929200065';

set newname for datafile 26 to '/orabak_data1/zjyw38/datafile/dsdfdata.412.929200073';

set newname for datafile 27 to '/orabak_data1/zjyw38/datafile/dsdfdata.408.929200079';

set newname for datafile 28 to '/orabak_data1/zjyw38/datafile/dsdfdata.403.929200299';

set newname for datafile 29 to '/orabak_data1/zjyw38/datafile/dsdfdata.398.929200935';

set newname for datafile 30 to '/orabak_data1/zjyw38/datafile/dsdfdata.325.929203549';

set newname for datafile 31 to '/orabak_data1/zjyw38/datafile/dsdfdata.312.929204253';

set newname for datafile 32 to '/orabak_data1/zjyw38/datafile/dsdfdata.307.929204391';

set newname for datafile 33 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.302.929204415';

set newname for datafile 34 to '/orabak_data1/zjyw38/datafile/dsdfdata.292.929205009';

set newname for datafile 35 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.297.929204951';

set newname for datafile 36 to '/orabak_data1/zjyw38/datafile/dsdfdata.326.929203549';

set newname for datafile 37 to '/orabak_data1/zjyw38/datafile/dsdfdata.338.929203365';

set newname for datafile 38 to '/orabak_data1/zjyw38/datafile/xnbdata_nd.333.929203409';

set newname for datafile 39 to '/orabak_data1/zjyw38/datafile/xnbdata_ly.318.929204209';

set newname for datafile 40 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.345.929202673';

set newname for datafile 41 to '/orabak_data1/zjyw38/datafile/xnbidx_pt.430.929199093 ';

set newname for datafile 42 to '/orabak_data1/zjyw38/datafile/xnbidx_xm.426.929199097 ';

set newname for datafile 43 to '/orabak_data1/zjyw38/datafile/xnbidx_fz.346.929202673 ';

set newname for datafile 44 to '/orabak_data1/zjyw38/datafile/xnbidx_sm.358.929202549 ';

set newname for datafile 45 to '/orabak_data1/zjyw38/datafile/xnbidx_np.353.929202563 ';

set newname for datafile 46 to '/orabak_data1/zjyw38/datafile/xnbidx_nd.368.929201795 ';

set newname for datafile 47 to '/orabak_data1/zjyw38/datafile/xnbidx_zz.363.929201803 ';

set newname for datafile 48 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.378.929201705 ';

set newname for datafile 49 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.373.929201729 ';

set newname for datafile 50 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.383.929200959 ';

set newname for datafile 51 to '/orabak_data1/zjyw38/datafile/xnbidx_ly.444.929198691 ';

set newname for datafile 52 to '/orabak_data1/zjyw38/datafile/xnbidx_np.321.929203555 ';

set newname for datafile 53 to '/orabak_data1/zjyw38/datafile/xnbidx_fz.454.929198095 ';

set newname for datafile 54 to '/orabak_data1/zjyw38/datafile/xnbdata_np.437.929199081';

set newname for datafile 55 to '/orabak_data1/zjyw38/datafile/xnbidx_nd.389.929200947 ';

set newname for datafile 56 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.388.929200949 ';

set newname for datafile 57 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.281.929205135 ';

set newname for datafile 58 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.286.929205049';

set newname for datafile 59 to '/orabak_data1/zjyw38/datafile/xnbidx_ly.464.929198411 ';

set newname for datafile 60 to '/orabak_data1/zjyw38/datafile/xnbdata_nd.416.929200067';

set newname for datafile 61 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.411.929200075';

set newname for datafile 62 to '/orabak_data1/zjyw38/datafile/sysaux.315.929204249';

set newname for datafile 63 to '/orabak_data1/zjyw38/datafile/xnbidx_fz.424.929199563 ';

set newname for datafile 64 to '/orabak_data1/zjyw38/datafile/xnbidx_fz.458.929198093 ';

set newname for datafile 65 to '/orabak_data1/zjyw38/datafile/xnbidx_np.322.929203555 ';

set newname for datafile 66 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.407.929200081';

set newname for datafile 67 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.402.929200301 ';

set newname for datafile 68 to '/orabak_data1/zjyw38/datafile/xnbdata_fz.397.929200935';

set newname for datafile 69 to '/orabak_data1/zjyw38/datafile/xnbidx_fz.336.929203367 ';

set newname for datafile 70 to '/orabak_data1/zjyw38/datafile/xnbdata_zz.323.929203551';

set newname for datafile 71 to '/orabak_data1/zjyw38/datafile/xnbidx_ly.331.929203411 ';

set newname for datafile 72 to '/orabak_data1/zjyw38/datafile/xnbdata_ly.311.929204255';

set newname for datafile 73 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.306.929204391';

set newname for datafile 74 to '/orabak_data1/zjyw38/datafile/xnbidx_nd.316.929204211 ';

set newname for datafile 75 to '/orabak_data1/zjyw38/datafile/xnbidx_np.301.929204417 ';

set newname for datafile 76 to '/orabak_data1/zjyw38/datafile/xnbdata_nd.291.929205009';

set newname for datafile 77 to '/orabak_data1/zjyw38/datafile/xnbidx_zz.341.929202679 ';

set newname for datafile 78 to '/orabak_data1/zjyw38/datafile/dsdfdata.296.929204951';

set newname for datafile 79 to '/orabak_data1/zjyw38/datafile/xnbidx_fz.324.929203551 ';

set newname for datafile 80 to '/orabak_data1/zjyw38/datafile/xnbdata_np.337.929203365';

set newname for datafile 81 to '/orabak_data1/zjyw38/datafile/dsdfdata.332.929203409';

set newname for datafile 82 to '/orabak_data1/zjyw38/datafile/xnbidx_nd.342.929202677 ';

set newname for datafile 83 to '/orabak_data1/zjyw38/datafile/cussrvdata.317.929204211';

set newname for datafile 84 to '/orabak_data1/zjyw38/datafile/cussrvdata.356.929202551';

set newname for datafile 85 to '/orabak_data1/zjyw38/datafile/xnbidx_ly.351.929202565 ';

set newname for datafile 86 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.343.929202677 ';

set newname for datafile 87 to '/orabak_data1/zjyw38/datafile/undotbs1.380.929201699';

set newname for datafile 88 to '/orabak_data1/zjyw38/datafile/undotbs2.375.929201725';

set newname for datafile 89 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.344.929202675';

set newname for datafile 90 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.357.929202549';

set newname for datafile 91 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.352.929202565';

set newname for datafile 92 to '/orabak_data1/zjyw38/datafile/xnbidx_nd.365.929201799 ';

set newname for datafile 93 to '/orabak_data1/zjyw38/datafile/xnbidx_zz.361.929201805 ';

set newname for datafile 94 to '/orabak_data1/zjyw38/datafile/trade_appprofiles_data.376.929201707';

set newname for datafile 95 to '/orabak_data1/zjyw38/datafile/trade_appprofiles_data.371.929201731';

set newname for datafile 96 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.366.929201797';

set newname for datafile 97 to '/orabak_data1/zjyw38/datafile/dsdfdata.362.929201805';

set newname for datafile 98 to '/orabak_data1/zjyw38/datafile/xnbidx_qz.377.929201707 ';

set newname for datafile 99 to '/orabak_data1/zjyw38/datafile/xnbdata_qz.372.929201731';

set newname for datafile 100 to '/orabak_data1/zjyw38/datafile/dsdfdata.382.929200959';

set newname for datafile 101 to '/orabak_data1/zjyw38/datafile/xnbdata_nd.443.929198691';

set newname for datafile 102 to '/orabak_data1/zjyw38/datafile/sign_data.381.929200961 ';

set newname for datafile 103 to '/orabak_data1/zjyw38/datafile/stable_data.441.929198693 ';

set newname for datafile 104 to '/orabak_data1/zjyw38/datafile/event_data.310.929204385';

set newname for datafile 105 to '/orabak_data1/zjyw38/datafile/idx_sign_data.433.929199089 ';

set newname for datafile 106 to '/orabak_data1/zjyw38/datafile/idx_stable_data.459.929198097 ';

set newname for datafile 107 to '/orabak_data1/zjyw38/datafile/idx_event_data.465.929198411';

set newname for datafile 108 to '/orabak_data1/zjyw38/datafile/afadata.436.929199083 ';

set newname for datafile 109 to '/orabak_data1/zjyw38/datafile/afadata.387.929200949 ';

set newname for datafile 110 to '/orabak_data1/zjyw38/datafile/afadata.386.929200951 ';

set newname for datafile 111 to '/orabak_data1/zjyw38/datafile/afadata.414.929200069 ';

set newname for datafile 112 to '/orabak_data1/zjyw38/datafile/afadata.410.929200077 ';

set newname for datafile 113 to '/orabak_data1/zjyw38/datafile/dsdfdata.406.929200081';

set newname for datafile 114 to '/orabak_data1/zjyw38/datafile/afadata.401.929200301 ';

set newname for datafile 115 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.435.929199087';

set newname for datafile 116 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.451.929198093';

set newname for datafile 117 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.448.929198087';

set newname for datafile 118 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.449.929198089';

set newname for datafile 119 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.456.929198095';

set newname for datafile 120 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.422.929199563';

set newname for datafile 121 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.432.929199091';

set newname for datafile 122 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.428.929199095';

set newname for datafile 123 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.421.929199563';

set newname for datafile 124 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.431.929199093';

set newname for datafile 125 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.427.929199095';

set newname for datafile 126 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.257.929198411';

set newname for datafile 127 to '/orabak_data1/zjyw38/datafile/afadata.370.929201789 ';

set newname for datafile 128 to '/orabak_data1/zjyw38/datafile/sign_data.460.929198097 ';

set newname for datafile 129 to '/orabak_data1/zjyw38/datafile/sign_data.457.929198093 ';

set newname for datafile 130 to '/orabak_data1/zjyw38/datafile/sign_data.453.929198095 ';

set newname for datafile 131 to '/orabak_data1/zjyw38/datafile/sign_data.455.929198095 ';

set newname for datafile 132 to '/orabak_data1/zjyw38/datafile/idx_sign_data.461.929198099 ';

set newname for datafile 133 to '/orabak_data1/zjyw38/datafile/event_data.314.929204249';

set newname for datafile 134 to '/orabak_data1/zjyw38/datafile/sign_data.309.929204387 ';

set newname for datafile 135 to '/orabak_data1/zjyw38/datafile/stable_data.304.929204411 ';

set newname for datafile 136 to '/orabak_data1/zjyw38/datafile/idx_event_data.442.929198693';

set newname for datafile 137 to '/orabak_data1/zjyw38/datafile/idx_sign_data.396.929200937 ';

set newname for datafile 138 to '/orabak_data1/zjyw38/datafile/idx_stable_data.423.929199563 ';

set newname for datafile 139 to '/orabak_data1/zjyw38/datafile/afadata.347.929202669 ';

set newname for datafile 140 to '/orabak_data1/zjyw38/datafile/afadata.369.929201793 ';

set newname for datafile 141 to '/orabak_data1/zjyw38/datafile/afadata.367.929201795 ';

set newname for datafile 142 to '/orabak_data1/zjyw38/datafile/event_data.360.929202543';

set newname for datafile 143 to '/orabak_data1/zjyw38/datafile/event_data.355.929202557';

set newname for datafile 144 to '/orabak_data1/zjyw38/datafile/idx_event_data.359.929202547';

set newname for datafile 145 to '/orabak_data1/zjyw38/datafile/idx_event_data.354.929202561';

set newname for datafile 146 to '/orabak_data1/zjyw38/datafile/idx_event_data.379.929201703';

set newname for datafile 147 to '/orabak_data1/zjyw38/datafile/event_data.374.929201727';

set newname for datafile 148 to '/orabak_data1/zjyw38/datafile/afadata.294.929205005 ';

set newname for datafile 149 to '/orabak_data1/zjyw38/datafile/afadata.299.929204947 ';

set newname for datafile 150 to '/orabak_data1/zjyw38/datafile/afadata.393.929200941 ';

set newname for datafile 151 to '/orabak_data1/zjyw38/datafile/afadata.330.929203537 ';

set newname for datafile 152 to '/orabak_data1/zjyw38/datafile/event_data.392.929200943';

set newname for datafile 153 to '/orabak_data1/zjyw38/datafile/event_data.348.929202669';

set newname for datafile 154 to '/orabak_data1/zjyw38/datafile/event_data.364.929201801';

set newname for datafile 155 to '/orabak_data1/zjyw38/datafile/event_data.340.929203359';

set newname for datafile 156 to '/orabak_data1/zjyw38/datafile/event_data.335.929203403';

set newname for datafile 157 to '/orabak_data1/zjyw38/datafile/idx_event_data.320.929204203';

set newname for datafile 158 to '/orabak_data1/zjyw38/datafile/event_data.400.929200929';

set newname for datafile 159 to '/orabak_data1/zjyw38/datafile/dsdfdata.329.929203539';

set newname for datafile 160 to '/orabak_data1/zjyw38/datafile/afadata.418.929200063 ';

set newname for datafile 161 to '/orabak_data1/zjyw38/datafile/event_data.415.929200069';

set newname for datafile 162 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.434.929199089';

set newname for datafile 163 to '/orabak_data1/zjyw38/datafile/idx_event_data.429.929199095';

set newname for datafile 164 to '/orabak_data1/zjyw38/datafile/afadata.399.929200933 ';

set newname for datafile 165 to '/orabak_data1/zjyw38/datafile/event_data.327.929203547';

set newname for datafile 166 to '/orabak_data1/zjyw38/datafile/event_data.420.929200059';

set newname for datafile 167 to '/orabak_data1/zjyw38/datafile/idx_event_data.305.929204409';

set newname for datafile 168 to '/orabak_data1/zjyw38/datafile/afadata.419.929200063 ';

set newname for datafile 169 to '/orabak_data1/zjyw38/datafile/event_data.295.929205003';

set newname for datafile 170 to '/orabak_data1/zjyw38/datafile/dsdfdata.300.929204945';

set newname for datafile 171 to '/orabak_data1/zjyw38/datafile/idx_event_data.409.929200077';

set newname for datafile 172 to '/orabak_data1/zjyw38/datafile/event_data.404.929200297';

set newname for datafile 173 to '/orabak_data1/zjyw38/datafile/event_data.452.929198685';

set newname for datafile 174 to '/orabak_data1/zjyw38/datafile/afadata.440.929199071 ';

set newname for datafile 175 to '/orabak_data1/zjyw38/datafile/idx_event_data.385.929200953';

set newname for datafile 176 to '/orabak_data1/zjyw38/datafile/dsdfdata.395.929200937';

set newname for datafile 177 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.394.929200937';

set newname for datafile 178 to '/orabak_data1/zjyw38/datafile/event_data.447.929198067';

set newname for datafile 179 to '/orabak_data1/zjyw38/datafile/dsdfdata.462.929198403';

set newname for datafile 180 to '/orabak_data1/zjyw38/datafile/afadata.413.929200069 ';

set newname for datafile 181 to '/orabak_data1/zjyw38/datafile/idx_sign_data.450.929198091 ';

set newname for datafile 182 to '/orabak_data1/zjyw38/datafile/event_data.425.929199555';

set newname for datafile 183 to '/orabak_data1/zjyw38/datafile/idx_event_data.284.929205131';

set newname for datafile 184 to '/orabak_data1/zjyw38/datafile/dsdfdata.466.929198065';

set newname for datafile 185 to '/orabak_data1/zjyw38/datafile/event_data.446.929198067';

set newname for datafile 186 to '/orabak_data1/zjyw38/datafile/dsdf_idx_tbs.289.929205045';

set newname for datafile 187 to '/orabak_data1/zjyw38/datafile/idx_event_data.405.929200295';

set newname for datafile 188 to '/orabak_data1/zjyw38/datafile/idx_event_data.467.930089741';

set newname for tempfile 1 to '/orabak_data1/zjyw38/datafile/temp.272.929232755';

set newname for tempfile 2 to '/orabak_data1/zjyw38/datafile/afatmp.271.929232757';

set newname for tempfile 3 to '/orabak_data1/zjyw38/datafile/lctmp.270.929232759';

set newname for tempfile 4 to '/orabak_data1/zjyw38/datafile/dsdftmp.267.929232765';

set newname for tempfile 5 to '/orabak_data1/zjyw38/datafile/dsdftmp.268.929232763';

set newname for tempfile 6 to '/orabak_data1/zjyw38/datafile/dsdftmp.269.929232763';

set newname for tempfile 7 to '/orabak_data1/zjyw38/datafile/signtmp.266.929232767';

set newname for tempfile 8 to '/orabak_data1/zjyw38/datafile/stabletmp.265.929232767';

set newname for tempfile 9 to '/orabak_data1/zjyw38/datafile/eventtmp.262.929232769';

set newname for tempfile 10 to '/orabak_data1/zjyw38/datafile/idx_signtmp.261.929232769';

set newname for tempfile 11 to '/orabak_data1/zjyw38/datafile/idx_stabletmp.260.929232771';

set newname for tempfile 12 to '/orabak_data1/zjyw38/datafile/idx_eventtmp.259.929232771';

set newname for tempfile 13 to '/orabak_data1/zjyw38/datafile/eventtmp.263.929232769';

set newname for tempfile 14 to '/orabak_data1/zjyw38/datafile/eventtmp.264.929232767';

restore database;

switch datafile all;

switch tempfile all;

release channel ch1;

release channel ch2;

release channel ch3;

release channel ch4;

release channel ch5;

release channel ch6;

release channel ch7;

release channel ch8;

}

4．recover database，．并数据库起到open，

run{

allocate channel ch1 type 'SBT_TAPE';

allocate channel ch2 type 'SBT_TAPE';

send 'NB_ORA_SERV=nbuserver,NB_ORA_CLIENT=kaafa0db003r_nbu';

set archivelog destination to '/orabak_data1/zjyw38/arch';

restore archivelog from sequence 485 thread 1;

restore archivelog from sequence 430 thread 2;

set until sequence 430 thread 2;

recover database;

release channel ch1;

release channel ch2;

}

recover database;

alter database open resetlogs;

查询thread= 2，sequence =430的恢复时间

>select a.first_time,a.next_time from gv$archived_log a where a.sequence#='430' and a.thread#='2';

1 2017/3/5 11:51:13 | 2017/3/6 6:45:32

2 2017/3/5 11:51:13 | 2017/3/6 6:45:32

即恢复的时间点是2017-03-06 6:45:32

5.修改相应undo、 redo thread

转载请注明原文地址: https://ju.6miu.com/read-10459.html

技术

最新回复(0)