Evolution of Oracle Time Machine FlashBack Essay - 901 Words

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†¦Changes made to the database which includes user data and data dictionary are recorded in the Oracle redo log files. This redo log file plays a critical role during database recovery. Oracle Log Miner enables to query the contents of the redo log files with the help of the SQL interface. Oracle9i: Flashback Query wan first introduced in Oracle 9i. It enables the user to view the database as it existed at a point in time in the recent past using DBMS_FLASHBACK package .This functionality was enhanced from Oracle 9i release 2 onwards with the addition of the AS OF TIMESTAMP clause to the SELECT statement. Oracle10g: Two major improvements has been made in the backup and recovery areas in Oracle 10g.If there is a logical corruptions occur in the database ,oracle flashback technology provides fast and flexible data recovery. Some of the extended features includes -FlashBack database (One of the fastest way to bring back the database to a prior point in time without restoring from the backup.),Flashback Stand By Database, Flashback Drop (user can restore table that were dropped accidentally),Flashback Table(User can recover a table without restoring it from backup),Flashback Row History, Flashback Transaction History(User can audit and diagnose database transactions),User can issue ALTER DATABASE BEGIN BACKUP and END BACKUP statements when the database is open. Oracle11g: With Oracle Database 11g, we have a new option available, called Total RecallShow MoreRelatedCase Infosys13356 Words   |  54 Pagesinformation technology consulting that shortened the lifecycle from business consulting to technology implementation, reduced the costs of a typical client engagement and delivered measurable benefits to clients. FLASHBACK TO APRIL 2004: THE INCEPTION OF INFOSYS CONSULTING The evolution of global Information Technology (IT) service companies in India began in the 1990s with the procurement of application development and maintenance services by American companies. Business Process Outsourcing (BPO)Read MoreCrossing the Chasm76808 Words   |  308 PagesGetting Beyond the Chasm About the Author Credits About the Publisher Front Cover Preface to the Revised Edition â€Å"Obiwan Kenobi,† says Sir Alec Guinness in the original Star Wars movie— â€Å"Now there’s a name I haven’t heard for a long, long time.† The same might well be said of a number of the companies that served as examples in the original edition of Crossing the Chasm. Reading through its index brings to mind the medieval lament, â€Å"Where are the snows of yesteryear?† Where indeed are