317: Oracle Flashback Features: Alternative Approaches to Traditional Database Recovery
Monica Penshorn , Medtronic    Biography

Objectives: Provide quicker and easier means of performing recovery in response to logical corruption errors
To help ensure that financial loss due to db outages from logical data errors is minimized
To share knowledge and empower DBAs and Developers with additional data recovery tools
Abstract: You've just been told that your most critical data was accidentally deleted from your production database. Can you feel your stomach sink and your heart start beating?!

Flashback features provide DBAs and developers with faster and easier alternatives to retrieving data than traditional time-consuming recovery methods.

Flashback database, flashback drop, flashback table, flashback query, and flashback versions query are the methods reviewed in this presentation. We'll also take a brief look at the 11g Flashback Data Archive option.

Audiernce Focus: Developers
Expertise: Intermediate
Track: Database
Date: Monday, April 14, 2008
Time: 2:15 PM - 3:15 PM