Flashback Technologies in Oracle Database: Features & Use Cases
Discover the features and advanced use cases of Oracle's Flashback Technologies, including Flashback Query, Flashback Table, and more. Learn how Flashback is integrated into Oracle Recovery Manager (RMAN) and Oracle Data Guard for enhanced data recovery and management capabilities.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Oracle 12R2 Oracle 12R2 Database nologies nologies Hariprasath Hariprasath Rajaram Database Flashback Flashback Tech Tech Rajaram
T Todays oday s A Agenda genda
F Flashback lashback T Technologies echnologies T Transformation e e V V9 9 Flashback Query using AS OF scn/timestamp Session Level Flashback using dbms_flashback Statement Level Flashback using AS OF clause ransformation S Sinc inc Flashback Transaction Flashback Data Archive (Total Recall) Flashback Standby Database Flashback Version Query Flashback Transaction Query Flashback Table Flashback Drop Flashback Database Multitenant : Flashback Pluggable Database (PDB) Temporal Validity
F Flashback lashback A Architecture rchitecture O Overview verview
Flashback Technologies Features Flashback Query Flashback Table Flashback Drop Flashback Versions Query Flashback Transaction Query Flashback Query Functions Flashback Database Flashback Data Archive Flashback Pluggable Database (PDB) Temporal Validity
F Flashback lashback A Advanced dvanced u use se c cases ases Flashback technology is integrated into Oracle Recovery Manager (RMAN) and Oracle Data Guard. So, apart from the basic use cases mentioned above, the following use cases are addressed using Oracle Flashback. Block Media recovery by RMAN - to perform block level recovery Snapshot Standby - where the standby is temporarily converted to a read/write environment for testing, backup, or migration purposes Re-instate old primary in a Data Guard environment this avoids the need to restore an old backup and perform a recovery to make it a new standby. Guaranteed Restore Points - to bring back the entire database to an older point-in-time in a guaranteed way.
F Flashback lashback A Architecture Type Name rchitecture O Overview Purpose verview Example Scenario Investigat ion/ Correctio n Flashback Query To query a table for a value at one previous point in time verify the value alter batch update Repla ce the latest value of a column will a value as of 10AM Investigat ion Flashback Versi on Query To query the changes that occurred in a ta ble UNDO between t wo points in time Monitor stock inventory quantity changes during the past day Obtain the transaction that changed the value Investigat ion Flashback Transaction Que ry To query the details of the transaction To determine who initiated the transaction and the values affected
F Flashback lashback A Architecture rchitecture O Overview verview Type Correctio n Name Purpose To rewind the table cont ent to a point in time Example Scenario A few rogue update statements inco rrectly updated multiple rows in the table. Those updates need to be reversed User accidentally dropped a table th at needs to be restored Flashback Table Correctio n Flashback Drop Undelete a dropped obj ect Correctio n Flashback Transa ction Reverse a transaction To reverse a transaction that updated a few tables CDP Flashback Datab ase Rewind the entire datab ase to a previous point in ti me User truncated a few important tabl es that need to be restored
