Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Different Oracle patchlevels between primary and (physical) standby
Hi,
The production db I am looking after has to move to a new server. Because downtime is not appreciated (!) my first idea was to build a physical standby of the current production db on the new server and then do a switchover. This has the benefit that most of the work can be done in the background, only at failover time will production be affected for a short period.
As I would also like to patch the current db to a higher level (from 9.2.0.5 to 9.2.0.6 + interimpatch or 9.2.0.7 if available) I want to try following:
on the standby server I will install the patched Oracle version, and after the failover has been done I will follow the normal db upgrade procedure against the new primary db, i.e. startup migrate and running catpatch.sql
So this means that there will be a discrepency in Oracle version between primary and standby while the redo logs are shipped and applied.
Of course everything will be tested properly first but still am wondering if anyone tried this before
Regards,
Andre van Winssen
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 25 2005 - 13:55:35 CDT
![]() |
![]() |