Go back to OCM 12c Preparation Project
Hands On Lab – Index
 Flashback Query (SELECT AS OF)
 Flashback Version Query (VERSION BETWEEN)
 Flashback Table
 Flashback Drop (Recycle Bin)
 Flashback Transaction Query (FLASHBACK_TRANSACTION_QUERY)
 Table Point in Time Recovery
 Flashback Data Archive (Specially 12c new features, take a look in this article)
 In-Database Archiving (as mentioned in the comments also deserves attention)
So practice here: Perform various recovery scenarios using Flashback Technology
For OCM11g, this topic was written as Perform various recovery operations using Flashback technology but it’s pretty the same thing.
Here, you must be able and focus in all possible ways to get back the rows of a table in all possible scenarios.
We usually think on flashback technology but in 12c we also have the new Table Point In Time Recovery which is a very interesting way of recovering the rows specially if you don’t have flashback enabled or if the lines were removed a long time back.
These Oracle Flashback Technology features are unavailable for a multitenant container database (CDB) in 12.1:
For Oracle Database 12c Release 1 (220.127.116.11), Flashback Data Archive (FDA) is not supported in a CDB.
For Oracle Database 12c Release 1 (18.104.22.168), this restriction is removed.
Flashback Transaction Query is not supported in a CDB.
Flashback Transaction Backout is not supported in a CDB.
Path to Documentation:
Database Development Guide
Part IV Advanced Topics for Application Developers
16 Using Oracle Flashback Technology
Using Flashback Data Archive
There are other ways to find previous versions (flashback query, restore table, etc)
Oracle Database Backup and Recovery User’s Guide -> 22 Recovering Tables and Table Partitions from RMAN Backups
Oracle Database VLDB and Partitioning Guide -> Using In-Database Archiving
Thank you for visiting this blog 🙂