收藏
下载资源下载资源 加入VIP,免费下载

Brtools +Rman 恢复操作手册14p.docx

上传人：b****5 文档编号：6990951 上传时间：2023-01-15 格式：DOCX 页数：19 大小：20.79KB
下载 相关 举报
Brtools +Rman 恢复操作手册14p.docx_第1页
第1页 / 共19页
Brtools +Rman 恢复操作手册14p.docx_第2页
第2页 / 共19页
Brtools +Rman 恢复操作手册14p.docx_第3页
第3页 / 共19页
Brtools +Rman 恢复操作手册14p.docx_第4页
第4页 / 共19页
Brtools +Rman 恢复操作手册14p.docx_第5页
第5页 / 共19页
点击查看更多>>
下载资源
资源描述

Brtools +Rman 恢复操作手册14p.docx

《Brtools +Rman 恢复操作手册14p.docx》由会员分享，可在线阅读，更多相关《Brtools +Rman 恢复操作手册14p.docx（19页珍藏版）》请在冰豆网上搜索。

Brtools +Rman 恢复操作手册14p.docx

Brtools+Rman恢复操作手册14p

Brtools+Rman恢复操作手册

1、恢复场景

1.备份过程

（1）2008-8-26日对ECCGVSHE502数据库做了一次全备份，之后采用备份archive

（2）2008-8-27日对ECCGVSHE502数据库新增若干表空间。

（3）2008-8-27～28日对ECCGVSHE502数据库做reorg动作（mvtableandrebuildindex）

（4）2008-8-28日下午，对ECCGVSHE502数据库做增量备份

2.恢复要求

（1）从备份磁带库中恢复

（2）恢复到ECCGVSHE502数据库到2008-8-289：

00：

00

2、恢复过程

1.关闭GVSHE503数据库linstner和intance

GVSHE503:

orahe5>lsnrctlstop

GVSHE503:

orahe5>sqlplus‘/assysdba’

sql>shutdownimmediate;

2.恢复备份日志

GVSHE503:

orahe5>brrestore-dutil_file-b2"#NULL"-m/oracle/HE5/sapbackup/backHE5.log

3.寻找日志文件记录的需要的.fnr文件，并恢复此文件

GVSHE503:

orahe52>tail-f/oracle/HE5/sapbackup/backHE5.log

bdyrcqqq

rmp

2008-08-2609.49.04

2008-08-2609.49.05

3

...

0

0

0

0

0

0

0

.......

......

.........

...7.00

（28）

bdyrcqwf

dbv

2008-08-2609.51.29

2008-08-2609.51.30

3

...

0

0

0

0

0

0

0

.......

......

.........

...7.00

（28）

bdyrcqwy

dbv

2008-08-2609.51.48

2008-08-2609.51.49

3

...

0

0

0

0

0

0

0

.......

......

.........

...7.00

（28）

bdyrcrem

dbv

2008-08-2609.55.04

2008-08-2612.53.27

5

...

256

253

0

126012

4793762120

0

0

ALL

online

null

-dc7.00

（28）

bdyrdjgu

fnr

2008-08-2613.18.52

2008-08-2614.19.07

4

...

256

44

0

126012

4793762120

0

0

FULL

online

rman_util

-7

（28）

bdyrdoqy

pnr

2008-08-2614.19.36

2008-08-2614.19.55

4

...

256

1

0

126012

4793762120

0

0

PARTIAL

online

rman_util

-7

（28）

bdyrdovw

fnr

2008-08-2614.21.44

2008-08-2620.05.31

0

...

256

253

0

126012

4793762120

126013

4794016302

FULL

online

rman_util

-7

（28）

bdyrhzhr

pnr

2008-08-2711.51.15

2008-08-2712.05.03

0

...

256

1

0

126013

4794016302

126014

4794061942

PARTIAL

online

rman_util

-7

（28）

bdyrmkfo

inr

2008-08-2809.26.00

2008-08-2814.23.29

9

...

316

58

0

126022

4794453327

126023

4794500683

INCR

online

rman_util

-7

（28）

bdyseivu

fnf

2008-09-0101.03.18

2008-09-0101.03.19

3

...

0

0

0

0

0

0

0

.......

......

.........

...7.00

（28）

从backHE5.log里可以可以看出离2008-8-28日最近的全备份是2008-8-2614：

21：

44做的备份，恢复当时的备份信息文件bdyrdovw.fnr

GVSHE503:

orahe5>brrestore-dutil_file-b2"#NULL"-m/oracle/HE5/sapbackup/bdyrdovw.fnr

4.根据.fnr文件内容，恢复controlfile

GVSHE503:

orahe5>brrestore-b/oracle/HE5/sapbackup/bdyrdovw.fnr-m0

5.启动数据库到Mount状态

SQL>startupmount;

SQL>exit;

6.根据.fnr文件内容，恢复ECCgvshe5032008-08-2614：

21：

44全备份

GVSHE503:

orahe5>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'SBT_TAPE'

