Howard, do you know if there was a network problem between the primary and
standby while you were on Holiday? The reason I'm asking is because when I
have seen errors such as PING[ARC2]: Heartbeat failed to connect to standby
I have tried two things.
-- On Primary
alter system set log_archive_dest_state_9='DEFER';
alter system set log_archive_dest_state_9='ENABLE';
Sometimes I have had this work. I don't know what I would call it, but it's
as if it performs a reconnect to the standby.
The other thing I have done is to find the process id of the ARC2 process
and kill it. Oracle will restart the process once it realizes it is not
running. This has also been required in my environment. I have done this on
production primary standby databases.
If you kill the process you will see something like the following in the
alert log.
ARC1: STARTING ARCH PROCESSES COMPLETE
Michael
On Wed, Apr 8, 2015 at 9:05 AM, Ls Cheng <exriscer@xxxxxxxxx> wrote:
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
