描述:数据库的地址系统为AIX5.3,数据库的备份经由过程Tivoli Storage Manage(简称TSM)软件把数据库数据、归档日志备份到带库中。
3 c4 G2 C# i$ [' z4 P+ [" l n' p( ?" S 在备份完归档日志到带库后,即删除数据库数据库中的归档日志。此刻需要发芽数据库中某表的数据具体是哪些用户进行操作的,需要用到数据库的归档日志。* H, b a' y. i+ E. |/ L1 [2 s. B
年夜带库中把归档日志提取到数据库中的某个位置上。
3 }) b/ O# o u U) E+ r8 B; q, D 1、远程上岸或当地上岸数据库处事器系统:
( p7 L( s: S1 ~ 进入rman的呼吁界面:
) n( W0 r% D5 O" Y. c, ] LHXXDBS01:oraoms> rman target/
* ?- q% B1 ~: y. k2 _2 U2 ]4 P RMAN>list backup;1 ]6 Y" v; c# B8 H6 y
(这呼吁把所有的备份都列出来)
' V' ]7 k& t. f. ?( d 如不美观只提取恢复归档日志,用下面呼吁即可,然后记住那天归档日志的sequence 号:) M' E- z6 M& z, @
RMAN>list backupset of archivelog all; (这呼吁把所有的归档日志列出来)
7 w4 `8 m" `: T8 c) _; J9 F4 q# _5 H Handle: c28138569492008102005 Media:
; P7 Q Q! S7 k2 I' K Control File Included: Ckp SCN: 224711393 Ckp time: 20OCT08
8 B8 x& U, Z% k" h1 J& ? SPFILE Included: Modification time: 20OCT08
! n- X' L+ V5 C+ F( ]; ` F BS Key Size Device Type Elapsed Time Completion Time4 ?7 a" q6 f9 ~9 u% S' b+ i6 V
3306 81.50M SBT_TAPE 00:03:02 20OCT08
3 N5 h t, x$ ~" t6 k BP Key: 3306 Status: AVAILABLE Compressed: NO Tag: TAG20081020T16023
5 v" V" t5 G4 a" ]9 L2 ]( u6 T; v 6# X/ ?3 G) n5 @; `6 H) W1 H
Handle: arch_20081020_9621_1 Media:( X C. x; p, \& {" M
List of Archived Logs in backup set 33067 A, O1 ~4 I# z! P2 ]9 \1 o# f
Thrd Seq Low SCN Low Time Next SCN Next Time
) P/ Q$ J. z. W" O, y( d 1 3440 224711325 20OCT08 224779163 20OCT08
$ G0 M9 d' S/ Q0 E* i M 1 3441 224779163 20OCT08 224779169 20OCT08, d- \ H0 l+ Y8 P/ k8 n3 f% g, ]
BS Key Type LV Size Device Type Elapsed Time Completion Time* V/ l. L2 M4 V4 v# J$ C
3307 Full 5.75M SBT_TAPE 00:01:59 20OCT08, Z2 ~$ Q, }0 E' ]& h8 c A I0 H
BP Key: 3307 Status: AVAILABLE Compressed: NO Tag: TAG20081020T16054
, O9 A. K# N7 B J 3# d5 S6 Y$ J5 C( v
Handle: c28138569492008102006 Media:
# ?: ]( r7 W# l! `0 C Control File Included: Ckp SCN: 224779614 Ckp time: 20OCT08, n6 H I2 F1 a0 I4 \+ I
SPFILE Included: Modification time: 20OCT08
$ ?8 X( q( A) |/ x BS Key Size Device Type Elapsed Time Completion Time
3 e# l* p2 M' b9 h4 n$ e$ r 3308 70.25M SBT_TAPE 00:03:26 20OCT088 \$ b( m5 K9 v
BP Key: 3308 Status: AVAILABLE Compressed: NO Tag: TAG20081020T20052
/ z; W. g6 S+ f/ I9 f% k6 t 9
) X* T* S% G' z Handle: arch_20081020_9623_1 Media:* w; ~( Y! \, f2 u$ J& _$ G
List of Archived Logs in backup set 3308
R% s0 N; ~$ n1 d% I Thrd Seq Low SCN Low Time Next SCN Next Time
) p* [1 ^- _: }3 B0 B: O 1 3442 224779169 20OCT08 224840954 20OCT08
; w& G. q! b, A7 S 1 3443 224840954 20OCT08 224840960 20OCT08
3 U6 \: s5 X# B: b2 Z BS Key Type LV Size Device Type Elapsed Time Completion Time3 i- t8 Z. T% f
3309 Full 5.75M SBT_TAPE 00:02:00 20OCT08
0 _! d! |! r) c7 F) H( Q6 [ BP Key: 3309 Status: AVAILABLE Compressed: NO Tag: TAG20081020T20085
2 M9 h/ _ K2 o2 }: _! q: {3 i 5
# i0 |% U; ?* ^ Handle: c28138569492008102007 Media: E( v0 a1 _0 V0 z
Control File Included: Ckp SCN: 224842089 Ckp time: 20OCT085 u2 ?2 b* P9 l0 k( Q
RMAN> exit |