Re: dataguard parms

From: Lyall personal <lyallbarbour_at_sanfranmail.com>
Date: Wed, 08 Apr 2015 11:45:30 -0400
Message-ID: <20150408154530.6033555.92338.25523_at_sanfranmail.com>

I feel like the first quote is in the wrong spot for log_archive_dest_9 and 2.

Sent from my BlackBerry 10 smartphone.
  Original Message  
From: Howard Latham
Sent: Wednesday, April 8, 2015 10:59 AM
To: ORACLE-L
Reply To: howard.latham_at_gmail.com
Subject: dataguard parms

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 08 2015 - 17:45:30 CEST