oracle异机恢复.docx

oracle异机恢复.docx

《oracle异机恢复.docx》由会员分享，可在线阅读，更多相关《oracle异机恢复.docx（13页珍藏版）》请在冰豆网上搜索。

oracle异机恢复

数据库备份恢复

使用brtools备份

su–oraeq1

brtools

选择4

选择1

选择6，选择offline

再选择c

选择6，输入2，使2个数据文件平行开始备份

选择c开始备份即可。

备份完成之后，拷贝备份文件到yteq1，拷贝/oracle/EP1/sapbackup下对应备份的控制文件到yteq1的/oracle/EP1/sapbackup

先修改参数/oracle/EQ1/102_64/dbs/initEQ1.sap

恢复使用命令

brrestore–bbepfxddg.afd–mfull

到源系统生成控制文件脚本

找到/oracle/EP1/saptrace/usertrace下对应trace文件，打开文件并拷贝下面部分：

STARTUPNOMOUNT

CREATECONTROLFILESETDATABASE"EQ1"NORESETLOGSARCHIVELOG

MAXLOGFILES255

MAXLOGMEMBERS3

MAXDATAFILES254

MAXINSTANCES50

MAXLOGHISTORY46720

LOGFILE

GROUP1'/oracle/EQ1/origlogA/log_g1.dbf'SIZE300M,

GROUP2'/oracle/EQ1/origlogB/log_g2.dbf'SIZE300M,

GROUP3'/oracle/EQ1/origlogA/log_g3.dbf'SIZE300M,

GROUP4'/oracle/EQ1/origlogB/log_g4.dbf'SIZE300M,

GROUP5'/oracle/EQ1/origlogA/log_g5.dbf'SIZE300M,

GROUP6'/oracle/EQ1/origlogB/log_g6.dbf'SIZE300M

--STANDBYLOGFILE

DATAFILE

'/oracle/EQ1/sapdata1/system_1/system.data1',

'/oracle/EQ1/sapdata3/undo_1/undo.data1',

'/oracle/EQ1/sapdata1/sysaux_1/sysaux.data1',

'/oracle/EQ1/sapdata1/sr3_1/sr3.data1',

'/oracle/EQ1/sapdata1/sr3_2/sr3.data2',

'/oracle/EQ1/sapdata1/sr3_3/sr3.data3',

'/oracle/EQ1/sapdata1/sr3_4/sr3.data4',

'/oracle/EQ1/sapdata1/sr3_5/sr3.data5',

'/oracle/EQ1/sapdata2/sr3_6/sr3.data6',

'/oracle/EQ1/sapdata2/sr3_7/sr3.data7',

'/oracle/EQ1/sapdata2/sr3_8/sr3.data8',

'/oracle/EQ1/sapdata2/sr3_9/sr3.data9',

'/oracle/EQ1/sapdata2/sr3_10/sr3.data10',

'/oracle/EQ1/sapdata3/sr3_11/sr3.data11',

'/oracle/EQ1/sapdata3/sr3_12/sr3.data12',

'/oracle/EQ1/sapdata3/sr3_13/sr3.data13',

'/oracle/EQ1/sapdata3/sr3_14/sr3.data14',

'/oracle/EQ1/sapdata3/sr3_15/sr3.data15',

'/oracle/EQ1/sapdata4/sr3_16/sr3.data16',

'/oracle/EQ1/sapdata4/sr3_17/sr3.data17',

'/oracle/EQ1/sapdata4/sr3_18/sr3.data18',

'/oracle/EQ1/sapdata4/sr3_19/sr3.data19',

'/oracle/EQ1/sapdata4/sr3_20/sr3.data20',

'/oracle/EQ1/sapdata1/sr3700_1/sr3700.data1',

'/oracle/EQ1/sapdata1/sr3700_2/sr3700.data2',

'/oracle/EQ1/sapdata1/sr3700_3/sr3700.data3',

'/oracle/EQ1/sapdata1/sr3700_4/sr3700.data4',

'/oracle/EQ1/sapdata2/sr3700_5/sr3700.data5',

'/oracle/EQ1/sapdata2/sr3700_6/sr3700.data6',

'/oracle/EQ1/sapdata2/sr3700_7/sr3700.data7',

'/oracle/EQ1/sapdata2/sr3700_8/sr3700.data8',

'/oracle/EQ1/sapdata3/sr3700_9/sr3700.data9',

'/oracle/EQ1/sapdata3/sr3700_10/sr3700.data10',

'/oracle/EQ1/sapdata3/sr3700_11/sr3700.data11',

'/oracle/EQ1/sapdata3/sr3700_12/sr3700.data12',

'/oracle/EQ1/sapdata4/sr3700_13/sr3700.data13',

'/oracle/EQ1/sapdata4/sr3700_14/sr3700.data14',

'/oracle/EQ1/sapdata4/sr3700_15/sr3700.data15',

'/oracle/EQ1/sapdata4/sr3700_16/sr3700.data16',

'/oracle/EQ1/sapdata1/sr3usr_1/sr3usr.data1',

