Database Reference
In-Depth Information
You then used the Flashback Transaction Query to view transactional changes in data.
You saw examples of how you can use this tool to perform transactional analysis, including
producing SQL statements that will undo the transaction.
You used Flashback Table to recover a table to a specific point in time without performing
an incomplete recovery. You also learned how all dependent objects are recovered when using
Flashback Table.
The Flashback Database command is best used to recover from logical corruption and
user error. This is an alternative to incomplete recovery or the Log Miner utility. The
Flashback Database command can be enabled and configured fairly easily. You must have
the fast recovery area enabled to implement Flashback Database.
The last Flashback technology discussed in this chapter was the Flashback Data Archive,
which can be used to track all DML changes to a table and keep the changes for a specific
retention period.
Exam Essentials
Know how to restore dropped tables from the Recycle Bin. Make sure that you understand
how the Recycle Bin handles dropped objects. You should be able to locate objects in the
Recycle Bin. You should be able to perform a Flashback Drop recovery of a dropped object.
Know how to perform a Flashback Query. You must understand how Flashback Query
works. Know which options are available in the AS OF clause (timestamp and SCN). Be able
to execute a Flashback Query and understand what the results represent.
Know how to use Flashback Transaction Query. Know how to use Flashback Transaction
Query to expose transactional information relating to changes in the database. Be sure that
you are familiar with the contents of the FLASHBACK_TRANSACTION_QUERY view. Be able to
access the undo SQL required to roll back a transaction.
Understand how to perform Flashback Table operations. Understand the basics of
how Flashback Table works. Know how to perform a Flashback Table operation with a
timestamp or an SCN. Be aware of how undo data is used in Flashback Table and how
to protect this data.
Understand the Flashback Database architecture. Make sure you are aware of the compo-
nents that make up the Flashback Database architecture. Understand the Flashback Database
logs and RVWR background-process functionality.
Understand how to enable and disable the Flashback Database. Know how to configure
the Flashback Database. Understand the fast recovery area and how it is configured.
Know how to monitor the Flashback Database. Know the dynamic views that monitor
the Flashback Database. Understand what each view contains.
Know how to create and use a Flashback Data Archive. Know the syntax to create a
Flashback Data Archive in a tablespace, alter the storage and retention parameters, purge
and drop, archive a table, and query the results.
Search WWH ::




Custom Search