OraFAQ Forum: Server Administration » Database parameter comparison

Home » RDBMS Server » Server Administration » Database parameter comparison (Oracle 11gr2 , RHL)

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

Database parameter comparison [message #600262]

Mon, 04 November 2013 08:51

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

We have migrated database data from physical servers to virtual servers. i want to ensure all database parameters are set correctly in both physical and vblock servers.My question is what are all the parameters need to check and compare in both servers to ensure database from both servers ( physical/vblock ) are in sync.

Database used -- RAC database

OS used -- RHL 5.7

Thank you

[Updated on: Mon, 04 November 2013 08:51]

Report message to a moderator

Re: Database parameter comparison [message #600265 is a reply to message #600262]

Mon, 04 November 2013 08:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> i want to ensure all database parameters are set correctly in both physical and vblock servers.
which metric measures "correct"?
If a parameter is correct for you, does this mean it is correct for me.
Why do you even need any parameter if single value is always correct?

how high is high?

Report message to a moderator

Re: Database parameter comparison [message #600270 is a reply to message #600265]

Mon, 04 November 2013 09:35

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan,

Actually the database exist in physical server is set same configuration in vblock server database.So to be proactive in preventing database issue we plan to set same parameters in target database as we have for source database.

Thank you

Report message to a moderator

Re: Database parameter comparison [message #600271 is a reply to message #600270]

Mon, 04 November 2013 09:46

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Assuming you're using SPFILES (rather than PFILE) to start the databases, on both databases:

Code: [Select all] [Show/ hide]

SQL> create pfile from spfile;

Then compare the two files using "sdiff", for example.

However, if you are using PFILES on both databases:

Code: [Select all] [Show/ hide]

sort <pfile_name.ora>  > new_filename.ora

Then, again, compare the two resultant files with a utility such as "sdiff".

Report message to a moderator

Re: Database parameter comparison [message #600273 is a reply to message #600270]

Mon, 04 November 2013 10:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Jack14 wrote on Mon, 04 November 2013 07:35

Blackswan,

Actually the database exist in physical server is set same configuration in vblock server database.So to be proactive in preventing database issue we plan to set same parameters in target database as we have for source database.

Thank you

just use the a copy of the spfile

Report message to a moderator

Re: Database parameter comparison [message #600321 is a reply to message #600273]

Mon, 04 November 2013 23:31

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you Gazzag and Blackswan for your answers.

Report message to a moderator

Previous Topic:	LOG SWITCH CHECK POINTS
Next Topic:	Database migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 19:08:08 CDT 2025