Flashback Database provides the capabilities to restore your entire database to a previous point in time using a single command and without having to use external backups.
- [Instructor] Unlike flashback query,…which relies on the oracle and tablespace…to keep track of database changes,…and allows us to retrieve previous data…using SQL commands, flashback database allows us…to restore our entire database, or individual tables,…to a previous point in time, using special commands.…In order for flashback database to function,…it needs it's own dedicated storage, allocated.…It does not use the oracle undo tablespace,…but instead, generates a set of flashback logs,…which are files, that record changes…done to the oracle database, as they occur.…
These continuous copies of changed oracle blocks,…allows flashback database to restore our database,…to any previous point in time,…within a pre-configured window.…To enable the flashback database feature,…we first have to shut down our oracle instance,…note, the entire instance not just an individual PDB,…and restart it in mount mode.…So let's exit our SQL plus session,…and remember that if you're using…the oracle supplied virtual machine in this course,…
- 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.