Rac/Dataguard archive logs local multiplexing
I set up a test RAC/dataguard environment with a Primary Database and a Physical Standby database which is functioning with the following log_archive_dest_% parameters defined:
log_archive_dest_1=LOCATION=USE_DB_RECOVERY_FILE_DEST
log_archive_dest_2=service="pristd", LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="pristd" net_timeout=30, valid_for=(all_logfiles,primary_role)
Above, we have the local_archive_dest_1 for the local archiving on the primary database pointing to the defined flashback recovery area. From what we read in the Oracle Data Guard 11g Handbook (Oracle Press) it is recommended, we believe, to have the local archiving defined as above to point to the defined flashback recovery area.