Can I have data guard system like:
Primary: 11.2.0.1
Standby: 11.2.0.3
In logical standby ?
In physical standby versions(releases) must be the same?
Oracle 11g R2 – Primary 11.2.0.1 and Standby 11.2.0.3 Compatibility
oracle-11g-r2standbyupgrade
Related Question
- Oracle 11.2 – How to Retire a Physical Standby
- Oracle 11g R2 – How to Change Password in Physical Standby Database
- Oracle 11g – Sync Standby Database
- Oracle DataGuard: Find primary from standby DB
- Oracle standby database recovery stopped
- Oracle Data Guard – Manually Sending Archived Redo Log Files to Standby Database
- Standard Time Delay for Data Reflection in Standby Database
Best Answer
The physical standby database must be physically the same as the primary database and this means the versions must be identical.
A logical standby database can be any version, depending on how it is implemented. With 3rd party tools you can go from v10 to v12 and back. The restrictions here are on the data types that are to be replicated.
If this is for an upgrade, you start with a physical standby database, convert that to a logical standby for the upgrade.