Oracle Flashback Database allows you to restore your entire database to a previous point in time using a single command, rolling back any changes that were performed after the selected timestamp. In this video, learn how to use the FLASHBACK DATABASE TO TIMESTAMP command to revert changes that were done to your database and restore your database and its data to a previous point in time.
- [Instructor] The most famous feature of…Oracle Flashback Technologies is the ability to Flashback…an entire database to a previous point in time…using a single command, and without having to worry about…using external backup files or utilities.…Essentially, Flashback Database is like your own…personal database time machine.…Using Flashback Database, we can choose to restore our…database to a specific point in time in the past…using either a timestamp value, in Oracle SCN or…system change number value, or a log sequence number.…
Let's see an example of using Flashback Database with…a timestamp value.…We'll start by opening a SQLplus connection…to our Oracle instance root container.…So we'll type sqlplus -/as sysdba.…We will also switch our session to the demo_pdb,…pluggable database, which we have created earlier…in our course.…So I'll type alter session set container=demo_pdb;.…
Before using Flashback Database, let's verify that we…have data in our employee's table.…This is the table we have created in our previous video.…
- 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.