Flash Recovery Area

Flash Recovery Area
  • 9
    Dic

Flash Recovery Area

twittergoogle_pluslinkedin

Flash recovery area is an Oracle managed directory, file system, or Automatic Storage Management that

provide a centralized disk location for backup and recovery files.

It was introduced from Oracle 10g

What is in it?

 A copy of all datafiles;

 Incremental backups;

 Online redo logs;

 Archived redo logs;

 Controlfiles;

 Copies of the control file and spfile.

Which benefit?

– Ability to flashback the database;

– Quick recovery from backups stored on disk;

– Automate management of recovery related files.

How to enable it?

SQL> ALTER DATABASE FLASHBACK ON;

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 2G ;

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ‘/ORACLE/DB/RECOVERY_AREA’ ;