2、选择存放归档日志的位置,然后执行呼吁:
6 L0 p( ~& \) D% r1 ] RUN* I$ c7 i' p: U1 t* L
{
5 b- G7 ?3 R- `; u u9 ^ SET ARCHIVELOG DESTINATION TO '新位置';
. U* @' S; X0 x' O9 h RESTORE ARCHIVELOG SEQUENCE XXXX;4 G/ z) y: F3 ^' R5 @
}: E4 p( S2 H$ m7 J" C: @. O4 f" F
注重:如不美观不用"SET ARCHIVELOG DESTINATION TO '新位置';"该语句,归档日志会在数据库的默认的归档日志目录。
# q$ T8 Y3 n6 N( F7 @8 N. }) [/ C 呼吁如下:
+ H$ z/ Y3 g$ u9 {# m Recovery Manager complete. {* P$ v ^6 w% {4 U" o) K% Y
LHXXDBS01:oraoms> pwd" o( V! {$ x9 ]( P! J% K5 X
/oracle/oms/oradata/temp3 y7 K* ^3 ^/ {/ ]( s( ?
LHXXDBS01:oraoms> rman target/* F2 X, g0 x: j; P* o. [7 }( t
Recovery Manager: Release 10.2.0.1.0 Production on Tue Oct 21 08:52:08 20086 g8 v! p% s9 k5 J0 j
Copyright (c) 1982, 2005, Oracle. All rights reserved.
0 g( A4 P/ t! p/ i, D3 p connected to target database: LHOMS (DBID=2813856949)1 G& ~# p& S# A! ~/ q s
RMAN> run{
5 f H( p! ~4 a6 H: A 2> set archivelog destination to '/oracle/oms/oradata/temp';+ g" z+ a, l6 h( h- v
3> restore archivelog sequence 3442;; d- V' p; E7 Z2 d" x3 u
4> }
9 ^! K, A2 w2 m9 L executing command: SET ARCHIVELOG DESTINATION# E+ w+ Z- o6 G; A2 N
using target database control file instead of recovery catalog5 J; B0 o8 L8 o
Starting restore at 21OCT08$ D5 G" x' J- J- U
allocated channel: ORA_SBT_TAPE_1% b) r! R' _' c- C5 v+ A
channel ORA_SBT_TAPE_1: sid=465 devtype=SBT_TAPE
0 G% H1 `' }: m( I channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.3.3.0
2 {# A! J; b, W/ Y, K3 T allocated channel: ORA_SBT_TAPE_2
7 u L! v/ u6 s/ P3 D9 D channel ORA_SBT_TAPE_2: sid=543 devtype=SBT_TAPE; D y) T7 E: V4 v6 q. \$ a
channel ORA_SBT_TAPE_2: Data Protection for Oracle: version 5.3.3.0
8 p2 F, [8 I5 j& z" f; k allocated channel: ORA_DISK_1/ ?3 S3 R- Y: }, S' Y( a! f% Z) @
channel ORA_DISK_1: sid=480 devtype=DISK$ P& L; w, [' T
channel ORA_SBT_TAPE_1: starting archive log restore to userspecified destinati0 | e' a( f G5 S$ K
on) X+ Y! n2 i8 P3 e. I
archive log destination=/oracle/oms/oradata/temp6 w0 v6 J E* J7 ?
channel ORA_SBT_TAPE_1: restoring archive log
/ J2 ~* s) s7 V& A1 [" a+ n/ _ archive log thread=1 sequence=3442; S/ W$ e6 c2 t& q: _
channel ORA_SBT_TAPE_1: reading from backup piece arch_20081020_9623_1
$ e# _7 F# M6 |# I, I) c channel ORA_SBT_TAPE_1: restored backup piece 1
- t$ r. K9 w4 S* O/ B' m" q, g piece handle=arch_20081020_9623_1 tag=TAG20081020T200529
$ {% j- E% { C/ Y2 Y5 ?* }5 u channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:03:078 A( i: F2 h' c2 T5 W2 Z$ j
Finished restore at 21OCT08
. z, V0 H2 @4 Q( O1 ^5 A+ y 此刻已经把sequence号为3442的归档日志转存到/oracle/oms/oradata/temp目录下。
0 ^# P# q& A1 C! w* f; x 如不美观需要提取几天的归档日志出来,归档日志斗劲年夜、斗劲多的话,则需要破耗良多时刻。 |