Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question, Mauro.

Asked: April 11, 2024 - 2:51 pm UTC

Last updated: May 07, 2024 - 3:36 am UTC

Version: 11.2

Viewed 1000+ times

You Asked

According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed.
Could you please just confirm that 11.2 -> 12.2 is really possible?
If so, what about 11.2 -> 19.x ?
Or 12.2 -> 19.x ?

Of course the idea is to upgrade to a later version with a very short downtime, after having switched to the newer version the old one would be discarded and the dataguard no longer used.

Best regards


and Connor said...

Yes you can. This is implemented to provide the "Standby First" facility when upgrading.

However, there is really all about *upgrade* not maintaining two different versions for any length of time.

The MOS note accompanying the one you referenced, 1265700.1 is a good reference on the boundaries we set for this approach.

For example:

"The maximum supported duration to have different database home software between primary and standby is 31 days"


  (2 ratings)


A reader, April 22, 2024 - 9:31 am UTC

Thank you really very much

Just a couple of final questions.

1) is there any particular precaution to take for a mixed version dataguard?
Something different compared with normal equal version or all is exactly the same?

2) That note says it can be done as of 11.2
Regarding a 10.2 -> 11.2 case, is it simply just not supported ( but perhaps it might work ) or is it guaranteed that it can never work?


Connor McDonald
April 30, 2024 - 4:45 am UTC

1) Its just normal DataGuard not withstanding all of the restrictions listed in the MOS note

2) We made changes to what is stored in the datafiles and redo logs from 11.2 onwards to make it possible. You could try "go it alone" (I'd be surprised if it worked) but thats a risky road to travel

A reader, April 30, 2024 - 7:26 am UTC

Thank you again
You saved my day

Connor McDonald
May 07, 2024 - 3:36 am UTC

glad we could help