What is Flash Recovery Area in oracle database and what advantages does it has?
Auto Amazon Links: No products found.
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.
Auto Amazon Links: No products found.