Chapter 6. Recovering from User Errors
ORACLE DATABASE 10G: ADMINISTRATION II EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Recover a dropped table using Flashback Technology.
Perform Flashback Table operation.
Manage the recycle bin.
Recover from user errors using Flashback versions Query.
Perform transaction level recovery using Flashback Transaction query.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
This chapter provides a detailed explanation and walkthrough of the new Oracle Database 10g (Oracle 10g) Flashback Technologies:
Flashback Drop
Flashback Versions Query
Flashback Transaction Query
Flashback Table
We will discuss and use the Recycle Bin to support these Flashback Technologies.
The Flashback Query was first introduced in Oracle 9i and is the foundation for the Oracle 10g Flashback Technologies. You will walk through examples of best practices of using each of these technologies. Additionally, you will use Enterprise Manager (EM) to perform Flashback Table recovery.
This chapter will focus on the workings of these Flashback Technologies. The overview of the Flashback Technologies will explain the architecture at a high level. This includes the Recycle Bin, which is a prerequisite to the Flashback Technologies. This will also include setup, configuration, and in which situations you should use each of the Flashback Technologies. You will see demonstrations and step-by-step examples performing each of these activities.