'/oracle/EQ1/sapdata4/sr3_21/sr3.data21',

'/oracle/EQ1/sapcbdate/scb.data1',

'/oracle/EQ1/sapdata4/sr3_22/sr3.data22',

'/oracle/EQ1/sapdata1/sr3_23/sr3.data23',

'/oracle/EQ1/sapdata1/sr3_24/sr3.data24',

'/oracle/EQ1/sapdata2/sr3_25/sr3.data25',

'/oracle/EQ1/sapdata1/sr3usr_1/sr3usr.data2',

'/oracle/EQ1/sapdata1/sr3usr_1/sr3usr.data3',

'/oracle/EQ1/sapdata2/sr3_26/sr3.data26',

'/oracle/EQ1/sapdata2/sr3_27/sr3.data27',

'/oracle/EQ1/sapdata2/sr3_28/sr3.data28',

'/oracle/EQ1/sapdata2/sr3_29/sr3.data29',

'/oracle/EQ1/sapdata2/sr3_30/sr3.data30',

'/oracle/EQ1/sapdata2/sr3_31/sr3.data31',

'/oracle/EQ1/sapdata2/sr3_32/sr3.data32',

'/oracle/EQ1/sapdata2/sr3_33/sr3.data33',

'/oracle/EQ1/sapdata2/sr3_34/sr3.data34',

'/oracle/EQ1/sapdata2/sr3_35/sr3.data35',

'/oracle/EQ1/sapdata2/sr3_36/sr3.data36',

'/oracle/EQ1/sapdata3/sr3_37/sr3.data37',

'/oracle/EQ1/sapdata3/sr3_38/sr3.data38',

'/oracle/EQ1/sapdata4/sr3_39/sr3.data39',

'/oracle/EQ1/sapdata4/sr3_40/sr3.data40',

'/oracle/EQ1/sapdata4/sr3_41/sr3.data41',

'/oracle/EQ1/sapdata3/sr3_42/sr3.data42',

'/oracle/EQ1/sapdata1/sr3_43/sr3.data43',

'/oracle/EQ1/sapdata1/sr3_44/sr3.data44',

'/oracle/EQ1/sapdata3/sr3_45/sr3.data45',

'/oracle/EQ1/sapdata1/sr3_46/sr3.data46',

'/oracle/EQ1/sapdata1/sr3_47/sr3.data47',

'/oracle/EQ1/sapdata2/sr3_48/sr3.data48',

'/oracle/EQ1/sapdata2/sr3_49/sr3.data49',

'/oracle/EQ1/sapdata4/sr3_50/sr3.data50',

'/oracle/EQ1/sapdata4/sr3_51/sr3.data51',

'/oracle/EQ1/sapdata3/sr3_52/sr3.data52',

'/oracle/EQ1/sapdata3/sr3_53/sr3.data53',

'/oracle/EQ1/sapdata1/sr3_55/sr3.data55',

'/oracle/EQ1/sapdata1/sr3_56/sr3.data56',

'/oracle/EQ1/sapdata3/sr3_57/sr3.data57',

'/oracle/EQ1/sapdata3/sr3_58/sr3.data58',

'/oracle/EQ1/sapdata4/sr3_59/sr3.data59',

'/oracle/EQ1/sapdata4/sr3_60/sr3.data60',

'/oracle/EQ1/sapdata4/sr3_61/sr3.data61',

'/oracle/EQ1/sapdata4/sr3_62/sr3.data62',

'/oracle/EQ1/sapdata3/sr3_63/sr3.data63',

'/oracle/EQ1/sapdata1/sr3_64/sr3.data64',

'/oracle/EQ1/sapdata1/sr3_65/sr3.data65',

'/oracle/EQ1/sapdata1/sr3_66/sr3.data66',

'/oracle/EQ1/sapdata1/sr3_67/sr3.data67',

'/oracle/EQ1/sapdata1/sr3_68/sr3.data68',

'/oracle/EQ1/sapdata1/sr3_69/sr3.data69',

'/oracle/EQ1/sapdata3/sr3_70/sr3.data70',

'/oracle/EQ1/sapdata3/sr3_71/sr3.data71',

'/oracle/EQ1/sapdata3/sr3_72/sr3.data72',

'/oracle/EQ1/sapdata3/sr3_73/sr3.data73',

'/oracle/EQ1/sapdata3/sr3_74/sr3.data74',

'/oracle/EQ1/sapdata3/sr3_75/sr3.data75',

'/oracle/EQ1/sapdata3/sr3_76/sr3.data76',

'/oracle/EQ1/sapdata3/sr3_77/sr3.data77',

'/oracle/EQ1/sapdata4/sr3_78/sr3.data78',

'/oracle/EQ1/sapdata4/sr3_79/sr3.data79',

'/oracle/EQ1/sapdata4/sr3_80/sr3.data80',

'/oracle/EQ1/sapdata4/sr3_81/sr3.data81',

'/oracle/EQ1/sapdata4/sr3_82/sr3.data82',

'/oracle/EQ1/sapdata4/sr3_83/sr3.data83',

'/oracle/EQ1/sapdata4/sr3_84/sr3.data84',

