Re: dataguard parms

From: Michael Cunningham <napacunningham_at_gmail.com>
Date: Wed, 8 Apr 2015 09:58:00 -0700
Message-ID: <CAPt39ts5SzSGF4G_--08QDEsaCQLh8TkgNZXakeNEDHudKNJyg_at_mail.gmail.com>

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

-- 
Michael Cunningham

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

Received on Wed Apr 08 2015 - 18:58:00 CEST