parms'BLKSIZE=65536ENV=（XINT_PROFILE=/oracle/HE5/102_64/dbs/initHE5.utl,PROLE_PORT=57323）';

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:

00

GVSHE503:

orahe521>brrestore-dutil_file-b2"#NULL"-m/oracle/HE5/saparch/archHE5.log

查看archHE5.log日志文件里从2008-08-26～2008-08-29的scn号，如：

126012～126015

GVSHE503:

orahe529>more/oracle/HE5/saparch/archHE5.log

#ARCHIVE..126012/oracle/HE5/oraarch/HE5arch1_126012_638579629.dbf2008-08-2620.05.10141392896................1

#SAVED....adysiasdcds*HE5___A0FKKZGTOH2008-09-0119.05.02.......................

#COPIED...adysiljdcds*HE5___A0FKL3R4O72008-09-0121.04.23.......................

#DELETED..adysiljdcds2008-09-0121.04.23

#

#ARCHIVE..126013/oracle/HE5/oraarch/HE5arch1_126013_638579629.dbf2008-08-2712.04.40120490496................1

#SAVED....adysiasdcds*HE5___A0FKKZGTOH2008-09-0119.04.23.......................

#COPIED...adysiljdcds*HE5___A0FKL3R4O72008-09-0121.04.59.......................

#DELETED..adysiljdcds2008-09-0121.04.59

#

#ARCHIVE..126014/oracle/HE5/oraarch/HE5arch1_126014_638579629.dbf2008-08-2714.20.317740928................1

#SAVED....adysiasdcds*HE5___A0FKKZGTOH2008-09-0119.04.25.......................

#COPIED...adysiljdcds*HE5___A0FKL3R4O72008-09-0121.04.25.......................

#DELETED..adysiljdcds2008-09-0121.04.25

#

#ARCHIVE..126015/oracle/HE5/oraarch/HE5arch1_126015_638579629.dbf2008-08-2714.33.55265728................1

#SAVED....adysiasdcds*HE5___A0FKKZGTOH2008-09-0119.04.27.......................

#COPIED...adysiljdcds*HE5___A0FKL3R4O72008-09-0121.04.27.......................

#DELETED..adysiljdcds2008-09-0121.04.27

#

#ARCHIVE..126016/oracle/HE5/oraarch/HE5arch1_126016_638579629.dbf2008-09-0113.46.211177088................1

#SAVED....adysiasdcds*HE5___A0FKKZGTOH2008-09-0119.04.29.......................

#COPIED...adysiljdcds*HE5___A0FKL3R4O72008-09-0121.04.29.......................

#DELETED..adysiljdcds2008-09-0121.04.29

#

#ARCHIVE..126017/oracle/HE5/oraarch/HE5arch1_126017_638579629.dbf2008-09-0118.40.397523174447940703601

#SAVED....adysiasdcds*HE5___A0FKKZGTOH2008-09-0119.04.33.......................

#COPIED...adysiljdcds*HE5___A0FKL3R4O72008-09-0121.04.32.......................

#DELETED..adysiljdcds2008-09-0121.04.32

检查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：

00以后备份的controlfiletrace重建controlfile

SQL>select*fromv$controlfile;

STATUSNAMEIS_BLOCK_SIZEFILE_SIZE_BLKS

-------------------------------------------------------------------------

/oracle/HE5/origlogA/cntrl/cntlrHE5.dbfNO16384942

/oracle/HE5/origlogB/cntrl/cntrlHE5.dbfNO16384942

注意：

记住controlfile路径及其文件名，在执行前如果以前有controlfile，请把以前的controlfile重名其他文件。

SQL>shutdownimmediate;

SQL>@create_ctr.sh

下面是样本脚本：

（注意：

resuse和NORESETLOGSARCHIVELOG两个参数）

GVSHE503:

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'

）SIZE300M,

GROUP23（

'/oracle/HE5/origlogA/log_g23m1.dbf',

'/oracle/HE5/mirrlogA/log_g23m2.dbf'

）SIZE300M,

GROUP24（

'/oracle/HE5/origlogB/log_g24m1.dbf',

'/oracle/HE5/mirrlogB/log_g24m2.dbf'

）SIZE300M,

GROUP25（

'/oracle/HE5/origlogA/log_g25m1.dbf',

'/oracle/HE5/mirrlogA/log_g25m2.dbf'

）SIZE300M,

GROUP26（

'/oracle/HE5/origlogB/log_g26m1.dbf',

'/oracle/HE5/mirrlogB/log_g26m2.dbf'

）SIZE300M,

GROUP27（

'/oracle/HE5/origlogA/log_g27m1.dbf',

'/oracle/HE5/mirrlogA/log_g27m2.dbf'

）SIZE300M,

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

展开阅读全文
相关资源
猜你喜欢
相关搜索

当前位置：首页 > 初中教育 > 语文

copyright@ 2008-2022 冰豆网网站版权所有

经营许可证编号:鄂ICP备2022015515号-1