Flash Recovery Area
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 =...