OCM 12c Preparation - Configure the database to retrieve all previous versions of the table rows

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.

So practice here:

• 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)

P.S: 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:

Oracle Database Development Guide -> 16.2 Using Oracle Flashback Technology
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

0