Differences between log_archive_dest and log_archive_dest_n

1. log_archive_dest.
You can use the log_archive_dest parameter to set up to two archive paths. You can use log_archive_dest to set a master archive path and use the log_archive_duplex_dest parameter to set a slave archive path. All paths must be local. The format of this parameter is as follows:

Log_archive_dest = '/disk1/archive'
Log_archive_duplex_dest = '/disk2/archive'

 

2. log_archive_dest_n
The log_archive_dest_n parameter can be set to a maximum of 10 different archiving paths. By setting the keyword location or service, the path to which this parameter points can be local or remote.

Log_archive_dest_1 = 'location =/disk1/archive'
Log_archive_dest_2 = 'location =/disk2/archive'
Log_archive_dest_3 = 'location =/disk3/archive'

To archive the file to a remote standby database, you can set the service:
Log_archive_dest_4 = 'service = standby1'

It can be seen that the archive path can be set for both parameters. The difference is that the latter can be set to remotely archive to the standby end, while the former can only be archived to the local end, you can archive the file to a maximum of two paths at the same time.