11g 新特性之flashback PPT课件.ppt

Flashback Technology, LogMiner, and Data Pump Enhancements Objectives After completing this lesson, you should be able to: Use Flashback Data Archive to create, protect, and use history data Prepare your database Create, change, and drop a flashback data archive View flashback data archive metadata Use Flashback Transaction Backout Set up Flashback Transaction prerequisites Query transactions with and without dependencies Choose backout options and flash back transactions Use Enterprise Manager LogMiner Use Data Pump legacy mode Flashback Data Archive: Overview Transparently tracks historical changes to all Oracle data in a highly secure and efficient manner: “Secure” No possibility to modify historical data Retained according to your specifications Automatically purged based on your retention policy “Efficient” Special kernel optimizations to minimize performance overhead of capturing historical data Stored in compressed form in tablespaces to minimize storage requirements Completely transparent to applications Easy to set up Flashback Data Archive: Overview Flashback Data Archive: Architecture Preparing Your Database Create one or more tablespaces for data archives and grant QUOTA on the tablespaces. Grant the FLASHBACK ARCHIVE ADMINISTER system privilege to create and maintain flashback archives to the archive administrator. Grant the FLASHBACK ARCHIVE object privilege (to enable history tracking for specific tables in the given flashback archives) to the archive user. Grant FLASHBACK and SELECT privileges to query specific objects as necessary. Preparing Your Database Configuring undo: Create an undo tablespace (default: automatically extensible tablespace) Enable Automatic Undo Management (11g default) Understand automatic tuning of undo: Fixed-size tablespace: Automatic tuning for best retention Automatically extensible undo tablespace: Automatic tuning for longest-running query Recommendation for Flashback: Fixed-size undo tablespace Flashback Data Archive: