 Does Data Guard work across different patchsets? [message #117678] |
Thu, 28 April 2005 16:35  |
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  |
Frank Naude
Messages: 4580
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
