RAC环境的恢复策略

上一篇 / 下一篇 2007-06-26 00:00:00 / 个人分类：ORACLE

对于RAC环境，不同的备份策略会导致备份文件的分步不同，如果频繁修改备份策略，或者备份策略混乱的话，会给恢复过程带来很大的困难。

8hiD#q1O0

对于RAC环境中的多种备份策略，前面已经通过10篇文章详细描述了，这里想要强调的是，备份策略的不同，会导致备份结果的分步不同，进而影响恢复的策略和步骤。

一般情况下，恢复策略和备份策略必须是对应的。如果备份策略进行了修改，那么恢复也应该采用相同的策略。

这样描述太过于抽象，举个例子，比如备份的时候用RMAN配置两个CHANNEL，每个CHANNEL都通过CONNECT语句指向一个实例，在备份的时候，两个CHANNEL同时运行，每个实例会将本CHANNEL读取的数据文件写到这个实例所在服务器所挂接的磁带上。

而在恢复过程中，每个节点都只能挂接自己备份的磁带，而无法恢复别的节点备份的磁带。也就是说，恢复也必须启动两个CHANNEL，每个连接到一个实例上，同时进行恢复。

为了避免出现问题，建议在变更备份策略后，马上对整个数据库进行一次备份。另外在恢复之前，可以考虑利用VALIDATE来验证恢复是否是可行的，下面这个例子就说明备份机制和恢复机制不同的话，会造成的问题：

bash-2.03$ export NLS_LANG=americanITPUB个人空间o~rtW
bash-2.03$ export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' ITPUB个人空间U.g"C6fP9mPE W
bash-2.03$ rman target /

Recovery Manager: Release 10.2.0.3.0 - Production on Tue Jun 26 13:11:42 2007

connected to target database: TESTRAC (DBID=4291216984, not open)

RMAN> run ITPUB个人空间|0J:jMu2K#@?
2> {ITPUB个人空间Ydh.MF]DY
3> set until time '2007-6-21 0:0:0';
?#U'RxLxV04> restore database;
5> recover database;ITPUB个人空间{a f#l)P x'y_+q2I
6> }

