Database Administration (MOSC)

MOSC Banner

Compatibility setting in standby after changes in primary

edited Apr 23, 2020 5:00AM in Database Administration (MOSC) 3 commentsAnswered

Hi all,

Good day

We have two node rac on RHEL 7.6. Recently upgraded to 19c from 12.1 .  WE have standby database .

After upgrading to 19c it was initially with 12.1 compatibility  on both primary and standby . The log shippment was ok . Today I changed the compatibility to 19.0.0 on the primary

and didn't make the changes on the standby . I see error like the below in the alert log . 

Question

Should I be making changes in the standby too , as it has to update the spfile  like the below.Please advise

ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE sid='standby1';

ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE sid='standby2';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center