ixdba.net,讨论linux＋oracle技术

Rman全备恢复到另外服务器操作指南

上一篇 / 下一篇  2008-01-23 09:34:59 / 个人分类：oracle数据库

查看( 135 ) / 评论( 0 ) / 评分( 0 / 0 )

操作系统：Suse linux 9IXPUB技术博客d4NQV&wi7{2^#}

数据库：oracle10gR2IXPUB技术博客D/p1Zm r,e6T)JU(`

存在的备份：原来数据库的全备份和控制文件的备份，并且原来的rman备份中没有用恢复目录，但是控制文件是自动备份的。IXPUB技术博客Z] t%~_&`&gg9p2`

恢复如下：IXPUB技术博客z*y!L)p9Qr6C0_

1：首先在控制文件的备份中恢复spfile参数文件信息

oracle@linux:/free/oracle/oradata/orcl> rman target /

;X7h.d+m _b6K\ h\10979521

Recovery Manager: Release10.2.0.1.0 - Production on星期一11月20 10:12:12 2006

;tY3k)eqzx n10979521IXDBA.NET技术社区
Q$v&[%lV"I*A#J10979521

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RZ%NT1[\10979521

connected to target database (not started)IXPUB技术博客 r d9L4E;gK,[p

rman可以在没有任何数据库启动参数的情况下启动数据库到nomount状态，IXPUB技术博客'{!]so$P7u:sB"t

默认启动的数据库名字为DUMMY，

K0XrOv{10979521

利用这个特性在原来备份的控制文件中恢复spfile参数文件。IXPUB技术博客f-hADJR

 

%[!e sj+R$JUkn10979521

RMAN>SET DBID=1132959697

]S {+A+Al L'p10979521

executing command: SET DBIDIXPUB技术博客mbP?#Y{

RMAN>startup nomount

ip`m(p-FuX4WY10979521

startup failed: ORA-01078: failure in processing system parametersIXPUB技术博客k&u&T{*X G

LRM-00109:could not open parameter file '/free/oracle/product/10.2.0/db_1/dbs/initorcl.ora'

:c jZl9d|w)F10979521

starting Oracle instance without parameter file for retrival of spfile

:W%O&m]*D10979521

Oracle instance started

'jIwl ~ EFM-Q10979521

Total System Global Area    159383552 bytes

l;TOt9v1x10979521

Fixed Size                    1218268 bytes

[2hgQ*h k_10979521

Variable Size                54528292 bytesIXPUB技术博客 S,a*r*]|OP$\)R

Database Buffers            100663296 bytes

%^;t mrX2x6yykR NFO10979521

Redo Buffers                  2973696 bytes

D$i)G F+f~J+]10979521

可以看到rman启动了一个默认的实例IXPUB技术博客8`5@eS$r,a]~

RMAN> show all;

-y8C0i(X)Au10979521

using target database control file instead of recovery catalog

(p5TB_7[ { N10979521

RMAN configuration parameters are:

e\8Nd9w3z?10979521

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultIXPUB技术博客J/K3|/z$S

CONFIGURE BACKUP OPTIMIZATION OFF; # default

(Jx:sw m*y:u9Vf10979521

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultIXPUB技术博客?o)AY H(Dkf

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

!omU3^,D10979521

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultIXPUB技术博客M9tM8[u{.d6lc z I

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

y4`x+k rZ*C a$r$BY10979521

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

.n*HK*kVd!e)Ua10979521

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultIXPUB技术博客7p ~w5^ xcY w

CONFIGURE MAXSETSIZE TO UNLIMITED; # defaultIXPUB技术博客 IpX;Ig

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

,s p"_ fU K10979521

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultIXPUB技术博客+\j^U;\U"q

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

9}+W{_2@10979521

 IXPUB技术博客u Z}uF(I/g&zb5S

此时，rman的配置都在rman默认的状态。

Ua? p,Q] V10979521

 

