Oracle Flashback
Oracle Flashback Technology is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. Flashback feature was introduced in Oracle9i; it was limited to Flashback Query only Great improvements have been made in the Flashback functions in Oracle Database 10g. Flashback functionalities provide fast and flexible data recovery TYPES OF FLASHBACK :- 1. flashback query ---we can show only the past state of the table 2. flashback version query ---show the the table transaction time and scn 3. flashback transaction query ---it show what operation is done and which user is performed 4. flashback table --- to flash back a table to an earlier scn or timestamp 5. flashback drop --- flashback table to before drop using recylebin 6. flashback database --- to flash back a table to an earlier scn
Comments
Post a Comment