KnowledgeCenters     Oracle KnowledgeCenter     Oracle Courses

---

Oracle Database 12c provides the Flashback technologies to enable databases, tables, and transactions to be flashed back. This allows users to view data from the past and apply that data to the database, if necessary. Oracle offers Flashback Database, Flashback Table, Flashback Query, and Flashback Transaction Query. Flashback Drop can be used to reinstate a dropped table from the recycle bin. This course describes and shows how to use these Flashback technologies. This course is one of a series in the learning path that helps prepare the learner for the Backup and Recovery portion of the Oracle exam 1Z0-063, Oracle Database 12c: Advanced Administration.

---

---

Objectives

Flashback Query, Table, and Transaction Query start the course describe the Flashback technologies available in an Oracle database configure undo retention use Flashback Query and Flashback Version Query describe the Flashback Table feature use Flashback Table to reverse a rogue transaction describe the Flashback Transaction Query feature use the Flashback Transaction Query feature describe Flashback Drop and how the recycle bin works flash back a dropped table Flashback Data Archives and Temporal Data create temporal history and enable archiving describe how Flashback Data Archive works describe transparent and full schema evolution with Flashback Data Archive use the period for clause to use temporal validity and history in a table filter on valid-time columns Use Flashback Database describe the Flashback Database configure the Flashback Database feature flash back a database describe the considerations for using Flashback Database monitor Flashback Database information create a restore point to use with Flashback Database describe the best practices for using Flashback Database Practice: Performing Oracle Flashback use the different Flashback Technologies in a given scenario