Monday , September 25 2017
Home / Oracle DBA / Oracle FLASHBACK DATABASE

Oracle FLASHBACK DATABASE

FLASHBACK DATABASE

Database must be in archivelog mode and flashback should be enabled for performing this. When placed in flashback mode, we can observe flashback logs getting generated in flash_recovery_area
— Create a dummy table.
CONN scott/tiger
CREATE TABLE flashback_database_test (id  NUMBER(10) );
— Flashback 5 minutes.
CONN sys/password AS SYSDBA
SHUTDOWN IMMEDIATE
STARTUP MOUNT EXCLUSIVE
FLASHBACK DATABASE TO TIMESTAMP SYSDATE-(1/24/12);
ALTER DATABASE OPEN RESETLOGS;
— Check that the table is gone.
CONN scott/tiger
DESC flashback_database_test
We can use following commands also in flashback database
FLASHBACK DATABASE TO TIMESTAMP my_date;
FLASHBACK DATABASE TO BEFORE TIMESTAMP my_date;
FLASHBACK DATABASE TO SCN my_scn;
FLASHBACK DATABASE TO BEFORE SCN my_scn;
View More:
ENTERPRISE MANAGER(EM)
AUTOMATIC WORKLOAD REPOSITORY (AWR) REPORT
ORACLE INSTANCE TUNING WITH REPORTS

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *