The Flash Recovery Area (FRA) in Oracle 19c is a disk space location that Oracle uses to store recovery-related files. It’s defined by the DB_RECOVERY_FILE_DEST parameter and its size is set by DB_RECOVERY_FILE_DEST_SIZE. FRA can store files like online redo logs, archived redo logs, control file auto backups, and more. Oracle recommends that the FRA be located on a separate storage device from the database files.
ArchiveLog Mode, on the other hand, is a mode that you can set for your Oracle database that allows the archiving of the redo log. When a database is in ArchiveLog mode, completed redo log files are copied to a designated storage device before they’re reused. This provides a safety net, as these archived redo logs can be used to recover the database to any point in time. ArchiveLog Mode is shown in the v$database view.
Check our previous post Archive Log Mode Configuration for more comprehensive details.
SQL> select log_mode from v$database; LOG_MODE ------------ NOARCHIVELOG
Before enabling the ArchiveLog mode, the database must be in mount state. Then enable the ArchiveLog mode and open the database.
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Database mounted. SQL> ALTER DATABASE archivelog; Database altered. SQL> ALTER DATABASE OPEN; Database altered. SQL> select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG SQL> ARCHIVE LOG LIST; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 36 Next log sequence to archive 38 Current log sequence 38 SQL>
As shown, then archive destination is configure by the parameter DB_RECOVERY_FILE_DEST
SQL> SHOW PARAMETER DB_RECOVERY_FILE_DEST NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /u02/oracle/ORCL/fra db_recovery_file_dest_size big integer 10G SQL>
To change the location and size of the FRA modify the db_recovery_file_dest parameters.
SQL> ALTER SYSTEM SET db_recovery_file_dest_size=5G; System altered. SQL> ALTER SYSTEM SET db_recovery_file_dest = '/u02/oracle/ORCL/fra'; System altered.
The message ORA-16019 will be raised in case that the log_archive_dest is configured. So it should be disable first.
SQL> ALTER SYSTEM SET db_recovery_file_dest = '/u02/oracle/ORCL/fra'; ALTER SYSTEM SET db_recovery_file_dest = '/u02/oracle/ORCL/fra' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST SQL> ALTER SYSTEM SET log_archive_dest = '';
EXCEL 2023: The Beginners Guide to Master Microsoft Excel from Scratch in Less than 7 Min. a Day. Discover all the Function & Formulas with Step-by-Step Tutorials with Simple & Real-Life Examples
$24.81 (as of December 20, 2024 21:38 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Learn SQL in less than 20 hours: Understand the Language and Do It Yourself
$9.99 (as of December 20, 2024 21:38 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Oracle Procure-to-Pay Guide (Oracle Press)
$39.07 (as of December 20, 2024 21:38 GMT +00:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)