DG 11gR1: Most recent archive log is being created on standby instead of primary
edited May 3, 2012 3:25PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
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=300