This course gives an overview of the functionality provided by Flashback technology in Oracle 11g, including the recovery of dropped objects, querying data as it existed at a point in time in the past, and returning the entire database to a point in time or SCN.
Objectives:
Restore dropped tables from the Recycle Bin
Use Flashback Query and Flashback Transaction Query
Perform Flashback Table operations
Configure, monitor, and perform Flashback Database operations
Set up and use a Flashback Data Archive
Topics:
Understanding Flashback Technology
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.