探索ORACLE不完全恢复之--基于时间恢复

作者：吴伟龙   Name：Prodence Woo

QQ：286507175  msn:hapy-wuweilong@hotmail.com

基于SCN恢复 第一篇

1、在删除数据之前，察看下SCN号是多少：

SQL> col name format a45

SQL> set line 300

SQL> select name,checkpoint_change# from v$datafile_header;

NAME                                         CHECKPOINT_CHANGE#

---------------------------

/DBBak2/oradata/WWL/system01.dbf                         1487389

/DBBak2/oradata/WWL/undotbs01.dbf                        1487389

/DBBak2/oradata/WWL/sysaux01.dbf                         1487389

/DBBak2/oradata/WWL/users01.dbf                          1487389

/DBBak2/oradata/WWL/wwl01.dbf                            1487389

/DBBak2/oradata/WWL/wwl02.dbf                            1487389

/DBBak2/oradata/WWL/wwl03.dbf                            1487389

7 rows selected.

SQL> select file#,checkpoint_change#from v$datafile;

    FILE# CHECKPOINT_CHANGE#

---------- ------------------

        1            1487389