OCM 11g Preparation - Perform various recovery operations using Flashback technology

This topic is big. Oracle has a lot of flashback technologies and the world "various" here means "all".

We have flashback table / transaction / database, and each of those has a lot of features. If your brain is not capable of memorizing all those syntax, do like me: understand very well the concepts, practice all and just keep in mind the path to the documentation so you can easily adapt some come during the exam.

Practice:

  • Database
    • Creating restore point and flashbacking
    • Flashbacking to a SCN or TIME
  • Table
    • Flashback Query (SELECT AS OF)
    • Flashback Version Query (VERSION BETWEEN)
    • Flashback Drop (Recycle Bin)
  • Transaction
    • Enable supplemental logging
    • Flashback Transaction Query (FLASHBACK_TRANSACTION_QUERY)
    • DBMS_FLASHBACK
    • Flashback using OEM 11g (easier than querying tables)
  • Flashback Data Archive (Oracle Total Recall)
  • Flashback Operations on Specific LOB Columns

Path to Documentation:

Advanced Application Developer's Guide -> 12 Using Oracle Flashback Technology


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.