Home » Server Options » Data Guard » Does Data Guard work across different patchsets?
icon5.gif  Does Data Guard work across different patchsets? [message #117678] Thu, 28 April 2005 16:35 Go to next message
cahdba
Messages: 1
Registered: April 2005
Junior Member
Could I use data guard to do recovery of a 9.2.0.6 primary database to a failover database under 9.2.0.1? We have had lots of problems in our first attempt to move to 9.2.0.6 and want to be able to quickly recover/failover back to 9.2.0.1 where we haven't had problems.
Re: Does Data Guard work across different patchsets? [message #118143 is a reply to message #117678] Tue, 03 May 2005 04:52 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Unfortunately not, it's only available from Oracle 10g if you use SQL Apply.

From http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html:

"Oracle Database 10g supports database software upgrades (from Oracle Database 10g Patchset 1 onwards) in a rolling fashion, with near zero database downtime, by using Data Guard SQL Apply. The steps involve upgrading the logical standby database to the next release, running in a mixed mode to test and validate the upgrade, doing a role reversal by switching over to the upgraded database, and then finally upgrading the old primary database. While running in a mixed mode for testing purpose, the upgrade can be aborted and the software downgraded, without data loss. For additional data protection during these steps, a second standby database may be used.

By supporting rolling upgrades with minimal downtimes, Data Guard reduces the large maintenance windows typical of many administrative tasks, and enables the 24x7 operation of the business."

Best regards.

Frank
Previous Topic: dataguard
Next Topic: Data Guard and 10g
Goto Forum:
  


Current Time: Fri Mar 29 04:53:54 CDT 2024