'/oracle/EQ1/sapdata4/sr3_85/sr3.data85',

'/oracle/EQ1/sapdata1/sr3_86/sr3.data86',

'/oracle/EQ1/sapdata1/sr3_87/sr3.data87',

'/oracle/EQ1/sapdata1/sr3_88/sr3.data88',

'/oracle/EQ1/sapdata1/sr3_89/sr3.data89',

'/oracle/EQ1/sapdata2/sr3_90/sr3.data90',

'/oracle/EQ1/sapdata2/sr3_91/sr3.data91',

'/oracle/EQ1/sapdata2/sr3_92/sr3.data92',

'/oracle/EQ1/sapdata2/sr3_93/sr3.data93',

'/oracle/EQ1/sapdata2/sr3_94/sr3.data94',

'/oracle/EQ1/sapdata2/sr3_95/sr3.data95',

'/oracle/EQ1/sapdata2/sr3_96/sr3.data96',

'/oracle/EQ1/sapdata2/sr3_97/sr3.data97',

'/oracle/EQ1/sapdata1/sr3_98/sr3.data98',

'/oracle/EQ1/sapdata1/sr3_99/sr3.data99',

'/oracle/EQ1/sapdata1/sr3_100/sr3.data100',

'/oracle/EQ1/sapdata1/sr3_101/sr3.data101',

'/oracle/EQ1/sapdata1/sr3usr_2/sr3usr.data4',

'/oracle/EQ1/sapdata3/sr3_102/sr3.data102',

'/oracle/EQ1/sapdata3/sr3_103/sr3.data103',

'/oracle/EQ1/sapdata3/sr3_104/sr3.data104',

'/oracle/EQ1/sapdata3/sr3_105/sr3.data105',

'/oracle/EQ1/sapdata3/sr3_106/sr3.data106',

'/oracle/EQ1/sapdata4/sr3_107/sr3.data107',

'/oracle/EQ1/sapdata4/sr3_108/sr3.data108',

'/oracle/EQ1/sapdata4/sr3_109/sr3.data109',

'/oracle/EQ1/sapdata4/sr3_110/sr3.data110',

'/oracle/EQ1/sapdata4/sr3_111/sr3.data111',

'/oracle/EQ1/sapdata1/sr3_112/sr3.data112',

'/oracle/EQ1/sapdata2/sr3_113/sr3.data113',

'/oracle/EQ1/sapdata1/sr3_114/sr3.data114',

'/oracle/EQ1/sapdata2/sr3_115/sr3.data115',

'/oracle/EQ1/sapdata3/sr3_116/sr3.data116',

'/oracle/EQ1/sapdata4/sr3_117/sr3.data117',

'/oracle/EQ1/sapdata4/sr3_118/sr3.data118',

'/oracle/EQ1/sapdata3/sr3_119/sr3.data119',

'/oracle/EQ1/sapdata2/sr3_120/sr3.data120',

'/oracle/EQ1/sapdata1/sr3_121/sr3.data121',

'/oracle/EQ1/sapdata1/sr3_122/sr3.data122',

'/oracle/EQ1/sapdata2/sr3_123/sr3.data123',

'/oracle/EQ1/sapdata3/sr3_124/sr3.data124',

'/oracle/EQ1/sapdata4/sr3_125/sr3.data125',

'/oracle/EQ1/sapdata2/sr3usr_3/sr3usr.data5'

CHARACTERSETUTF8

;

修改SID=EQ1

到目标系统/oracle/EQ1/102_64下，创建文件ctrl.sql，拷贝如上内容到文件

恢复完成之后

启动数据库到nomount状态

重建控制文件

使用如下命令创建控制文件：

@?

/ctrl.sql

使用命令alterdatabaseopenresetlogs;打开数据库

添加用户和SAPUSER密码表

#删除原主机名的SAPUSER表

SELECTOWNERFROMDBA_TABLESWHERETABLE_NAME='SAPUSER';

查找owner信息

droptable"OPS$EP1ADM"."SAPUSER"

createuser"OPS$EQ1ADM"defaulttablespacePSAPSR3USRtemporarytablespacepsaptempidentifiedexternally;

grantconnect,resourceto"OPS$EQ1ADM";

CREATETABLE"OPS$EQ1ADM".SAPUSER（USERIDVARCHAR2（256）,PASSWDVARCHAR2（256））;INSERTINTO"OPS$EQ1ADM".SAPUSERVALUES（'SAPSR3','sap'）;

SELECTOWNER,TABLE_OWNER,TABLE_NAMEFROMDBA_SYNONYMS

WHERESYNONYM_NAME='SAPUSER';

DROPSYNONYM"OPS$SAPSERVICEEP1".SAPUSER;

createuser"OPS$SAPSERVICEEQ1"defaulttablespacePSAPSR3USRtemporarytablespacepsaptempidentifiedexternally;

grantconnect,resourceto"OPS$SAPSERVICEEQ1";

grantselect,updateon"OPS$EQ1ADM".SAPUSERto"OPS$SAPSERVICEEQ1";

重启数据库生效