Overview/Description
To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if necessary, using Oracle Database 11g's flashback features.
Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.
Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Supporting RMAN and Using Flashback Technology
recognize the steps for monitoring RMAN.
recognize the benefits of RMAN backup and restore operations in terms of performing RMAN tuning operations, such as multiplexing.
identify the steps for performing RMAN tuning operations.
recognize the steps for enabling flashback features and for using the recycle bin in Oracle Database 11g.
recognize the steps for using flashback to query data, retrieve versions of rows, view changes made at the transaction level, and reverse a transaction.
use flashback to reverse a transaction in a given scenario.
recognize the steps for recovering a set of tables or an entire database to a specific point in time, using Flashback Tables and Flashback Database.
identify the steps for using guaranteed restore points, for monitoring Flashback Database, and for tracking and archiving data with Flashback Data Archive.