Flashback Query is an Oracle feature that allows you to view previous states of data in your database directly from a SQL command using the AS OF TIMESTAMP clause. In this video, learn about how Flashback Query functions, its usage of database UNDO data, and the configuration required to enable support for Flashback Query by setting the UNDO_RETETION parameter.
- [Instructor] Oracle Flashback is a set of technologies…built right into the Oracle database,…with provides us with our very own…personal database time machine.…Using Flashback, we can revert changes…which have been applied to our entire database…or parts of it using a single command.…In order for Oracle Flashback technologies to function,…there are some prerequisites we need to first take care of.…Different Oracle Flashback features…require different prerequisites.…
For Flashback query, which allows us to…perform and run queries that retrieve previous data…from our tables, all within the SQL statement itself.…So for Flashback query, we need to properly configure…our Oracle database undo retention parameter.…This is because Flashback query relies on…the undo table space for it to function.…The undo retention parameter controls…how much time should Oracle hold on to undo data.…
The bigger the value for the parameter,…the longer the time Oracle holds on to your undo data…before discarding it.…But also, potentially, the bigger undo table…
- Complete vs. incomplete recovery
- Point-in-time recovery
- Failure categories
- Preparing the virtual machine
- Performing user-managed backups
- Restoring from manual backups
- Performing full and incremental backups with RMAN
- Recovering a PDB and CDB
- Exporting and importing data with Oracle Data Pump
- Performing logical backups with Data Pump
- Using Flashback Query, Table, and Database
- Creating restore points
Skill Level Intermediate
Oracle 12c Database: Administrationwith David Yahalom3h 58m Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
1. Backup and Recovery Core Concepts
2. Failure Categories and Backup Types
3. Preparing the Course VM
4. User-Managed Backups
5. Recovery Manager (RMAN)
6. Oracle Data Pump
7. Oracle Flashback
What's next?2m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.