executing command: SET until clause
P{#K#e)P0using target database control file instead of recovery catalog

Starting restore at 2007-06-26 13:14:31
9T:Pn\:j;Y#Dfzq)O0configuration for SBT_TAPE channel 2 is ignoredITPUB个人空间pl9tb:O?7U
allocated channel: ORA_SBT_TAPE_1
F+h2`/VrQ9_ SO6D0?A0channel ORA_SBT_TAPE_1: sid=313 instance=testrac2 devtype=SBT_TAPEITPUB个人空间,g+pIj4Xm @;D
channel ORA_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)ITPUB个人空间4D+IOQ6r6gD4rsM
allocated channel: ORA_DISK_1
YD;nu&M_'km;F)Z0channel ORA_DISK_1: sid=305 instance=testrac2 devtype=DISK
_e-E7ABZl0allocated channel: ORA_DISK_2
Y Ea)QH FYn;XJo0channel ORA_DISK_2: sid=304 instance=testrac2 devtype=DISK

channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间;]D!\yB x1r#[r
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间jKM_4G5GLm
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279ITPUB个人空间Ue6Ql6u%A
restoring datafile 00006 to +DISK/testrac/datafile/zhejiang01.dbf
%a`e@p5uC T0restoring datafile 00008 to +DISK/testrac/datafile/ndmain01.dbfITPUB个人空间3lIpV`5SS*b.wt2H/s
restoring datafile 00009 to +DISK/testrac/datafile/zhejiang03.dbfITPUB个人空间.Bpe6S:o'h#D.P-@r
restoring datafile 00010 to +DISK/testrac/datafile/ndindex01.dbf
"s'~3j%N @ fj0restoring datafile 00012 to +DISK/testrac/datafile/zhejiang05.dbfITPUB个人空间X)Ma8D ?j
channel ORA_SBT_TAPE_1: reading from backup piece krikm8an_1_1
B~Y_;Cu#UX0ORA-19870: error reading backup piece krikm8an_1_1ITPUB个人空间 s]u7P!hR
ORA-19507: failed to retrieve sequential file, handle="krikm8an_1_1", parms=""
b D+i*Q3Kk0ORA-27029: skgfrtrv: sbtrestore returned error
edRm T)AK5ZO%?7w0ORA-19511: Error received from media manager layer, error text:ITPUB个人空间:I%M(ZW \2Q!s0ZI6a
Backup file <krikm8an_1_1> not found in NetBackup catalogITPUB个人空间;G P/gy`_!V
channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间 d(xJkZ&SQ'E6F
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
*S|#qlV'~4ZrN"f0restoring datafile 00001 to +DISK/testrac/datafile/system.262.618591167
E1J-ErK*I&r0{0restoring datafile 00002 to +DISK/testrac/datafile/undotbs1.263.618591197
)yG"m3zzK1Pu0channel ORA_SBT_TAPE_1: reading from backup piece kvikmgua_1_1
tw\cR D*VC0ORA-19870: error reading backup piece kvikmgua_1_1ITPUB个人空间bUR0ji
ORA-19507: failed to retrieve sequential file, handle="kvikmgua_1_1", parms=""
J(rFr@+?I7Z'A0ORA-27029: skgfrtrv: sbtrestore returned error
q&~ e1@u-O5E0ORA-19511: Error received from media manager layer, error text:
/V5UE4Awku s VM0 Backup file <kvikmgua_1_1> not found in NetBackup catalogITPUB个人空间YqRbP
channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间 _-x3w&d$b)HO B
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间 b6c!pZ`
restoring datafile 00003 to +DISK/testrac/datafile/sysaux.264.618591225
c)jxM1Y9d$d0D0restoring datafile 00004 to +DISK/testrac/datafile/undotbs2.266.618591249
CE/u"RO@0restoring datafile 00007 to +DISK/testrac/datafile/zhejiang02.dbf
R5fke#{"jn'P0restoring datafile 00011 to +DISK/testrac/datafile/zhejiang04.dbf
M7Oi f5fxW6Le0restoring datafile 00013 to +DISK/testrac/datafile/lt_index_ts01.dbfITPUB个人空间 c4D$]`_@5y;\*K%W
restoring datafile 00014 to +DISK/testrac/datafile/zhejiang06.dbf
.ve*q2l e4?z![^0restoring datafile 00015 to +DISK/testrac/datafile/gpo.367.624623443ITPUB个人空间^1Ip#KW\*Qyj
channel ORA_SBT_TAPE_1: reading from backup piece liikp6gh_1_3
~3W~]9n(R5{0channel ORA_SBT_TAPE_1: restored backup piece 1
O:Zl4za p;G0piece handle=liikp6gh_1_3 tag=TAG20070620T185927
NK)hy_3^9o0channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:31:05ITPUB个人空间"bZoy[ XT8h
failover to previous backup

channel ORA_DISK_1: restoring datafile 00001
hkla,X0input datafile copy recid=334 stamp=625680829 filename=/data1/backup/system.dbfITPUB个人空间3gZ[b.cud!V.C5F
destination for restore of datafile 00001: +DISK/testrac/datafile/system.262.618591167
:I-qh|x-FG G{0ORA-19505: failed to identify file "/data1/backup/system.dbf"ITPUB个人空间_ @D1Gk5U4g
ORA-27037: unable to obtain file statusITPUB个人空间}X2KC-T2L b f,CA
SVR4 Error: 2: No such file or directoryITPUB个人空间&x]w:a'UkL]"[ ]s
Additional information: 3ITPUB个人空间Xo(nFU})S
ORA-19600: input file is datafile-copy 334 (/data1/backup/system.dbf)
dR(PmI}0ORA-19601: output file is datafile 1 (+DISK/testrac/datafile/system.262.618591167)
zP?Br#{0channel ORA_SBT_TAPE_1: starting datafile backupset restore
q/o[%h"\X0channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间 } @+IS]Mp
restoring datafile 00006 to +DISK/testrac/datafile/zhejiang01.dbf
mU#h_%h0restoring datafile 00008 to +DISK/testrac/datafile/ndmain01.dbfITPUB个人空间5G8`I:W9En,k8^
restoring datafile 00009 to +DISK/testrac/datafile/zhejiang03.dbfITPUB个人空间wP:T M;r bm |
restoring datafile 00010 to +DISK/testrac/datafile/ndindex01.dbf
VsY.LVnjU0restoring datafile 00012 to +DISK/testrac/datafile/zhejiang05.dbfITPUB个人空间cu2R_,d3ML+?
channel ORA_SBT_TAPE_1: reading from backup piece kjiklia0_1_1
2K HR|)mN^ZA0ORA-19870: error reading backup piece kjiklia0_1_1ITPUB个人空间pSIG~jS2T
ORA-19507: failed to retrieve sequential file, handle="kjiklia0_1_1", parms=""ITPUB个人空间*_ D.no2ST^4J,Q
ORA-27029: skgfrtrv: sbtrestore returned error
5me;i_G#eL0ORA-19511: Error received from media manager layer, error text:
5i]c G3u!S{0 Backup file <kjiklia0_1_1> not found in NetBackup catalog
fOOr E5B;bkh!|I7|0channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间}"rol n-[ig
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间)zvqdE1E
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279
^mjKY0channel ORA_SBT_TAPE_1: reading from backup piece knikm6aq_1_1
;Z#Dp&xJ{_5?0ORA-19870: error reading backup piece knikm6aq_1_1
"L O@ c!l0ORA-19507: failed to retrieve sequential file, handle="knikm6aq_1_1", parms=""ITPUB个人空间G j0S"{F^ `'|8bh
ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间mk,F8`w3K8H
ORA-19511: Error received from media manager layer, error text:ITPUB个人空间0J3k'|7Ye#n
Backup file <knikm6aq_1_1> not found in NetBackup catalogITPUB个人空间0Vv$Hd}T
channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间:i%l$P\Od
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间1`4]3a#vp1T
restoring datafile 00002 to +DISK/testrac/datafile/undotbs1.263.618591197
{$j!YbyK8ft0channel ORA_SBT_TAPE_1: reading from backup piece krikm8an_1_1
&artMpM"B2lZ0ORA-19870: error reading backup piece krikm8an_1_1ITPUB个人空间5Jk Wa _w%m$y'`
ORA-19507: failed to retrieve sequential file, handle="krikm8an_1_1", parms=""ITPUB个人空间2I5\x0k+V z!IaJ_
ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间Sg2S I(K:e@
ORA-19511: Error received from media manager layer, error text:ITPUB个人空间:_.ro2fWra
Backup file <krikm8an_1_1> not found in NetBackup catalogITPUB个人空间5tfBW3^/~-tI%i
failover to previous backup

channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间-`_[0q;jZ k+{
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
B!iV3SQ1H"J0restoring datafile 00009 to +DISK/testrac/datafile/zhejiang03.dbfITPUB个人空间S)p$Vg$J-v
channel ORA_SBT_TAPE_1: reading from backup piece k0ikjnpt_1_1
/T7V'?wp?wN}0channel ORA_SBT_TAPE_1: restored backup piece 1ITPUB个人空间$?!bPpNS
piece handle=k0ikjnpt_1_1 tag=TAG20070618T171750ITPUB个人空间;T}A6GHlU&t
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:27:55
#l*Z~/_5w$`4EhF9?0channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间2sDI8WHN&{
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间6sd4|*w"Uv5g
restoring datafile 00012 to +DISK/testrac/datafile/zhejiang05.dbf
`t?4Y$Ap9_I0channel ORA_SBT_TAPE_1: reading from backup piece jvikjnpv_1_1
7u8@_\ an0ORA-19870: error reading backup piece jvikjnpv_1_1
'_ict*x;F3rXi0ORA-19507: failed to retrieve sequential file, handle="jvikjnpv_1_1", parms=""ITPUB个人空间.X9B5Y HUi eno)f
ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间.^7pw4?*@Sw\
ORA-19511: Error received from media manager layer, error text:ITPUB个人空间3f;w%k&K;c
Backup file <jvikjnpv_1_1> not found in NetBackup catalogITPUB个人空间9c4`,d5BN2vf h
channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间P8n:dt$q+\0_S
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
,y9rTj4Y q0restoring datafile 00006 to +DISK/testrac/datafile/zhejiang01.dbf
Pt*Dni;q^'JT,J0restoring datafile 00008 to +DISK/testrac/datafile/ndmain01.dbfITPUB个人空间9E1K Q'w5q*E
channel ORA_SBT_TAPE_1: reading from backup piece juikjnpv_1_1ITPUB个人空间'FXt7F)e([b
ORA-19870: error reading backup piece juikjnpv_1_1
"p+`L.Vvz f0s0ORA-19507: failed to retrieve sequential file, handle="juikjnpv_1_1", parms=""
Ja2lWb!^!oMG!h#w0ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间5c*?`[5U1`]$}
ORA-19511: Error received from media manager layer, error text:
n"R5j4O3chv(G0W0 Backup file <juikjnpv_1_1> not found in NetBackup catalogITPUB个人空间%OFvA+r~8||&]
channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间&X7w;\m!v.cH
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间Cj9cAIJ
restoring datafile 00010 to +DISK/testrac/datafile/ndindex01.dbf
Qly]h([-f0channel ORA_SBT_TAPE_1: reading from backup piece kfiklhd6_1_1
gNV2U:J,]#x FGK)j5e0ORA-19870: error reading backup piece kfiklhd6_1_1
6I$~)?k G,[Hu0ORA-19507: failed to retrieve sequential file, handle="kfiklhd6_1_1", parms=""
1|,usb[T0Jf m3L0ORA-27029: skgfrtrv: sbtrestore returned error
o6}4\oSn"h0ORA-19511: Error received from media manager layer, error text:ITPUB个人空间#ou/iz$\!gbYxU
Backup file <kfiklhd6_1_1> not found in NetBackup catalog
qS~:^B6iC0channel ORA_SBT_TAPE_1: starting datafile backupset restore
\8A#uD#^B ZZz:a0channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
&T3sLU,f,st8@8GG0restoring datafile 00002 to +DISK/testrac/datafile/undotbs1.263.618591197
a)V5C|(?8j#L0restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279ITPUB个人空间#aQ9JVlkb9N
channel ORA_SBT_TAPE_1: reading from backup piece kjiklia0_1_1ITPUB个人空间Aj\T$v/bhC
ORA-19870: error reading backup piece kjiklia0_1_1ITPUB个人空间J#Q D2\(U8|"L
ORA-19507: failed to retrieve sequential file, handle="kjiklia0_1_1", parms=""ITPUB个人空间 q*w2b0`@1H4KkZ*T9O
ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间O:?#f~\*XEZ#?
ORA-19511: Error received from media manager layer, error text:ITPUB个人空间U5^)C,uJ
Backup file <kjiklia0_1_1> not found in NetBackup catalogITPUB个人空间g|0q6Y`?$[
channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间H\;nw6}O+V*M0d
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
^o G ]PP{DO:h8{0restoring datafile 00001 to +DISK/testrac/datafile/system.262.618591167ITPUB个人空间HI3a$Q N7yzkK
channel ORA_SBT_TAPE_1: reading from backup piece l4iko4cr_1_1
u7r+wn+S0ORA-19870: error reading backup piece l4iko4cr_1_1
j7fi#_[0ORA-19507: failed to retrieve sequential file, handle="l4iko4cr_1_1", parms=""ITPUB个人空间k dDJ}&q:R-e
ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间1b}x"cs eU
ORA-19511: Error received from media manager layer, error text:ITPUB个人空间O&i@kT@j
Backup file <l4iko4cr_1_1> not found in NetBackup catalogITPUB个人空间!@/\M\"t|$u j
failover to previous backup

channel ORA_SBT_TAPE_1: starting datafile backupset restore
7CpcRa$g0channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间{,]@ M v t3u
restoring datafile 00010 to +DISK/testrac/datafile/ndindex01.dbf
&tam(bQ^h!Vw0channel ORA_SBT_TAPE_1: reading from backup piece iiik9hb2_1_2ITPUB个人空间x)@${#uA+q2Wg9p
channel ORA_SBT_TAPE_1: restored backup piece 1
,Yjp(qb^1S0piece handle=iiik9hb2_1_2 tag=TAG20070614T202609
PU)}2q[7P0channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:03:36ITPUB个人空间aa!zKFEW)~
channel ORA_SBT_TAPE_1: starting datafile backupset restore
r:V|yCKA-z0channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间&g N0q;rM
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279
1Q-c@0ks-xH$q@0channel ORA_SBT_TAPE_1: reading from backup piece j7ikirtu_1_1ITPUB个人空间6Y8fiwV
ORA-19870: error reading backup piece j7ikirtu_1_1ITPUB个人空间m6N(AkX:~ w+S
ORA-19507: failed to retrieve sequential file, handle="j7ikirtu_1_1", parms=""ITPUB个人空间?Z:\`Z8^[
ORA-27029: skgfrtrv: sbtrestore returned errorITPUB个人空间8y [W$Xv,n
ORA-19511: Error received from media manager layer, error text:
8{[U)]PkPfl0 Backup file <j7ikirtu_1_1> not found in NetBackup catalog
hQA5b6`J['[0failover to previous backup

channel ORA_SBT_TAPE_1: starting datafile backupset restore
(I-geonrp0channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间 U r\n;@
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279ITPUB个人空间K!Mk'r]&~
channel ORA_SBT_TAPE_1: reading from backup piece j3ikbop1_1_1ITPUB个人空间V(r*`/e5ve'^{
ORA-19870: error reading backup piece j3ikbop1_1_1ITPUB个人空间hqV ]wZ/tx4u
ORA-19507: failed to retrieve sequential file, handle="j3ikbop1_1_1", parms=""ITPUB个人空间+m$ka/V0Q
ORA-27029: skgfrtrv: sbtrestore returned error
S%xeb3Zt{3j0ORA-19511: Error received from media manager layer, error text:ITPUB个人空间8L"bR6pa|4H
Backup file <j3ikbop1_1_1> not found in NetBackup catalogITPUB个人空间`(E+i)LS~]4gB ]
failover to previous backup

channel ORA_SBT_TAPE_1: starting datafile backupset restoreITPUB个人空间Lg5Zh}
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间`T/Tm2uQ(k
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279
N2VOY#U.}0channel ORA_SBT_TAPE_1: reading from backup piece ioikbn05_1_1
b0o a?B0ORA-19870: error reading backup piece ioikbn05_1_1ITPUB个人空间'M{.GG*b u#@8`p6F
ORA-19507: failed to retrieve sequential file, handle="ioikbn05_1_1", parms=""
pS l h*d ~Q0ORA-27029: skgfrtrv: sbtrestore returned error
.E#A'R_-g@0ORA-19511: Error received from media manager layer, error text:
"D6gr/@C0 Backup file <ioikbn05_1_1> not found in NetBackup catalog
&ez1C7Y2n\0failover to previous backup

channel ORA_SBT_TAPE_1: starting datafile backupset restore
l4O-j-I3]]0channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup setITPUB个人空间EE)?z-_L1Vy$h2k
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279ITPUB个人空间Mt%ac[
channel ORA_SBT_TAPE_1: reading from backup piece iiik9hb2_1_2ITPUB个人空间6O1y5L bL3Qn
channel ORA_SBT_TAPE_1: restored backup piece 1
,SDNX:D9DV0piece handle=iiik9hb2_1_2 tag=TAG20070614T202609ITPUB个人空间k\eQQ
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:02:35ITPUB个人空间WOU4v1w
Finished restore at 2007-06-26 15:32:39

Starting recover at 2007-06-26 15:32:39
Z q k T*_~/V#y0using channel ORA_SBT_TAPE_1ITPUB个人空间F5U$d G7Z
using channel ORA_DISK_1
1g xn/x asR#~}!T0using channel ORA_DISK_2

starting media recovery

channel ORA_SBT_TAPE_1: starting archive log restore to default destination
Nn4~2S7H @0channel ORA_SBT_TAPE_1: restoring archive log
^7P!Y_ Bv-|0archive log thread=2 sequence=253
,E{6I-Wjgi(_,C7~$WA1J0channel ORA_SBT_TAPE_1: restoring archive log
k'B1Zoq0archive log thread=1 sequence=338
&Rq'tq a1R:j:t-]0channel ORA_SBT_TAPE_1: restoring archive logITPUB个人空间\e1_ QF5H3k
archive log thread=2 sequence=254
7T;O+V*]3bh#T8|.UE0channel ORA_SBT_TAPE_1: reading from backup piece jgikj1tq_1_1ITPUB个人空间8D+D\cT6@ s6n:w
channel ORA_SBT_TAPE_1: restored backup piece 1
{ D7K-L1b0m0piece handle=jgikj1tq_1_1 tag=TAG20070618T110427ITPUB个人空间+n5x.u:s zQXzH
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:03:25
7d"l2O C4K-VI0archive log filename=/data1/archivelog/2_253_618591128.dbf thread=2 sequence=253
T\'MFlwD0archive log filename=/data1/archivelog/1_338_618591128.dbf thread=1 sequence=338
V_Y/@I)Gws0[#Z0channel ORA_SBT_TAPE_1: starting archive log restore to default destinationITPUB个人空间f#u:N5yGsN
channel ORA_SBT_TAPE_1: restoring archive log
?rv L I#Z/U9T2t0archive log thread=1 sequence=339ITPUB个人空间"B6t1PW1SZv;Ba4A#?
channel ORA_SBT_TAPE_1: restoring archive log
j9[1DZ'bEI,pQ!`0archive log thread=1 sequence=340ITPUB个人空间h#fAq7n_ zy`
channel ORA_SBT_TAPE_1: reading from backup piece jfikj1tt_1_1ITPUB个人空间q9edDa~I?'q
ORA-19870: error reading backup piece jfikj1tt_1_1
5k d#vYS ~'S'q0ORA-19507: failed to retrieve sequential file, handle="jfikj1tt_1_1", parms=""
)E^K$](L4F UT0ORA-27029: skgfrtrv: sbtrestore returned error
}8n-R#pP4z$d-^0ORA-19511: Error received from media manager layer, error text:
1}qp;QLS0 Backup file <jfikj1tt_1_1> not found in NetBackup catalogITPUB个人空间!tA0F;^ oxs
failover to previous backupITPUB个人空间&X:N*?1i T6F*f/R
Oracle Error: ITPUB个人空间i%~ lvP-t$Po Z
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
r,C0}R9DFZ"dN0ORA-01152: file 1 was not restored from a sufficiently old backup
hMef2Wy8A0ORA-01110: data file 1: '+DISK/testrac/datafile/system.262.618591167'

