Oracle综合辅导：OracleRman/tivoli-TDP/下数据恢复到节点

会计考友

一、把43p-db的tdpo_node文件的TDPO_NODE改为 h50b的node name
7 A" C- M3 D4 F" m　　# vi /usr/tivoli/tsm/client/oracle/bin/tdpo.opt
1 K4 b- g! U" \( C9 |7 b) \　　TDPO_NODE　　　　　　　 tdp_h50b
　　# cd /usr/tivoli/tsm/client/oracle/bin/
: z3 x% W6 Q- x8 B9 f* [) s　　# tdpoconf password
　　************************************************************
; N/ M- S7 F. b2 c　　*　　　 Tivoli Data Protection for Oracle Utility　　　　　 *
: u: c" y; @: p　　*　Password file initialization/update program　　　　　　　*
) P+ }! k% i/ D# ]　　*　　 ROOT privilege needed to update value　　　　　　　　 *
4 e* N5 I$ d- @- N0 n/ z3 ~4 G　　*************************************************************
　　Please enter current password:
　　Please enter new password:
　　Please reenter new password for verification:
　　ANU0260I Password successfully changed.
& h9 u  v! n- H& B　　
　　二、Copy h50B的configora8_sb.ora initora8_sb.ora和口令文件到43p-db相应目录。所有相应的目录都要预先创建好
; Y3 N! ^2 ?) E　　三、43p-db的oracle为Startup nomount状态
0 ^; V0 G% ]6 T8 L　　在H50b:
　　　恢复控制文件
% _, p# n* t# C, M: I$ c  y　　$ export ORACLE_SID=ora8_sb
. \5 B8 N. ~. L- B1 d6 q　　$ rman target system/passwd1@43p-db rcvcat rman/rman@forjy
3 D, @! [/ R$ n6 O/ O* B  h　　Recovery Manager: Release 8.0.5.2.1 - Production
/ z& @# a: T& x  d) {& d5 N5 q　　
# o: T! Q- c, u　　RMAN-06006: connected to target database: ora8_sb (not mounted)
　　RMAN-06008: connected to recovery catalog database
3 J3 a8 u" e0 ~' g0 d0 i　　RMAN> run {
+ t# V, ~2 K' Y2 e/ h2 ^　　 allocate channel t1 type 'sbt_tape' parms
　　 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
! O9 M* U8 z0 b) f　　 restore controlfile to '/sbfs/ctl01sb.ctl';
　　 release channel t1;
　　 allocate channel d1 type disk;
8 x. C5 t1 v4 _/ |　　 replicate controlfile from '/sbfs/ctl01sb.ctl';
5 Y  E% `8 D% m$ l% b　　 sql 'alter database mount';
( @; K1 ^6 ~0 ]" R3 V　　 release channel d1;

会计考友

　　}
　　RMAN-03022: compiling command: allocate
　　RMAN-03023: executing command: allocate
+ h9 k7 q' e; D2 y; F　　RMAN-08030: allocated channel: t1
  H# ?% @# a- o/ s; r) r1 d　　RMAN-08500: channel t1: sid=12 devtype=SBT_TAPE
$ w, Y8 \+ v9 X+ C' G　　RMAN-03022: compiling command: restore
　　RMAN-03022: compiling command: IRESTORE
　　RMAN-03023: executing command: IRESTORE
% I4 ]# H& G5 A( K　　RMAN-08016: channel t1: starting datafile backupset restore
% O( C$ h. t; o9 T8 t7 ]　　RMAN-08502: set_count=0 set_stamp=0
; X- K/ |8 {- [. {　　RMAN-08021: channel t1: restoring controlfile
2 \+ t# c# o# O: Q1 h# D! [　　RMAN-08505: output filename=/sbfs/ctl01sb.ctl
　　RMAN-08023: channel t1: restored backup piece 1
' S+ u+ w# s2 {3 `　　RMAN-08511: piece handle=ORA8_SB_full_497711454_17_1 params=NULL
- G, ]; G1 ^. ^* r　　RMAN-08024: channel t1: restore complete
　　RMAN-03022: compiling command: release
　　RMAN-03023: executing command: release
　　RMAN-08031: released channel: t1
　　RMAN-03022: compiling command: allocate
. e9 R7 M; w2 U) H. s4 y- j　　RMAN-03023: executing command: allocate
: B" h, B' c  i　　RMAN-08030: allocated channel: d1
: |0 d, l" M6 }+ \　　RMAN-08500: channel d1: sid=12 devtype=DISK
　　RMAN-03022: compiling command: replicate
! V6 r6 d9 Q& h% w3 y. B) ^　　RMAN-03023: executing command: replicate
　　RMAN-08058: replicating controlfile
  d5 S1 I9 ]/ Q4 c* O　　RMAN-08506: input filename=/sbfs/ctl01sb.ctl
　　RMAN-08505: output filename=/sbfs/sbdata1/ctl02sb.ctl
; A9 X" i3 ^/ Z4 Q4 e* i0 D/ v% w& S6 Q　　RMAN-08505: output filename=/sbfs/sbdata2/ctl03sb.ctl
　　RMAN-03022: compiling command: sql
4 o& X, b* L2 j( S# i  E6 M) x　　RMAN-06162: sql statement: alter database mount
7 ?, c5 v- s" t# w: ~; Z　　RMAN-03023: executing command: sql
3 E2 Y/ {7 n. y　　RMAN-03022: compiling command: release
" b5 _; ^3 c" o9 M　　RMAN-03023: executing command: release
& V# U1 D2 D1 n5 b) Q1 w　　RMAN-08031: released channel: d1
$ k) S3 ?0 b+ U- h　　RMAN>exit
! U3 z5 G! U) V  V　　Recovery Manager complete.