When you switched the destination of FRA to another storage, you don't have to change the archived log destination. More ConsiderationsĪn advantage of USE_DB_RECOVERY_FILE_DEST is worth noting here. That's how we set USE_DB_RECOVERY_FILE_DEST for archived log destination. SQL> archive log list Īrchive destination USE_DB_RECOVERY_FILE_DEST Later on, both of above ways return the following information about archived log. Log_archive_dest_1 string location=USE_DB_RECOVERY_FILE_ For example, LOG_ARCHIVE_DEST_1 like below: SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'

You can specify any one of LOG_ARCHIVE_DEST_ n to USE_DB_RECOVERY_FILE_DEST explicitly. Explicit Setting of USE_DB_RECOVERY_FILE_DEST Here's the mechanism, if you have configured Fast Recovery Area (FRA) well and do not specify any local archive destinations, the database automatically selects FRA as a local archive destination. As a result, the database will implicitly set archived log destination to USE_DB_RECOVERY_FILE_DEST which is kind of a pointer that indicates database to use Fast Recovery Area (i.e.

SQL> alter system reset log_archive_dest_1 scope=spfile ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported SQL> alter system reset log_archive_dest_1 scope=both Īlter system reset log_archive_dest_1 scope=both Please note that, you cannot reset this parameter with SCOPE=BOTH. You can null out the original value of archived log destination within SPFILE scope. Suppose that the original destination of archived logs is at the default location like this: SQL> archive log list Īrchive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Implicit Setting of USE_DB_RECOVERY_FILE_DEST Then you are ready to set archived log destination to USE_DB_RECOVERY_FILE_DEST by following approaches. You can also regard it as a pointer which points to the real path of FRA.īefore you point the archived log destination to FRA, you have to enable Fast Recovery Area (FRA) by setting the following two initialization parameters:

What is USE_DB_RECOVERY_FILE_DEST? The keyword is a constant value which indicates that we would like to use Fast Recovery Area (FRA) space as the destination for storing online archived logs in ARCHIVELOG mode.

Alter system db recovery file dest size