闪回技术之闪回数据库

SQL> select flashback_on from v$database;

FLASHBACK_ON

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

NO

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database flashback on;

SQL> alter database open;

[oracle@localhost ~]$ cd /dat/DBSoftware/oracle/flash_recovery_area/NACEC/----可以看到FRA中多处了闪回日志，闪回日志只能放在此地。System表空间中的对象不能闪回，包括闪回drop

SQL> conn test/test

SQL> select table_name from dba_tables where owner='TEST';

TABLE_NAME

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

MYTEST

SQL> SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL;

GET_SYSTEM_CHANGE_NUMBER

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

                 1227661

SQL> shutdown immediate;

SQL> startup;

SQL> SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER FROM DUAL;

GET_SYSTEM_CHANGE_NUMBER

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

                 1227982

SQL> conn test/test

Connected.

SQL> drop table mytest;

Table dropped.

SQL> conn / as sysdba

Connected.

SQL> shutdown immediate;

SQL> startup mount;

SQL> flashback database to scn 1227661;

Flashback complete.

SQL> alter database open resetlogs;相当于不完全恢复

Database altered.

SQL> conn test/test

SQL> select * from mytest;

NAME

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

freas

tangtang

由此，可以看到，表恢复回来了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31448824/viewspace-2137528/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31448824/viewspace-2137528/