From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Flashback Database requirements

Flashback Database requirements - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Flashback Database requirements

“

- [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…

Contents