之前我们介绍了:Oracle数据库RMAN不完全恢复之基于时间恢复,本文我们介绍一下Oracle数据库RMAN不完全恢复的基于SCN恢复的相关知识,希望能够对您有所帮助。/ ~; H/ Y# }% _# b" ]
2 J, x6 O9 }% F# \7 G# s; L( { 1. SQL> select count(*) from t_user; COUNT(*)
$ E7 ^6 ~- P; ]7 T b: q
4 U+ u/ u4 D) ^+ P% f 2. ---------- 2$ C" {# L, ~! X
% Y/ a/ w$ z+ S. ^; D 3. SQL> insert into t_user select 'spring mvc_' from dual; 1 row created., p, y |$ Z" y
& | d1 d; R: s/ q E: v+ s 4. SQL> commit; Commit complete.
& i0 ], R, A( b9 j" N ! ]% ]* _. o3 ^5 I
5. SQL> alter system switch logfile; System altered.7 Q( f( q4 x/ S$ o* E
5 s* h7 i% [7 ?% F2 }" M* e2 i$ p 6. SQL> alter system checkpoint; System altered.
+ o! t* i6 {8 _! U0 u1 @ 4 i6 M% J& n5 n4 c4 x' v9 B
7. SQL> select current_scn from v$database; CURRENT_SCN% l/ `0 H# r5 c5 k, j
) v- S* J. \$ C8 r; v3 V7 V) P 8. ----------- 1214281
: z; | W$ z6 |: l8 ` . {- J# H7 E/ t& ~' s3 f2 F0 C: }
9. SQL> drop table t_user; Table dropped.
' B, z: j( F3 O4 X $ o# \& {$ Z% I) \- a4 m+ O3 {5 [, K
1. [oracle@localhost ~]$ rman target sys/oracle@oralife nocatalog RMAN> run {. W. J4 C0 c+ V3 g3 N9 n$ S, m
- s, Y+ _; _( ^! A% ]0 T6 f 2. 2> startup force mount;( [# X; _8 E' D$ \- Z' ]
& v4 s& I5 A9 b9 u f; } 3. 3> set until scn=1214281;
' ]" L! ]6 @' d/ O& }' @+ M . t' N) D5 e1 Y3 M
4. 4> restore database;
5 }2 n' u! Y, i; E: E& i8 C " j9 c6 h8 W3 s
5. 5> recover database;" R. h% g, b8 D" L& l" ^
- |' i9 f5 s( v/ ^3 ]! r$ A$ b$ b 6. 6> sql 'alter database open resetlogs';
) b" ^! e7 y5 g6 F3 G) P
: _0 V# I8 Y( E' ^ 7. 7> }4 ]9 o8 U' i( e8 `3 d/ P
/ u# F/ I; H" W) ^ 1. SQL> select count(*) from t_user; COUNT(*)9 N b) [; ?# r
, s3 l' F1 U6 Q# q: ^
2. ---------- 3 |