Flashback feature - Flashback Drop- Oracle Schema

Q.  On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m. and Sunday's backup is the most recent backup. Which flashback feature would you use?
- Published on 28 Jul 15

a. Flashback Drop
b. Flashback Table
c. Flashback Database
d. Flashback Version Query
e. Flashback Transaction Query

ANSWER: Flashback Drop
 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    1. FLASHBACK TRANSACTION QUERY - One of the important new features of Oracle Database 10g.
    - It is a diagnostic tool to view the changes made to the database at the transaction level.
    - This feature will help diagnose problems, analyze and audit transactions, and recover from user or application errors.
    - The undo SQL generated by the flashback transaction query can be used to rollback the changes made by a transaction.

    2. FLASHBACK VERSION QUERY - It provides a mechanism for viewing data as it existed at a particular point in time (a timestamp or SCN).

    3. FLASHBACK DATABASE - This command is used to rewind the database to a target time, SCN, or log sequence number.

    4. FLASHBACK TABLE - This statement is used to restore an earlier state of a table in the event of human or application error.
    - The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system.
    - Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.

    5. FLASHBACK DROP - When you drop a table, the database does not immediately remove the space associated with the table.
    - The database renames the table and places it and any associated objects in a recycle bin, where, in case the table was dropped in error, it can be recovered at a later time.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)