O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Flashback database

Oracle Flashback Database is a feature introduced in Oracle 9i and heavily improved in Oracle 10g that gives you the ability to rewind your entire database to a specific point in time without the need to restore from your backups. Of course, the database flashback and the ARCHIVELOG mode needs to be enabled to allow you to perform a Flashback Database operation.

You can easily check if Flashback Database is enabled in your database by using the following statement via SQL*Plus:

SQL> SELECT flashback_on FROM v$database; 

FLASHBACK_ON
------------------
YES

To enable Flashback Database, please follow these easy steps in SQL*Plus:

  1. Ensure that your database is running in the ARCHIVELOG mode.
  2. Configure the Fast Recovery Area (FRA) by ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required