Managing Archive Destination LOG_ARCHIVE_DEST, LOG_ARCHIVE_DEST_n

You can choose whether to archive redo logs to a single destination or multiplex them. The LOG_ARCHIVE_DEST, LOG_ARCHIVE_DEST_n and DB_RECOVERY_FILE_DEST parameter specify where the archived redo log files will be stored.

1)If you want to archive only to a single destination, you specify that destination in the LOG_ARCHIVE_DEST initialization parameter.

2)If you want to multiplex the archived logs, you can choose whether to archive to up to ten locations (using the LOG_ARCHIVE_DEST_n parameters)

3)If you choose to archive only two local location you can choose a primary and a secondary destination (using LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST).

4)Note that, LOG_ARCHIVE_DEST is incompatible with the LOG_ARCHIVE_DEST_n parameters. So you can't set LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_n at the same time. LOG_ARCHIVE_DEST must be defined as the null string ("") or (' ') when any LOG_ARCHIVE_DEST_n parameter has a value other than a null string.

Method 1: Using the LOG_ARCHIVE_DEST Parameter:
---------------------------------------------------
Only set LOG_ARCHIVE_DEST parameter.

Method 2: Using the LOG_ARCHIVE_DEST_n Parameter
---------------------------------------------------
Use the LOG_ARCHIVE_DEST_n parameter (where n is an integer from 1 to 10) to specify from one to ten different destinations for archival. Each numerically suffixed parameter uniquely identifies an individual destination.

Format: LOG_ARCHIVE_DEST_n='{LOCATION|SERVICE} destination'

If you use the LOCATION keyword, specify a valid path name for your operating system.

If you specify SERVICE, the database translates the net service name through the tnsnames.ora file to a connect descriptor.

Like, alter system set log_archive_dest_1= 'LOCATION=/oradata1';
alter session set log_archive_dest_3='LOCATION=/oradata2';


If you set DB_RECOVERY_FILE_DEST then LOG_ARCHIVE_DEST_10 is implicitly set unless LOG_ARCHIVE_DEST_n is specified.

Method 3: Using LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST
------------------------------------------------------------
To specify a maximum of two locations, use the LOG_ARCHIVE_DEST parameter to specify a primary archive destination and the LOG_ARCHIVE_DUPLEX_DEST to specify an optional secondary archive destination.

All locations must be local.

To see archival destination issue,
archive log list and
select DEST_ID, DEST_NAME,DESTINATION from v$archive_dest;
show parameter LOG_ARCHIVE_DEST;

Related Documents
Handle 16018 and 16019 Error
Change database Archive mode