OraFAQ Forum: Data Guard » Instance Parameter chance in dataguard

Home » Server Options » Data Guard » Instance Parameter chance in dataguard (Linus OS)

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

Instance Parameter chance in dataguard [message #533229]

Tue, 29 November 2011 00:10

swat448
Messages: 5
Registered: November 2011
Location: Bangalore

Junior Member

HI All,

I am a fresher for this forum Smile

I have a requirement to change the instance parameter of the primary database and standby in the data guard. Does anyone have a procedure to do the same. I have to do it directly on production and there is no test set up so I cannot experiment Sad

. The procedure I am thinking of is as below. Correct me if I am wrong.

1. Stop the standby
2. backup the primary
3. Change the parameter and restart to make it effective
4. Start the primary
5. Go to stand by
6. Change the parameter and mount the database.
7. Check if both are in sync and apply logs if not.

Regs,
Swathi

Report message to a moderator

Re: Instance Parameter chance in dataguard [message #533235 is a reply to message #533229]

Tue, 29 November 2011 00:45

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

Which parameter? What from and what to?

Report message to a moderator

Re: Instance Parameter chance in dataguard [message #533258 is a reply to message #533235]

Tue, 29 November 2011 01:58

swat448
Messages: 5
Registered: November 2011
Location: Bangalore

Junior Member

The parameter is log buffer and from 13mb to 20mb.

Regs,
Swathi.

Report message to a moderator

Re: Instance Parameter chance in dataguard [message #533263 is a reply to message #533258]

Tue, 29 November 2011 02:10

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

The fastest way (I assume you want minimum downtime?) would be:
On both primary and standby,
1. alter system set log_buffer=20971520 scope=spfile;
2. startup force

Why do you want to do this?

Report message to a moderator

Re: Instance Parameter chance in dataguard [message #533267 is a reply to message #533263]

Tue, 29 November 2011 02:24

swat448
Messages: 5
Registered: November 2011
Location: Bangalore

Junior Member

There is recommendation from application end to set the log buffer value to 20mb minimum.

I want most reliable rather tested approach to this. Downtime is not an issue.

Report message to a moderator

Re: Instance Parameter chance in dataguard [message #533268 is a reply to message #533267]

Tue, 29 November 2011 02:33

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

I would say that instance parameters are in the DBA domain, and nothing to do with the application people. Who will take responsibility if, for example, performance degrades? How will they measure any improvement?
If you don't like my technique, use some other way.
Up to you.
(You might want to say "thank you".)

Report message to a moderator

Re: Instance Parameter chance in dataguard [message #533273 is a reply to message #533268]

Tue, 29 November 2011 02:59

swat448
Messages: 5
Registered: November 2011
Location: Bangalore

Junior Member

Thanks for your quick response for sure Smile

. Apologies if I sounded rude or arrogant.

I am new to the project and this parameter change was recommended by the Oracle expertise when he was asked to diagnose the system and tune it for better performance. I see that the database is performing just fine. But still for better performance of application the change is suggested. I wanted to try and test in anyway possible before implementing on live.

Regs,
Swathi,

Report message to a moderator

Previous Topic:	Can dataguard rdbms version is not the same with production rdbms?
Next Topic:	Queries arises while configuring DataGuard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 16:47:22 CDT 2023