技术系应急手册

10.88.249.510.88.249.610.88.249.6nbunbu上的备份（masterserver上执行bplist-Cwjglzpp-t4-R-lrmanstartupallocatechannelch1type'sbt_trestorespfileto'd:\test\spfiletest.ora'from'/bk_u73p43m3v_s227_p1_t843176063';releasechannelch1;}pfile并修改（wjglapptest主机性能调整内存参数，调整文件路径allocatechannelt1type'sbt_t';send'NB_ORA_CLIENT=wjglapp';send'NB_ORA_SERV=nbu-backup';restorecontrolfileto'd:\test\control01.ctl'from'/ctl-s230-1802858730-p1';releasechannelt1;}pfilestartupnomountmountRMAN>reportrunallocatechannel'dev_0'type'sbt_tSEND'NB_ORA_SERV=nbu-backup,NB_ORA_CLIENT=wjglapp';allocatechannel'dev_1'type'sbt_t';SEND'NB_ORA_SERV=nbu-backup,NB_ORA_CLIENT=wjglapp';setnewnamefordatafile1to'd:\test\SYSTEM01.DBF';setnewnamefordatafile2to

setnewnamefordatafile3to'd:\test\SYSAUX01.DBF';setnewnamefordatafile4to'd:\test\USERS01.DBF';setnewnamefordatafile5to'd:\test\GHMES.DBF';restoredatabase;switchdatafileall;releasechannel'dev_0';releasechannel}runallocatechannel'dev_0'type'sbt_t';send'NB_ORA_CLIENT=wjglapp';setarchivelogdestinationto'd:\test\admin\arc';restorearchivelogfromtime'sysdate-2';releasechannel'dev_0';}sqlplus/asrecoverdatabaseusingbackupcontrolfileuntilredoredoselect*fromalterdatabaserenamefile'R:\ORADATA\2LENGZHA\REDO01.LOG'to'D:\test\REDO01.LOG';alterdatabaserenamefile'R:\ORADATA\2LENGZHA\REDO02.LOG'to'D:\test\REDO02.LOG';alterdatabaserenamefile'R:\ORADATA\2LENGZHA\REDO03.LOG'to'D:\test\REDO03.LOG';alterdatabaseopencreatetemporarytablespacetest_tmptempfile'd:\test\test_tmp.dbf'size5g;alterdatabasedefaulttemporarytablespacetes