RMAN-00571: ===========================================================ITPUB个人空间$S+X(kV#S ]"]X5a m
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
GH{Z7ei @7r(DB0RMAN-00571: ===========================================================ITPUB个人空间F'A@lJD\5UnL
RMAN-03002: failure of recover command at 06/26/2007 15:37:07
0f5{o[s0RMAN-20506: no backup of archivelog foundITPUB个人空间Q$Y/}C6Ui+kV!u.H
RMAN-06053: unable to perform media recovery because of missing logITPUB个人空间~C?9gas
RMAN-06025: no backup of log thread 1 seq 340 lowscn 5215185427 found to restore
)O"tn9us;dh0RMAN-06025: no backup of log thread 1 seq 339 lowscn 5214803171 found to restore

由于前面一段时间，在使用这个数据库进行备份的测试，前后采用多种备份策略执行了很多次的备份操作。而这个恢复操作使用的又是不完全恢复，因此Oracle没有选择最新的备份进行恢复，造成了目前的恢复策略和备份是的不一致，Oracle在大量的失败重试后，最终仍然是以错误结束了恢复操作。

想要解决这个问题，就必须采用合适的恢复策略：

RMAN> runITPUB个人空间.b s!XmxTZ{
2> {
/Z/WoD#a wN"S@ b03> set until time '2007-6-21 0:0:0';ITPUB个人空间0H;S7}s Ws
4> allocate channel c1 device type sbt connect 'sys/test@testrac1';
oX ] |y%P!}05> allocate channel c2 device type sbt connect 'sys/test@testrac2';
M N`,ylo'y06> restore database;
1w Q.`]At07> recover database;ITPUB个人空间dCI9pQ oe aa6{
8> }

executing command: SET until clause

allocated channel: c1ITPUB个人空间ZE.zxi;U
channel c1: sid=313 instance=testrac1 devtype=SBT_TAPE
y @w2YN-u CqW0channel c1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

allocated channel: c2ITPUB个人空间/c5u;rS n w_$jH
channel c2: sid=313 instance=testrac2 devtype=SBT_TAPE
channel c2: VERITAS NetBackup for Oracle - Release 6.0 (2006110304)

Starting restore at 2007-06-26 15:57:18

skipping datafile 3; already restored to file +DISK/testrac/datafile/sysaux.264.618591225ITPUB个人空间&[?ru4w,Z.k
skipping datafile 4; already restored to file +DISK/testrac/datafile/undotbs2.266.618591249ITPUB个人空间8h-TN#DsZa
skipping datafile 7; already restored to file +DISK/testrac/datafile/zhejiang02.dbf
/DUt~[df0Q C0skipping datafile 11; already restored to file +DISK/testrac/datafile/zhejiang04.dbf
?pktI5{0skipping datafile 13; already restored to file +DISK/testrac/datafile/lt_index_ts01.dbf
A4BQs+R7GY0skipping datafile 14; already restored to file +DISK/testrac/datafile/zhejiang06.dbf
skipping datafile 15; already restored to file +DISK/testrac/datafile/gpo.367.624623443ITPUB个人空间\7?G+X,M_#r:CV
channel c1: starting datafile backupset restore
m~BUMgU0channel c1: specifying datafile(s) to restore from backup setITPUB个人空间0Sq/w&O-D
restoring datafile 00005 to +DISK/testrac/datafile/users.267.618591279
'o d!]*F%_&Jc"??0restoring datafile 00006 to +DISK/testrac/datafile/zhejiang01.dbfITPUB个人空间3HJ'\ I7I|&[3X3G
restoring datafile 00008 to +DISK/testrac/datafile/ndmain01.dbf
[z+z"Y5J bw0restoring datafile 00009 to +DISK/testrac/datafile/zhejiang03.dbfITPUB个人空间m#h~l;w Sc%S
restoring datafile 00010 to +DISK/testrac/datafile/ndindex01.dbf
&dh'N3J4N_0restoring datafile 00012 to +DISK/testrac/datafile/zhejiang05.dbf
ed(LQ}2k u;W XK b0channel c1: reading from backup piece krikm8an_1_1ITPUB个人空间wG%xz ZZ4J
channel c1: restored backup piece 1
-o[\#AH*PE~ kNS0piece handle=krikm8an_1_1 tag=TAG20070619T161202ITPUB个人空间#~b1DO`c
channel c1: restore complete, elapsed time: 01:29:13ITPUB个人空间!ldN7?2Z JQ"a
channel c1: starting datafile backupset restoreITPUB个人空间T/U%mo7j)H-{
channel c1: specifying datafile(s) to restore from backup set
u;V*wS\$|)C pPIq0restoring datafile 00001 to +DISK/testrac/datafile/system.262.618591167ITPUB个人空间l3iR_b E
restoring datafile 00002 to +DISK/testrac/datafile/undotbs1.263.618591197ITPUB个人空间u2K v,ZDt^qPb
channel c1: reading from backup piece kvikmgua_1_1
'ASe$nzD0channel c1: restored backup piece 1ITPUB个人空间1I@.i(FxGX]!G
piece handle=kvikmgua_1_1 tag=TAG20070619T183906ITPUB个人空间` H9N1DI.c
channel c1: restore complete, elapsed time: 00:05:26
jd,aO j}.K0Finished restore at 2007-06-26 17:32:10

Starting recover at 2007-06-26 17:32:11

starting media recovery

channel c2: starting archive log restore to default destination
'P7l;N%o,dx x,xi0channel c2: restoring archive logITPUB个人空间\Gn`mCc0PZ7Z
archive log thread=1 sequence=345
p*j6|8|/P*W&B0channel c2: restoring archive logITPUB个人空间pv)Y8{6xw;P"^I
archive log thread=1 sequence=346
rTv&v@Jm G0channel c2: restoring archive log
:_]{6G@'rdM0archive log thread=1 sequence=347
-?:Z3@!Q[]$LF w0channel c2: restoring archive log
B4K9^RI%ur bPN0archive log thread=1 sequence=348
I+[^Z/@'U&X0channel c2: restoring archive logITPUB个人空间o iL'q2hGN
archive log thread=1 sequence=349ITPUB个人空间lz YcpE
channel c2: restoring archive log
U3I+NbA0archive log thread=2 sequence=263ITPUB个人空间:Jin{"j(J?6k
channel c2: restoring archive logITPUB个人空间J)uQ+I2l*F'[s
archive log thread=2 sequence=264
:m5X-@Dj wj0channel c2: restoring archive logITPUB个人空间'NBm(X3A^#Q/C A
archive log thread=1 sequence=350
xu]'B4`Q@n[0channel c2: restoring archive log
'o-]o*BbU"Z0archive log thread=2 sequence=265ITPUB个人空间 fe-k6j6j+I'er"`
channel c2: restoring archive log
!m/XS5tHx0archive log thread=1 sequence=351ITPUB个人空间+H)@.Rk.z4K
channel c2: restoring archive log
aK5Fu\YX0archive log thread=2 sequence=266ITPUB个人空间-\3gX;J$@D-z
channel c2: restoring archive logITPUB个人空间Na0P|8UIf9K.Rl
archive log thread=1 sequence=352
S4g u yMcp?+s0channel c2: reading from backup piece r7il6c1t_1_1ITPUB个人空间6n"a1OGp
channel c2: restored backup piece 1ITPUB个人空间J$p|\r~
piece handle=r7il6c1t_1_1 tag=TAG20070625T185347
,u f)u2_2K#w`S8m0channel c2: restore complete, elapsed time: 00:02:35ITPUB个人空间Ubu/c ^hzObf
archive log filename=/data1/archivelog/1_345_618591128.dbf thread=1 sequence=345
4S0~]hC0channel c2: starting archive log restore to default destination
)efY$@[_M:j0channel c2: restoring archive logITPUB个人空间q2@h%Xr%whP
archive log thread=2 sequence=259
~Z8yDL@s0channel c2: restoring archive logITPUB个人空间 c*U3i8_J8Z*f
archive log thread=2 sequence=260
D@wU"I)Cd u0channel c2: restoring archive log
oPl4Le;YH~0archive log thread=2 sequence=261
%vJ2]Za*[0channel c2: restoring archive log
:ivei9S0Z#c0archive log thread=2 sequence=262
U9O1C;nl_gp$Nfa5c+r|0channel c2: reading from backup piece r8il6c7n_1_1
!j&?;H!Elt m0channel c2: restored backup piece 1
0d3{GBIg(l0piece handle=r8il6c7n_1_1 tag=TAG20070625T185347
Y^7N JO0channel c2: restore complete, elapsed time: 00:01:07
+Eg(P)C Q0G#_0archive log filename=/data1/archivelog/2_259_618591128.dbf thread=2 sequence=259
2Y2[.@1|D4i0archive log filename=/data1/archivelog/2_260_618591128.dbf thread=2 sequence=260ITPUB个人空间Ou/NZ8G#N3A|g
archive log filename=/data1/archivelog/1_346_618591128.dbf thread=1 sequence=346ITPUB个人空间!p}%r+];_9g*MbE
archive log filename=/data1/archivelog/1_347_618591128.dbf thread=1 sequence=347ITPUB个人空间0y3\m^.q&R9Y
archive log filename=/data1/archivelog/2_261_618591128.dbf thread=2 sequence=261
C%T;U:x'O0archive log filename=/data1/archivelog/2_262_618591128.dbf thread=2 sequence=262ITPUB个人空间/h'QW~-a
archive log filename=/data1/archivelog/1_348_618591128.dbf thread=1 sequence=348
9f#NB{5^:^'y7v@0archive log filename=/data1/archivelog/1_349_618591128.dbf thread=1 sequence=349ITPUB个人空间#c#B4@(jYk3T @
archive log filename=/data1/archivelog/2_263_618591128.dbf thread=2 sequence=263
archive log filename=/data1/archivelog/2_264_618591128.dbf thread=2 sequence=264ITPUB个人空间2F8~n0@w0i o
archive log filename=/data1/archivelog/1_350_618591128.dbf thread=1 sequence=350
5j MWe~ A"b_/C0archive log filename=/data1/archivelog/2_265_618591128.dbf thread=2 sequence=265
_"@/\Z@0archive log filename=/data1/archivelog/1_351_618591128.dbf thread=1 sequence=351
8V{/hrp0archive log filename=/data1/archivelog/2_266_618591128.dbf thread=2 sequence=266
IN_ s q"A1G;~0archive log filename=/data1/archivelog/1_352_618591128.dbf thread=1 sequence=352
h f8|sZr:SCk)l0media recovery complete, elapsed time: 00:00:58ITPUB个人空间OA{btC8uW5X
Finished recover at 2007-06-26 17:37:08
sKp8X#n0released channel: c2ITPUB个人空间,~ n?bh"x,K
released channel: c1