Oracle 23c New Features for DBA'sHello,
A question from Application Teams or the business, does dataguard supports hetergenous platforms, means can I have my production in linux and dataguard (standby) in windows environment, the answer is Yes.
This is possible from 11g onwards where you dataguard environment’s platforms can vary.
Look the metalink document 413484.1, which describes the same and here the compatability matrix of the same.
By looking at the same example given above, First you have to determine which platform your database is by executing the following query.
SQL> select platform_id, platform_name from v$database;
PLATFORM_ID PLATFORM_NAME
----------- -----------------------------------
10 Linux IA (32-bit)
My platform is 32 Bit Linux and let check in the following table for the first column 10, by cross looking the third column it say platform 7 and 10 are compatible, means 7 is windows 32 Bit platform.
Be aware some additional patches need to apply before you take over the work.
Hope this helps
Follow Me!!!