Re: dataguard parms

  • From: Ls Cheng <exriscer@xxxxxxxxx>
  • To: Howard Latham <howard.latham@xxxxxxxxx>
  • Date: Wed, 8 Apr 2015 18:05:24 +0200

Hi

Is the current primary AUXPRODSTBY or auxstby?

FAL_CLIENT is not need in 11g,
http://docs.oracle.com/cd/E11882_01/server.112/e41134/whatsnew.htm#SBYDB5107

Thanks


On Wed, Apr 8, 2015 at 4:57 PM, Howard Latham <howard.latham@xxxxxxxxx>
wrote:

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
--
//www.freelists.org/webpage/oracle-l



Other related posts: