What is Flash Recovery Area in oracle database and what advantages does it has?
Question is closed for new answers.
meda Changed status to publish 16/07/2022
Flash recovery area, renamed to fast recovery area starting from oracle 12c, is an oracle managed directory, where oracle database server stores archivelog, autobackup, backupset, flashback logs and online logs for backup and recovery purposes.
To configure fast recovery area , we have to set the destination of the ‘Log_archive_dest_1‘ initialization parameter to ‘USE_DB_RECOVERY_FILE_DEST‘.
Example: SQL> alter system set Log_archive_dest_1='Location=USE_DB_RECOVERY_FILE_DEST' scope=both; System altered.
meda Changed status to publish 05/03/2022