Home » Infrastructure » Unix » Oracle Data Guard Standby Database (9.2.8)
Oracle Data Guard Standby Database [message #571123] Wed, 21 November 2012 06:03 Go to next message
swagle
Messages: 3
Registered: November 2012
Location: ktm
Junior Member
I have one primary database and one remote standby database.I have configured archive_log_dest as mandatory for local location and optional for remote standby server.But,I am having problem in log switch when remote stanby database link is intrupted.However,there is no problem while shuttig down standby database.
Re: Oracle Data Guard Standby Database [message #571128 is a reply to message #571123] Wed, 21 November 2012 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which problem? He you don't tell us we can't help you.

Regards
Michel
Re: Oracle Data Guard Standby Database [message #571135 is a reply to message #571128] Wed, 21 November 2012 07:17 Go to previous messageGo to next message
swagle
Messages: 3
Registered: November 2012
Location: ktm
Junior Member
Log switch failed in primary database once standby database link goes down.
Re: Oracle Data Guard Standby Database [message #571143 is a reply to message #571135] Wed, 21 November 2012 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Error?

Regards
Michel
Re: Oracle Data Guard Standby Database [message #572237 is a reply to message #571143] Fri, 07 December 2012 23:47 Go to previous messageGo to next message
swagle
Messages: 3
Registered: November 2012
Location: ktm
Junior Member
Hi Michel,
Let me explain my problem in detail.
I am have having one oracle 9i primary database and configuration as below:

LOG_ARCHIVE_DEST_1='LOCATION=/arch/ MANDATORY REOPEN=30'
LOG_ARCHIVE_DEST_2='SERVICE=standby arch optional REOPEN=30'
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_DEST_STATE_1=ENABLE
REMOTE_ARCHIVE_ENABLE=TRUE

There are 3 log group with 10M size/member
There are 5 active archive_processses
Database protection mode is in maximum performance mode

Redo change rate is 1.5 MB/s during peak hour and 400KB during normal hour
Network bandwidth between primary and standby database is 2Mbps.

There is no problem in log switch during normal hour but during peak hour redo log switch hangs in primary database because of which no activity can be done.
As i am new to oracle standby database and known that there will be no impact while using maximum performance mode.
What is the reason behind this?
I don't want to increas redo log size and solve the problem as i donot want to loss more data.

Please help me out understand the problem.

Regards
Santosh
Re: Oracle Data Guard Standby Database [message #572249 is a reply to message #572237] Sat, 08 December 2012 08:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Please help me out understand the problem.
PROBLEM?
What Problem?
I don't see any problem.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

is COPY & PASTE broken for you?
Re: Oracle Data Guard Standby Database [message #572250 is a reply to message #572237] Sat, 08 December 2012 09:34 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
There is no problem in log switch during normal hour but during peak hour redo log switch hangs in primary database because of which no activity can be done.
As i am new to oracle standby database and known that there will be no impact while using maximum performance mode.
What is the reason behind this?
I don't want to increas redo log size and solve the problem as i donot want to loss more data.


Are you sure the problem comes from the standby database?
Disable the second destination, what happens?
Post queries and results that leads your diagnosis and enable us to diagnose.

Regards
Michel
Previous Topic: Card reader
Next Topic: File timestamp difference
Goto Forum:
  


Current Time: Fri Mar 29 06:55:02 CDT 2024