This content has been marked as final. Show 7 replies
you can not
Senior Oracle DBA
Before issuing a definite yes or no, it is important to specify the OS platform and the DB version you are currently talking about.
By design, Oracle dataguard must run on the same platform, same OS, same OS patch level, same db patchset, same bitness. However, some customers, due to investment strategies, require the dataguard to run on undersized hardware with less resources, may be more limited than the production environment, or even more, to be on different platform. Oracle recommends to run on homogeneous platforms, just for simplicity in implementation and managing, but some mixing is allowed, including the word size.
On 10g the platform restriction remains, it has to be the same platform, i.e. linux - linux, windows - windows, hpux-hpux, but not necessarily the same word size, so 32/64 bits is possible, some procedures have to be followed, though. In 11g the cross platform dataguard is an added new feature, so it is possible to have a dataguard with a linux <-> windows combination.
Either way, on a 9i Dataguard the bitness was a restriction, it was not possible to have different word size combinations in a dataguard configuration, for both the sql apply and redo apply, on 10g it is possible, just be aware that the dataguard broker doesn't support different word size with the same dataguard configuration, so the management has to be performed from sqlplus (on 11g this restriction is over) and valid for the redo apply, not for the sqlapply (logical standby db), this last configuration has to run with the same bitness.
It is evident you haven't read the 10g/11g documentation.
Nicely done, Madrid!
'Mr' 'I know everything better' Madrid,
Thank you for flaming me, where the OP didn't specify a version at all.
Senior Oracle DBA
Thank you for flaming me,I don't know about flames, but it lit a fire under my a$$ to go take a look.
the 11g document interface is so annoying - read section:
2.3.1 Hardware and Operating System Requirements
The metalink doc lists the specific permitted combinations.
Message was edited by:
p.s. sybrandb, this info isn't directed to you, it's for people later on - people who may actually do a search to look for information rather than posting an 'answer my question 'cause i don't want to read through 10 entries of a search. ;}
Now, now sybrandb! You are the NUMBER ONE "RTFM" ponce on this forum, so be big and accept that you soiled your panties when Madrid fed you some of your own medicine.