Evolution of Oracle Time Machine: FlashBack Essay

901 Words 4 Pages
Evolution of Oracle Time Machine: FlashBack
“It’s gone by mistake”. We human beings are tend to make mistakes. But what happens when this mistake committed by database user. Is there any simple recycle bin concept or simple time travelling concept?? The answer is YES, there is.
Sometimes it’s just simple a query or some data cleansing methods used by the users or data librarians, whatever may the cause be, data-loss is a very common phenomenon. Backup and recovery methods are provided by the Oracle database management systems which ensure the safety of valuable data in case of data loss however, not all data-loss situations can utilize the complete and tedious recovery concepts from the backup. Oracle introduced flashback features from
…show more content…
Evolution of Oracle Time Machine: FlashBack
“It’s gone by mistake”. We human beings are tend to make mistakes. But what happens when this mistake committed by database user. Is there any simple recycle bin concept or simple time travelling concept?? The answer is YES, there is.
Sometimes it’s just simple a query or some data cleansing methods used by the users or data librarians, whatever may the cause be, data-loss is a very common phenomenon. Backup and recovery methods are provided by the Oracle database management systems which ensure the safety of valuable data in case of data loss however, not all data-loss situations can utilize the complete and tedious recovery concepts from the backup. Oracle introduced flashback features from Oracle 9i onwards to address simple data recovery needs.
Oracle time travel concept: Oracle Flashback
Oracle developed a suite named Flashback Technology which enables Oracle application users and database administrators to wind the clock back and examine their database objects and data in a previous state without having to restore using backup media.
Flashback query allows a user to view the data quickly and easily the way it was at a particular time in the past, even when it is modified and committed, be it a single row or the whole table.
What situations call for the use of the flashback feature?
According to the Oracle documentation, Flashback technologies are applicable in repairing the following user errors.
• Intended or

More about Evolution of Oracle Time Machine: FlashBack Essay

Open Document