How to Configure Oracle Database to Store Archive Redo Logs into Fast Recovery Area

Step 1 – Enable Archive Log Mode.

How To Enable Archive Log Mode In Oracle Database 19c_梦想家DBA匠人的博客-CSDN博客

Step 2 – Configure the location

[oracle@oracle-db-19c ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 1 14:52:54 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> alter system set log_archive_dest_1 = 'LOCATION=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch';

System altered.

SQL>

On successful execution, your Oracle Database will use the FAST RECOVERY AREA to store your archive redo logs.

Step 3 – Let’s Test

You can check if you have successfully set the Fast Recovery Area for storing your archive redo logs.

Again make sure you are connected with your database using the SYS user. Next, write

SQL> show user;
USER is "SYS"
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch
Oldest online log sequence     125
Next log sequence to archive   127
Current log sequence           127
SQL> 

In this result, if you will look closely, the ARCHIVE DESTINATION is set to USE_DB_RECOVERY_FILE_DEST hence it’s confirmed that the destination of your archive redo logs is set to the Fast Recovery Area.