High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Rac/Dataguard archive logs local multiplexing

 Hello,

     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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center