Home » Server Options » Data Guard » Primary database experiencing lag when disconnect from standby (Oracle Database, 10GR2, RHEL)
Primary database experiencing lag when disconnect from standby [message #621010] Thu, 07 August 2014 12:45 Go to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Recently our standby database lost connection to the production server because of connectivity issues. When the log switch occurred there was a degradation of the service. Applications hosted on the database experienced stalling. Any ideas on what may be the issue?

Kieron

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #621013 is a reply to message #621010] Thu, 07 August 2014 13:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Run in "maximum performances" or "maximum availability" mode and not in "maximum protection" one.

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #621014 is a reply to message #621013] Thu, 07 August 2014 13:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Data Guard Concepts and Administration
Chapter 1 Introduction to Oracle Data Guard
Section 1.4 Data Guard Protection Modes

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #621015 is a reply to message #621014] Thu, 07 August 2014 13:22 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Michel,

The database is currently running in MAXIMUM PERFORMANCE mode.

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #621016 is a reply to message #621015] Thu, 07 August 2014 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you have to post more details.
Here we have no information to diagnose.

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #621023 is a reply to message #621010] Thu, 07 August 2014 14:10 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Michel,

Thanks for the response, I am not sure what information you would need in order to help me with my problem. Can you please advise.

Kieron

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #621028 is a reply to message #621023] Thu, 07 August 2014 14:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First have a look at primary alert.log to see any message during the mentioned period.
Then you can query V$DATAGUARD_STATUS to see the messages related to replication.

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624194 is a reply to message #621028] Thu, 18 September 2014 14:32 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Michel,

Sorry about the late response was away from work for a bit. I encountered the following errors in my alert log when the connection to the standby database was lost. Hope it helps

ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (1041)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
PING[ARC0]: Error 1041 when pinging standby standby_database
LGWR: I/O error 3135 archiving log 2 to 'standby_database'

LNS: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'standby_database' (error 3135)

Thanks

Kieron

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624196 is a reply to message #624194] Thu, 18 September 2014 19:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
This issue can't be that important or serious if it existed unresolved for 6 weeks

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624197 is a reply to message #624194] Thu, 18 September 2014 23:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
 

ORA-01041: internal error. hostdef extension doesn't exist
 *Cause: Pointer to hstdef extension in hstdef is null.
 *Action: Report as a bug
ORA-03135: connection lost contact
 *Cause:  1) Server unexpectedly terminated or was forced to terminate.
          2) Server timed out the connection.
 *Action: 1) Check if the server session was terminated.
          2) Check if the timeout parameters are set properly in sqlnet.ora.

Verify LOG_ARCHIVE_DEST_2 value and there is no firewall on your standby database server.

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624322 is a reply to message #624197] Sun, 21 September 2014 12:25 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Michel,

I have verified that there is no firewall between the two servers and the LOG_ARCHIVE_DEST_2, once the two machines can see each other all is well but once there is a loss in connection the production database will encounter a performance hit.

Kieron

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624324 is a reply to message #624322] Sun, 21 September 2014 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So change the value of LOG_ARCHIVE_DEST_2 to handle this case: NET_TIMEOUT, REOPEN, MAX_FAILURE parameters.

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624325 is a reply to message #624324] Sun, 21 September 2014 12:45 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Michel,

Thanks will make some changes and would it be ok to send you my options for review before trying them?

Kieron

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624704 is a reply to message #624325] Wed, 24 September 2014 15:22 Go to previous messageGo to next message
bank_master
Messages: 73
Registered: April 2007
Location: Guyana
Member
Michel,

I have come up with the following configuration settings;

MAX_FAILURE=3 NET_TIMEOUT=15 REOPEN=300

Report message to a moderator

Re: Primary database experiencing lag when disconnect from standby [message #624725 is a reply to message #624704] Thu, 25 September 2014 00:32 Go to previous message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks to let us know.

Report message to a moderator

Previous Topic: Switchover_status is not allowed in standby
Next Topic: Valid objects found invalid in ODS (OLTP & ODS are in SYNC)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Mar 24 11:03:35 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.