Change param on primary and standby

[Former Member]

Friends,

hello,

If I change an Oracle parameter on Primary DB, should I do the same on the Standby ?

Or it will be synchronized via redologs ?

Thanks in advance,

[stefan_koehler]

Hello Daniel,

the init parameters are not synced by redo transport services. I recommend to keep both databases with the same configuration, especially in case of a fast (or automatic) fail-over.

There are some special parameters like COMPATIBLE, which need to be set to the same or a higher value on standby site first in upgrade scenarios. The cache size parameters depend on your available hardware of course.

Regards

Stefan

[Former Member]

Hello,

If I use alter system set ....

it is synchronized via redologs.

Have a good day

[stefan_koehler]

Hello Daniel,

the init parameters are not synced by redo transport services (just think about the consequences, if that would be the case). You can also run LogMiner to verify that.

No idea what you have done or mean.

Regards

Stefan