Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
Both must be identical. Keep all databases in your estate at the same version. –  Phil Mar 22 at 0:00
    
@Phil what about a logical standby? –  kupa Mar 23 at 20:10

2 Answers 2

up vote 1 down vote accepted

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.

share|improve this answer

Physical:

"Differences between the primary server(s) and the standby server(s) are always supported as long as the Oracle software installed on all servers is of the same Oracle Platform as defined above, is certified to run on each server, and is the same Oracle Database Release and Patch Set."

Logical:

"Differences between the primary server(s) and the standby server(s) are always permitted as long as the Oracle software installed on all servers is of the same Oracle Platform as defined above, and is certified to run on each server, and is the same Oracle Database Release and Patch Set. (Note that beginning with Oracle Database 10.1.0.3, SQL Apply supports configurations where the standby database is operating at a later Oracle Database Release or Patch Set, for the purpose of performing a database rolling upgrade.)"

So the short answer is: no (even if it is technically possible).

share|improve this answer
    
it would be useful if you add a reference to the text you are citing. –  miracle173 Mar 23 at 21:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.