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

MOSC Banner

DG 11gR1: Most recent archive log is being created on standby instead of primary

Hi All,

My DG configuration is as below:

Primary db host: proddb

Primary db init parameters:

*.db_name='PROD'*.db_unique_name='PROD'*.fal_client='PROD'*.fal_server='STANDBY'*.log_archive_config='DG_CONFIG=(PROD,STANDBY)'*.log_archive_dest_1='LOCATION=/oraarch/oracle/archive valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD MANDATORY'*.log_archive_dest_2='service="standby"',' LGWR ASYNC NOAFFIRM delay=0 OPTIONAL compression=DISABLE max_failure=10 max_connections=1 reopen=15 db_unique_name="STANDBY" net_timeout=30 valid_for=(online_logfile,primary_role)'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%s_%t_%r.arc'# Or can just leave as default.*.log_archive_max_processes=30

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