BrtoolsRman 恢复操作手册Word格式.docx
- 文档编号:20488084
- 上传时间:2023-01-23
- 格式:DOCX
- 页数:16
- 大小:30.55KB
BrtoolsRman 恢复操作手册Word格式.docx
《BrtoolsRman 恢复操作手册Word格式.docx》由会员分享,可在线阅读,更多相关《BrtoolsRman 恢复操作手册Word格式.docx(16页珍藏版)》请在冰豆网上搜索。
-m/oracle/HE5/sapbackup/backHE5.log
3.寻找日志文件记录的需要的.fnr文件,并恢复此文件
orahe52>
tail-f/oracle/HE5/sapbackup/backHE5.log
从backHE5.log里可以可以看出离2008-8-28日最近的全备份是2008-8-2614:
21:
44做的备份,恢复当时的备份信息文件bdyrdovw.fnr
-m/oracle/HE5/sapbackup/bdyrdovw.fnr
4.根据.fnr文件内容,恢复controlfile
brrestore-b/oracle/HE5/sapbackup/bdyrdovw.fnr-m0
5.启动数据库到Mount状态
SQL>
startupmount;
exit;
6.根据.fnr文件内容,恢复ECCgvshe5032008-08-2614:
44全备份
brrestore-bbdyrdovw.fnr-mall
其实brtools会调用rman生成脚本:
run{allocatechannelsbt_1devicetype'
SBT_TAPE'
parms'
BLKSIZE=65536ENV=(XINT_PROFILE=/oracle/HE5/102_64/dbs/initHE5.utl,PROLE_PORT=57323)'
;
allocatechannelsbt_2devicetype'
restoredatafile230,231,233,232,238,239,229,240,241,242,243,244,234,235,236,237,245,246,247,248,
249,250,251,252,253,67,88,121,141,159,226,25,40,101,116,72,95,146,34,35,
49,102,117,73,119,128,131,147,51,103,118,74,120,129,132,36,52,104,75,130,
133,148,160,37,53,105,76,134,149,162,227,38,54,55,106,77,135,228,150,39,
165,175,78,184,195,205,4,14,176,79,166,185,196,206,5,15,177,80,186,167,
197,207,6,16,178,81,187,198,168,208,7,17,56,107,68,89,122,225,136,26,
41,82,179,189,199,209,169,8,18,83,180,190,200,210,9,170,19,84,188,191,
201,211,10,20,171,85,181,192,202,212,11,21,172,86,182,193,203,213,22,12,
173,174,163,183,194,204,214,13,23,57,109,69,90,123,142,152,27,42,58,110,
70,91,124,137,153,28,43,96,111,154,71,29,44,97,112,155,45,30,98,113,
92,138,125,156,143,31,46,99,114,93,126,139,144,157,32,47,100,115,94,127,
140,145,158,33,48,215,216,217,218,219,220,221,222,223,224,161,2,151,64,63,
1,60,61,62,50,65,59,87,66,3,108,24,164fromtagbdyrdovwforce;
releasechannelsbt_1;
releasechannelsbt_2;
}
7.恢复归档日志至2008-08-2809:
00:
orahe521>
brrestore-dutil_file-b2"
-m/oracle/HE5/saparch/archHE5.log
查看archHE5.log日志文件里从2008-08-26~2008-08-29的scn号,如:
126012~126015
orahe529>
more/oracle/HE5/saparch/archHE5.log
#
检查achivelog是否完全恢复,如果发现中间有一段scn的日志未恢复,如:
2136163-136168没找到。
则采用如下命令恢复:
brrestore-pinitHE5.sap–a2136163-136168-dutil_file-r/oracle/HE5/102_64/dbs/initHE5.utl-kno-lE-i30'
8.(此步是在两个数据库是不同的实例时需要,如备份库instance:
HE5,而要恢复的数据库instance:
H3,则需要此步骤,否则,跳过此步骤)参照2008-8-2809:
00以后备份的controlfiletrace重建controlfile
select*fromv$controlfile;
STATUSNAMEIS_BLOCK_SIZEFILE_SIZE_BLKS
-------------------------------------------------------------------------
/oracle/HE5/origlogA/cntrl/cntlrHE5.dbfNO16384942
/oracle/HE5/origlogB/cntrl/cntrlHE5.dbfNO16384942
注意:
记住controlfile路径及其文件名,在执行前如果以前有controlfile,请把以前的controlfile重名其他文件。
@create_ctr.sh
下面是样本脚本:
(注意:
resuse和NORESETLOGSARCHIVELOG两个参数)
orahe534>
morecreate_ctr.sh
STARTUPNOMOUNT
CREATECONTROLFILEREUSEDATABASE"
HE5"
NORESETLOGSARCHIVELOG
MAXLOGFILES255
MAXLOGMEMBERS3
MAXDATAFILES600
MAXINSTANCES50
MAXLOGHISTORY41104
LOGFILE
GROUP21(
'
/oracle/HE5/origlogA/log_g21m1.dbf'
/oracle/HE5/mirrlogA/log_g21m2.dbf'
)SIZE300M,
GROUP22(
/oracle/HE5/origlogB/log_g22m1.dbf'
/oracle/HE5/mirrlogB/log_g22m2.dbf'
GROUP23(
/oracle/HE5/origlogA/log_g23m1.dbf'
/oracle/HE5/mirrlogA/log_g23m2.dbf'
GROUP24(
/oracle/HE5/origlogB/log_g24m1.dbf'
/oracle/HE5/mirrlogB/log_g24m2.dbf'
GROUP25(
/oracle/HE5/origlogA/log_g25m1.dbf'
/oracle/HE5/mirrlogA/log_g25m2.dbf'
GROUP26(
/oracle/HE5/origlogB/log_g26m1.dbf'
/oracle/HE5/mirrlogB/log_g26m2.dbf'
GROUP27(
/oracle/HE5/origlogA/log_g27m1.dbf'
/oracle/HE5/mirrlogA/log_g27m2.dbf'
GROUP28(
/oracle/HE5/origlogB/log_g28m1.dbf'
/oracle/HE5/mirrlogB/log_g28m2.dbf'
)SIZE300M
--STANDBYLOGFILE
DATAFILE
/oracle/HE5/sapdata6/system_1/system.data1'
/oracle/HE5/sapdata6/undo_1/undo.data1'
/oracle/HE5/sapdata6/sysaux_1/sysaux.data1'
/oracle/HE5/sapdata16/sr3_51/sr3.data51'
/oracle/HE5/sapdata17/sr3_52/sr3.data52'
/oracle/HE5/sapdata18/sr3_53/sr3.data53'
/oracle/HE5/sapdata19/sr3_54/sr3.data54'
/oracle/HE5/sapdata20/sr3_55/sr3.data55'
/oracle/HE5/sapdata21/sr3_56/sr3.data56'
/oracle/HE5/sapdata22/sr3_57/sr3.data57'
/oracle/HE5/sapdata23/sr3_58/sr3.data58'
/oracle/HE5/sapdata24/sr3_59/sr3.data59'
/oracle/HE5/sapdata25/sr3_60/sr3.data60'
/oracle/HE5/sapdata16/sr3_61/sr3.data61'
/oracle/HE5/sapdata17/sr3_62/sr3.data62'
/oracle/HE5/sapdata18/sr3_63/sr3.data63'
/oracle/HE5/sapdata19/sr3_64/sr3.data64'
/oracle/HE5/sapdata20/sr3_65/sr3.data65'
/oracle/HE5/sapdata21/sr3_66/sr3.data66'
/oracle/HE5/sapdata22/sr3_67/sr3.data67'
/oracle/HE5/sapdata23/sr3_68/sr3.data68'
/oracle/HE5/sapdata24/sr3_69/sr3.data69'
'
/oracle/HE5/sapdata25/sr3_70/sr3.data70'
/oracle/HE5/sapdata5/sr3usr_2/sr3usr.data2'
/oracle/HE5/sapdata1/sr3_71/sr3.data71'
/oracle/HE5/sapdata2/sr3_72/sr3.data72'
/oracle/HE5/sapdata3/sr3_73/sr3.data73'
/oracle/HE5/sapdata4/sr3_74/sr3.data74'
/oracle/HE5/sapdata5/sr3_75/sr3.data75'
/oracle/HE5/sapdata6/sr3_76/sr3.data76'
/oracle/HE5/sapdata7/sr3_77/sr3.data77'
/oracle/HE5/sapdata8/sr3_78/sr3.data78'
/oracle/HE5/sapdata9/sr3_79/sr3.data79'
/oracle/HE5/sapdata10/sr3_80/sr3.data80'
/oracle/HE5/sapdata10/sr3_81/sr3.data81'
/oracle/HE5/sapdata12/sr3_82/sr3.data82'
/oracle/HE5/sapdata13/sr3_83/sr3.data83'
/oracle/HE5/sapdata14/sr3_84/sr3.data84'
/oracle/HE5/sapdata15/sr3_85/sr3.data85'
/oracle/HE5/sapdata1/sr3_86/sr3.data86'
/oracle/HE5/sapdata2/sr3_87/sr3.data87'
/oracle/HE5/sapdata3/sr3_88/sr3.data88'
/oracle/HE5/sapdata4/sr3_89/sr3.data89'
/oracle/HE5/sapdata5/sr3_90/sr3.data90'
/oracle/HE5/sapdata6/sr3_91/sr3.data91'
/oracle/HE5/sapdata7/sr3_92/sr3.data92'
/oracle/HE5/sapdata8/sr3_93/sr3.data93'
/oracle/HE5/sapdata9/sr3_94/sr3.data94'
/oracle/HE5/sapdata10/sr3_95/sr3.data95'
/oracle/HE5/sapdata11/sr3usr_3/sr3usr.data3'
/oracle/HE5/sapdata11/sr3_96/sr3.data96'
/oracle/HE5/sapdata12/sr3_97/sr3.data97'
/oracle/HE5/sapdata13/sr3_98/sr3.data98'
/oracle/HE5/sapdata14/sr3_99/sr3.data99'
/oracle/HE5/sapdata15/sr3_100/sr3.data100'
/oracle/HE5/sapdata2/sr3_101/sr3.data101'
/oracle/HE5/sapdata3/sr3_102/sr3.data102'
/oracle/HE5/sapdata4/sr3_103/sr3.data103'
/oracle/HE5/sapdata5/sr3usr_1/sr3usr.data1'
/oracle/HE5/sapdata5/sr3db_1/sr3db.data1'
/oracle/HE5/sapdata5/sr3db_2/sr3db.data2'
/oracle/HE5/sapdata5/sr3db_3/sr3db.data3'
/oracle/HE5/sapdata5/sr3db_4/sr3db.data4'
/oracle/HE5/sapdata3/sr3db_5/sr3db.data5'
/oracle/HE5/sapdata6/undo_2/undo.data2'
/oracle/HE5/sapdata7/sr700_1/sr700.data1'
/oracle/HE5/sapdata1/sr3_126/sr3.data126'
/oracle/HE5/sapdata2/sr3_127/sr3.data127'
/oracle/HE5/sapdata3/sr3_128/sr3.data128'
/oracle/HE5/sapdata4/sr3_129/sr3.data129'
/oracle/HE5/sapdata5/sr3_130/sr3.data130'
/oracle/HE5/sapdata10/sr3_131/sr3.data131'
/oracle/HE5/sapdata11/sr3_132/sr3.data132'
/oracle/HE5/sapdata12/sr3_133/sr3.data133'
/oracle/HE5/sapdata13/sr3_134/sr3.data134'
/oracle/HE5/sapdata14/sr3_135/sr3.data135'
/oracle/HE5/sapdata15/sr3_136/sr3.data136'
/oracle/HE5/sapdata16/sr3_137/sr3.data137'
/oracle/HE5/sapdata17/sr3_138/sr3.data138'
/oracle/HE5/sapdata18/sr3_139/sr3.data139'
/oracle/HE5/sapdata19/sr3_140/sr3.data140'
/oracle/HE5/sapdata20/sr3_141/sr3.data141'
/oracle/HE5/sapdata21/sr3_142/sr3.data142'
/oracle/HE5/sapdata22/sr3_143/sr3.data143'
/oracle/HE5/sapdata23/sr3_144/sr3.data144'
/oracle/HE5/sapdata24/sr3_145/sr3.data145'
/oracle/HE5/sapdata9/sr3usr_4/sr4usr.data4'
/oracle/HE5/sapdata1/sr3_146/sr3.data146'
/oracle/HE5/sapdata2/sr3_147/sr3.data147'
/oracle/HE5/sapdata3/sr3_148/sr3.data148'
/oracle/HE5/sapdata4/sr3_149/sr3.data149'
/oracle/HE5/sapdata7/sr3_150/sr3.data150'
/oracle/HE5/sapdata8/sr3_151/sr3.data151'
/oracle/HE5/sapdata9/sr3_152/sr3.data152'
/oracle/HE5/sapdata10/sr3_153/sr3.data153'
/oracle/HE5/sapdata5/sr3_104/sr3.data104'
/oracle/HE5/sapdata6/sr3_105/sr3.data105'
/oracle/HE5/sapdata7/sr3_106/sr3.data106'
/oracle/HE5/sapdata8/sr3_107/sr3.data107'
/oracle/HE5/sapdata9/sr3_108/sr3.data108'
/oracle/HE5/sapdata10/sr3_109/sr3.data109'
/oracle/HE5/sapdata11/sr3_110/sr3.data110'
/oracle/HE5/sapdata12/sr3_111/sr3.data111'
/oracle/HE5/sapdata13/sr3_112/sr3.data112'
/oracle/HE5/sapdata14/sr3_113/sr3.data113'
/oracle/HE5/sapdata15/sr3_114/sr3.data114'
/oracle/HE5/sapdata2/sr3_115/sr3.data115'
/oracle/HE5/sapdata1/perfstat.dbf'
/oracle/HE5/sapdata3/sr3_116/sr3.data116'
/oracle/HE5/sapdata4/sr3_117/sr3.data117'
/oracle/HE5/sapdata5/sr3_118/sr3.data118'
/orac
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- BrtoolsRman 恢复操作手册 恢复 操作手册