之前我们介绍了:Oracle数据库RMAN不完全恢复之基于时间恢复,本文我们介绍一下Oracle数据库RMAN不完全恢复的基于SCN恢复的相关知识,希望能够对您有所帮助。
# {& S$ K) x* H
6 \$ l. J4 w3 Z* z 1. SQL> select count(*) from t_user; COUNT(*)
+ e) `% a. G& ?1 y: } Y2 n 8 K* i8 c- `. h( j o4 Y
2. ---------- 2
# A3 X, H& H: Q; U. x ) B4 e2 G: t( t6 [$ j, ~
3. SQL> insert into t_user select 'spring mvc_' from dual; 1 row created.
]4 s, f/ S& A * q( k8 }- V5 {. r
4. SQL> commit; Commit complete.6 H* \, x2 O0 z! ~2 X9 g" J) w( Q3 x
4 [# S4 k1 L( @ 5. SQL> alter system switch logfile; System altered.
, Y/ [* r$ ]3 l' A6 J6 o, W
* g" v$ p+ ?9 b9 q& A6 i 6. SQL> alter system checkpoint; System altered.9 k$ {# B7 Q, `: y, R
4 M6 |7 X' O6 @8 W& \
7. SQL> select current_scn from v$database; CURRENT_SCN& a7 `: }" h7 A( e; c; M
) B: \8 O7 P& u, [ 8. ----------- 1214281
& b( a9 ^/ c+ { V& g& E; h
. ~8 w- g* H4 R& X5 j 9. SQL> drop table t_user; Table dropped.
1 e3 L& `# r9 v# Z 8 x6 w' K- y. S
1. [oracle@localhost ~]$ rman target sys/oracle@oralife nocatalog RMAN> run {
4 [! w# @" q; d/ h
1 S1 M9 Y5 a8 V. W O+ u 2. 2> startup force mount;
4 R2 \! n Z: Z% o; K
$ _" }: q) s, \% M 3. 3> set until scn=1214281;
! d! D [' P: m* P6 G; u ; F; c* h% {" H, S, B" ^9 y0 d s
4. 4> restore database;, y* v+ a; `- @/ L2 }1 I* [7 x
7 {" X! d$ H+ z% S 5. 5> recover database;
* A1 O9 f# e# _
, h0 E9 ^5 r' e1 @: J$ k" {9 T 6. 6> sql 'alter database open resetlogs';3 t; z4 e q( k
) m& i8 {6 q# e# Q+ q 7. 7> }; {2 p- V3 P( s
$ q; K& {* n2 y+ y6 A6 M: b' J1 C 1. SQL> select count(*) from t_user; COUNT(*)
" [( M! p1 G0 |; x u( J$ s
2 I/ \" \3 `' N! C! Y 2. ---------- 3 |