RMAN不完全恢复之SCN恢复
之前我们介绍了:Oracle数据库RMAN不完全恢复之基于时间恢复,本文我们介绍一下Oracle数据库RMAN不完全恢复的基于SCN恢复的相关知识,希望能够对您有所帮助。1.SQL> select count(*) from t_user; COUNT(*)
2.---------- 2
3. SQL> insert into t_user select 'spring mvc_' from dual; 1 row created.
4. SQL> commit; Commit complete.
5. SQL> alter system switch logfile; System altered.
6. SQL> alter system checkpoint; System altered.
7. SQL> select current_scn from v$database; CURRENT_SCN
8. ----------- 1214281
9. SQL> drop table t_user; Table dropped.
1. $ rman target sys/oracle@oralife nocatalog RMAN> run {
2. 2> startup force mount;
3. 3> set until scn=1214281;
4. 4> restore database;
5. 5> recover database;
6. 6> sql 'alter database open resetlogs';
7. 7> }
1. SQL> select count(*) from t_user; COUNT(*)
2.---------- 3
页:
[1]