| 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 #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:
SQL> create pfile from spfile;
Then compare the two files using "sdiff", for example.
However, if you are using PFILES on both databases:
sort <pfile_name.ora> > new_filename.ora
Then, again, compare the two resultant files with a utility such as "sdiff".
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
