Configure the database to retrieve all previous versions of the table rows

Go back to OCM 12c Preparation Project 

Hands On Lab – Index

[1] Flashback Query (SELECT AS OF)
[2] Flashback Version Query (VERSION BETWEEN)
[3] Flashback Table
[4] Flashback Drop (Recycle Bin)
[5] Flashback Transaction Query (FLASHBACK_TRANSACTION_QUERY)
[6] Table Point in Time Recovery
[7] Flashback Data Archive (Specially 12c new features, take a look in this article)
[8] 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 (12.1.0.1), Flashback Data Archive (FDA) is not supported in a CDB.

For Oracle Database 12c Release 1 (12.1.0.2), 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:
======================
Application Development
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 🙂