OraFAQ Forum: Unix » Oracle Data Guard Standby Database

Home » Infrastructure » Unix » Oracle Data Guard Standby Database (9.2.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Data Guard Standby Database [message #571123]

Wed, 21 November 2012 06:03

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.

Report message to a moderator

Re: Oracle Data Guard Standby Database [message #571128 is a reply to message #571123]

Wed, 21 November 2012 06:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which problem? He you don't tell us we can't help you.

Regards
Michel

Report message to a moderator

Re: Oracle Data Guard Standby Database [message #571135 is a reply to message #571128]

Wed, 21 November 2012 07:17

swagle
Messages: 3
Registered: November 2012
Location: ktm

Junior Member

Log switch failed in primary database once standby database link goes down.

Report message to a moderator

Re: Oracle Data Guard Standby Database [message #571143 is a reply to message #571135]

Wed, 21 November 2012 08:39

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Error?

Regards
Michel

Report message to a moderator

Re: Oracle Data Guard Standby Database [message #572237 is a reply to message #571143]

Fri, 07 December 2012 23:47

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

Report message to a moderator

Re: Oracle Data Guard Standby Database [message #572249 is a reply to message #572237]

Sat, 08 December 2012 08:29

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?

Report message to a moderator

Re: Oracle Data Guard Standby Database [message #572250 is a reply to message #572237]

Sat, 08 December 2012 09:34

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Card reader
Next Topic:	File timestamp difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:15:37 CST 2024