Re: dataguard parms

  • From: Lyall personal <lyallbarbour@xxxxxxxxxxxxxxx>
  • To: howard.latham@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 08 Apr 2015 11:45:30 -0400

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


--
//www.freelists.org/webpage/oracle-l


Other related posts: