Home » Server Options » Data Guard » Instance Parameter chance in dataguard (Linus OS)
Instance Parameter chance in dataguard [message #533229] Tue, 29 November 2011 00:10 Go to next message
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
Re: Instance Parameter chance in dataguard [message #533235 is a reply to message #533229] Tue, 29 November 2011 00:45 Go to previous messageGo to next message
John Watson
Messages: 4683
Registered: January 2010
Location: Global Village
Senior Member
Which parameter? What from and what to?
Re: Instance Parameter chance in dataguard [message #533258 is a reply to message #533235] Tue, 29 November 2011 01:58 Go to previous messageGo to next message
swat448
Messages: 5
Registered: November 2011
Location: Bangalore
Junior Member
The parameter is log buffer and from 13mb to 20mb.

Regs,
Swathi.
Re: Instance Parameter chance in dataguard [message #533263 is a reply to message #533258] Tue, 29 November 2011 02:10 Go to previous messageGo to next message
John Watson
Messages: 4683
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?
Re: Instance Parameter chance in dataguard [message #533267 is a reply to message #533263] Tue, 29 November 2011 02:24 Go to previous messageGo to next message
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.
Re: Instance Parameter chance in dataguard [message #533268 is a reply to message #533267] Tue, 29 November 2011 02:33 Go to previous messageGo to next message
John Watson
Messages: 4683
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".)
Re: Instance Parameter chance in dataguard [message #533273 is a reply to message #533268] Tue, 29 November 2011 02:59 Go to previous message
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,
Previous Topic: Can dataguard rdbms version is not the same with production rdbms?
Next Topic: Queries arises while configuring DataGuard
Goto Forum:
  


Current Time: Thu Oct 23 03:13:53 CDT 2014

Total time taken to generate the page: 0.05127 seconds