Flashback Drop:
Recovering the table for the recycle bin, once a table is dropped it will be stored in recycle bin.Hence recovering the table from recycle bin. To perform flashback the parameter called flashback_on should be enabled and database should be in the archivelog mode
Dropped the table and after the drop it is stored in recycle bin, recovered the table from recycle bin using flashback
If purge command is issued the table is deleted from recycle bin also
Flashback Table
Flashback table is used to recover the table without a backup, this is introduced from oracle 10g, this can be done with the scn and timestamp I did flashback table with the scn. Noted the scn number before inserting records and again noted down the scn after insertion of records and commit
I provided the flashback command to scn before inserting records I got no data with that scn
And then I issued the flashback command with the scn after the insertion of records, I got all the records of the table hence the table is recovered
Flashback Version query:
Flashback version query will give the information about the dml operations in the table, to view what kind of transactions have run on the table by giving min and max value of scn, we will also get the versions_xid for each transaction
Flashback transaction query:
Flashback transaction query will give the query in the undo_sql column of the table flashback_transaction_query this will give us the query of the update operation of a particular record by providing the versions_xid of that particular record
Flashback Database
To perform flashback database we should enable flashback database node, set the DB_FLASHBACK_RETENTION_TARGET initialization parameter and issue the ALTER DATABASE FLASHBACK ON
Flashback database can be done only in mount stage of the database, it can be done with the scn , timestamp by doing this we can get the older state of the database
Posted by:Sakthi Sethu Perumal S