(a5Z9zyg,ep10979521

RMAN>

9\+uS(o Z3Bu,W10979521

restore spfile from '/free/oracle/orabak/c-1132959697-20061119-00';

4O G@U3iel10979521

Starting restore at 20-11月-06IXPUB技术博客%ufAo3T[1aD/[9W0l

allocated channel: ORA_DISK_1IXPUB技术博客|*I$U:\l%w5U7?'}

channel ORA_DISK_1: sid=37 devtype=DISKIXPUB技术博客} lkgt2hi

channel RA_DISK_1: autobackup found: /free/oracle/orabak/c-1132959697-20061119-00

y:bz N't6X'h._10979521

channel ORA_DISK_1: SPFILE restore from autobackup completeIXPUB技术博客Sbi ~1ZH@

Finished restore at 20-11月-06IXPUB技术博客(B3K6h@!{ @yy

 IXPUB技术博客L$u|f1sZd v

可以指定restore spfile文件到一个指定的地方，如果没有指定，IXPUB技术博客5h J ww+bF6Zi?

默认恢复到$ORACLE_HOME/dbs下面。IXPUB技术博客g9|(xLsE PG

RMAN>

#i0I!a+U%m.t`C10979521

RMAN> shutdown immediateIXPUB技术博客]v }4F.u*KesN

using target database control file instead of recovery catalogIXPUB技术博客(H9p9h }b2^R'G

Oracle instance shut downIXPUB技术博客 Rs!ehF AU;O}

RMAN> quit

^Gv9[2DKt:^;?4|10979521

Recovery Manager complete.

SC \L-JEZ"H10979521

 

7H!m ] CB3R'o~!Q10979521

2：重新登陆rman进行控制文件的恢复

oracle@linux:~> rman target /

.\%A"B,s{10979521

Recovery Manager: Release10.2.0.1.0 - Production on星期一11月20 10:17:19 2006

~4V{(B kn K%Xi-ZZ10979521

Copyright (c) 1982, 2005, Oracle. All rights reserved.IXPUB技术博客$Vh3f v(vtO [

connected to target database (not started)

8Jx*M?C8l/F*Uz10979521

RMAN> startup nomount

j9K9~p].[7SU10979521

Oracle instance started

$_%v.T2p;D!i$q10979521

Total System Global Area    167772160 bytes

i1HH1t-l N10979521

Fixed Size                    1218316 bytesIXPUB技术博客"Y]E6Xn1Y(fn

Variable Size                71305460 bytesIXPUB技术博客1P {:Wa-C$pzoY

Database Buffers             92274688 bytes

Yf/Z:q-P.`10979521

Redo Buffers                  2973696 bytesIXPUB技术博客~w/pL5L

 

1f)F6V,y UW10979521

有了参数文件，恢复成功了第一步，

Qu5w U4dE:Z-}10979521

可以看到，上面的实例就是从恢复的参数文件中启动的。IXPUB技术博客/`f-@z$H5x e.N'Bp

 IXPUB技术博客W-m,A*Z,Pk'^r,eq

RMAN>IXPUB技术博客)`n QWk!XV

restore controlfile from '/free/oracle/orabak/c-1132959697-20061119-00';

u3xk9d;~~10979521

 

iHHBX c JO}10979521

Starting restore at 20-11月-06

TcO3n a:s.s6Xr.I10979521

using target database control file instead of recovery catalog

AJ:Znou%[q10979521

allocated channel: ORA_DISK_1

,\(C4~(`rn10979521

channel ORA_DISK_1: sid=156 devtype=DISK

5w:E;Sl@qC10979521

 IXPUB技术博客V^Z Kx0p7?"g

channel ORA_DISK_1: restoring control file

:f;X:ON(aD*CM1x10979521

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03IXPUB技术博客1B4HIUad u)Lp

output filename=/free/oracle/oradata/orcl/control01.ctl

8o"]s { STs7z10979521

output filename=/free/oracle/oradata/orcl/control02.ctl

sbD B'@10979521

output filename=/free/oracle/oradata/orcl/control03.ctlIXPUB技术博客$T.ru].dlJ2H:h;@

Finished restore at 20-11月-06

li$Ytq$f0z D%c10979521

 IXPUB技术博客.w\I'g2R6I

同spfile文件一样，可以恢复控制文件到一个指定的地方，IXPUB技术博客b:c1Ri3^2['}(G

如果不指定，默认恢复到$ORACLE_BASE/oradata下面。

Z3e1_#RH6b10979521

 

Zj ?"nG lx^ g10979521

RMAN> shutdown immediateIXPUB技术博客(fAx_(f

Oracle instance shut down

Bh wo A10979521

RMAN> quit

9o iugb"]7f10979521

Recovery Manager complete.IXPUB技术博客1TN0U:Ea/gt3|/`D

 IXPUB技术博客9_;F |Wf'B5z"X#L,CU

关闭数据库退出rman，然后启动数据库到mount状态。IXPUB技术博客2x Rj{ `Y

 

6Z3l+z:q)T'A10979521

3：恢复所有数据文件

 

0eg L3E"G p p%{q10979521

oracle@linux:~> rman target /

"^3yj)Lgu%ma^3J10979521

Recovery Manager: Release10.2.0.1.0 - Production on星期一11月20 10:18:26 2006IXPUB技术博客l,p4GuBp|

Copyright (c) 1982, 2005, Oracle. All rights reserved.IXPUB技术博客C&c#h6r!]A0to

connected to target database (not started)

OTjzq8@F9y_10979521

RMAN> startup mountIXPUB技术博客z;q([N _ @L2l

Oracle instance started

9G A"]$t vx}$Xo\oJ10979521

database mounted

$h%JM Xi10979521

Total System Global Area    167772160 bytes

r1f(I/kd0C10979521

Fixed Size                    1218316 bytes

.w^&gcYNa10979521

Variable Size                71305460 bytes

%zB'eAv#yn {^F%`10979521

Database Buffers             92274688 bytes

P`|H1}I*@10979521

Redo Buffers                  2973696 bytesIXPUB技术博客9] D:^ T jP:yU:s,E'G _r

 IXPUB技术博客+ej-K({+T-c|}"^9y

可以看到，控制文件恢复成功后，数据库可以启动到mount状态。

fT*gbC10979521

 

j]'x)E _/x;T1Q10979521

RMAN> show all;IXPUB技术博客5QK Gda xJ

RMAN configuration parameters are:

B?g0a@ @;J-}t10979521

CONFIGURE RETENTION POLICY TO REDUNDANCY 3;IXPUB技术博客Y7R3gb)eT!^z

CONFIGURE BACKUP OPTIMIZATION ON;

*^hJ2M@:k10979521

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

NP,xO8Z-Ss1LU10979521

CONFIGURE CONTROLFILE AUTOBACKUP ON;

ZJt([7g10979521

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/free/oracle/orabak/%F';IXPUB技术博客6L%^$L"L+Q

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultIXPUB技术博客ZB.}%\2e a e

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

b7[mISP10979521

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

dN`q-m#C ~10979521

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

0wE+l F7|zZ$qM10979521

CONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultIXPUB技术博客nSB5^r

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultIXPUB技术博客N?2i"{:|CiR

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

$thTh+W10979521

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/free/oracle/product/10.2.0/db_1/dbs/snapcf_orcl.f'; # default

-Y+s!UaIUa7GB @ K10979521

 IXPUB技术博客+U}`{x]['BC

rman配置信息是记录在控制文件中的，控制文件恢复成功后，IXPUB技术博客 Z|E T'`"J8^b-x

可以看到，rman的配置信息出来了，这样恢复就可以依据这个信息继续进行。

W.A%M I)K#gz8c10979521

 IXPUB技术博客9k jW8O9US/N9C

下面恢复数据文件

)N%q@J@ `10979521

RMAN>restore database;IXPUB技术博客(N0b?p&k J

Starting restore at 20-11月-06IXPUB技术博客y)p(eXzR3K'j+F

Starting implicit crosscheck backup at 20-11月-06

e[ x2Y(u V7F10979521

using target database control file instead of recovery catalogIXPUB技术博客4wqj frw ? Hw

allocated channel: ORA_DISK_1

*cS(Wx:X6|10979521

channel ORA_DISK_1: sid=157 devtype=DISKIXPUB技术博客,c z Q*Y`;Olpx7S

Crosschecked 3 objectsIXPUB技术博客R]3K6I_!J&g,UT&]

Finished implicit crosscheck backup at 20-11月-06

a,}g.M/D4| V$xm10979521

 

2iY-Y|8L^a10979521

Starting implicit crosscheck copy at 20-11月-06

9xO7y#_m(n10979521

using channel ORA_DISK_1

(^1y7G1x%siVB)P10979521

Finished implicit crosscheck copy at 20-11月-06

2_ H l&h2WH1m?-jL10979521

 IXPUB技术博客&fEY"]L

searching for all files in the recovery areaIXPUB技术博客:X!}(sjx`~

cataloging files...IXPUB技术博客.^NKuw5K3o

no files catalogedIXPUB技术博客 U] A(t/P0nkc

 IXPUB技术博客7H'Os'{$]Wynph3a

using channel ORA_DISK_1

VG(BR"r{UuP10979521

 IXPUB技术博客 }6|4`_m&H

channel ORA_DISK_1: starting datafile backupset restoreIXPUB技术博客/Pl @Cbg:gV7k5pL

channel ORA_DISK_1: specifying datafile(s) to restore from backup setIXPUB技术博客zf)Q:~$L!U@ m2A&_

restoring datafile 00001 to /free/oracle/oradata/orcl/system01.dbfIXPUB技术博客"y"OV3[(Z;?T XK

restoring datafile 00002 to /free/oracle/oradata/orcl/undotbs01.dbfIXPUB技术博客1M6n#m8oj?:{7w

restoring datafile 00003 to /free/oracle/oradata/orcl/sysaux01.dbfIXPUB技术博客N;| }g XesH+D0M

restoring datafile 00004 to /free/oracle/oradata/orcl/users01.dbf

}&R\7G?T+ZN,P#F10979521

restoring datafile 00005 to /free/oracle/oradata/orcl/gaojfdb.dbfIXPUB技术博客G'J/lIb"l

channel ORA_DISK_1: reading from backup piece /free/oracle/orabak/full_ORCL_20061119_5IXPUB技术博客,M4~&y`^R

channel ORA_DISK_1: restore complete, elapsed time: 00:02:29IXPUB技术博客!d U%jPV|!s7PK

Finished restore at 20-11月-06

d'[!Ir*xt,L10979521

l3|nKA2]d4q7}p10979521IXPUB技术博客+Xx T,I+qh

数据文件恢复完毕。IXPUB技术博客pV$p t5H_t

4：开始进行介质恢复

如果原来数据库的redo文件还保存完好，

%GySKU;H!P10979521

那么复制redo文件到新的数据库，可以保证完全恢复数据。

KQ-j;^RD+tM:N(c10979521

如果原来数据库的redo文件还�

相关阅读:

导入论坛 引用链接 收藏 分享给好友 推荐到圈子 管理 举报

TAG: oracle rman

 

评分：0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-09-11  
日 一 二 三 四 五 六
 123456
78910111213
14151617181920
21222324252627
282930    

数据统计

  • 访问量: 11944
  • 日志数: 100
  • 书签数: 3
  • 建立时间: 2007-12-12
  • 更新时间: 2008-09-07

RSS订阅

Open Toolbar