Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Flashback Technology


We need to configure the database in the flashback mode in the mount state in oracle 10g.
In oracle 11g, we can configure the database in flashback mode while the database is in open state.

root@venu1> su - oracle
oracle@venu1> export ORACLE_SID=venu
oracle@venu1> sqlplus / as sysdba
SQL> startup
SQL> select name,open_mode,log_mode,flashback_on from v$database;
SQL> select instance_name,status from v$instance;
SQL> conn scott/tiger
scott> select * from tab;
scott> drop table salgrade;
All DDL commands are auto commit.
scott> show recyclebin
scott> flashback table salgrade to before drop;
scott> select * from tab;
scott> conn / as sysdba
SQL> alter database flashback on;
SQL> select flashback_on from v$database;
oracle@venu1> cd /u01/app/oracle/fast_recovery_area/venu/flashback
oracle@venu1 flashback> ls
SQL> select sysdate from dual;
SQL> set time on;
SQL> conn scott/tiger
scott> select * from tab;
scott> drop table emp purge;
scott> show recyclebin;
scott> conn / as sysdba
SQL>set time off;
SQL> shut immediate;
SQL> startup mount
SQL> flashback database to timestamp to_timestamp('09-MAY-2013 18:12:16','dd-mm-yyyy hh24:mi:ss');
SQL> alter database open read only;
SQL> conn scott/tiger
scott> select * from tab;
scott> conn / as sysdba
SQL> shut immediate
SQL> startup mount
SQL> select open_resetlogs from v$database;
SQL> alter database open;
SQL> alter database open resetlogs;

Archivelogs dig from top to bottom.
Flashback logs dig from bottom to top.

Related Posts Plugin for WordPress, Blogger...

Flag Counter