dataguard parms

From: Howard Latham <howard.latham_at_gmail.com>
Date: Wed, 8 Apr 2015 15:57:25 +0100
Message-ID: <CAPCNhx1YccQm7gX=k9Ssez6Lh6HGSyXr1LnCeQCxMfJd932F5g_at_mail.gmail.com>

Just back from holiday and my dataguard is broken. Can some kind soul look at these tell whats wrong?
THE PROBLEM IS THE STANDBY JUST WAITS AND WAITS WITH NO ATTEMPTS AT FETCHING LOGS.
11g rh enterprise

primary
 log_archive_config='dg_config=(auxstby,AUXPRODSTBY)';

fal_client                           string      AUXPRODSTBY
fal_server                           string      auxstby

DEST_9=SERVICE='AUXPRODSTBY ASYNC
valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=AUXPRODSTBY'

                                                 )

STANDBY

fal_server='AUXPRODSTBY';
fal_client='auxstby'
log_archive_config='DG_CONFIG=(AUXPRODSTBY,auxstby)'
log_archive_dest_2                   string      SERVICE=auxstby

VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=aux OPTIONAL LGWR

                                                  ASYNC=102400

REOPEN=30 MAX_FAILURE=5 NET_TIMEOUT=10
--

Howard A. Latham
--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 08 2015 - 16:57:25 CEST