11G 异构DG问题

ylw6006

RT，想测试下11G的异构DG

想用rhel5 64bit做主库，windows xp 做备库！查询了下MOS，版本想用最新的11.2.0.3，发现好像不行！

主库：

13

Linux 64-bit for AMD Linux x86-64

7 - Oracle 11g onward, see Support Note 414043.1, also requires patch for Bug 13104881 10 - Oracle 10g onward, see Support Note 414043.1 11 - Oracle 10g onward 8, 12 - Oracle 11g onward, requires patch for Bug 13104881 13 20 - Oracle 11g onward

13  Linux 64-bit for AMD Linux x86-64  

可选的备库类型和要求：
7 - Oracle 11g onward, see Support Note 414043.1, also requires patch for Bug 13104881
10 - Oracle 10g onward, see Support Note 414043.1
11 - Oracle 10g onward
8, 12 - Oracle 11g onward, requires patch for Bug 13104881
13
20 - Oracle 11g onward

再看下这个bug13104881,貌似在11.2.0.3中没有修正，难道非得要11.2.0.2的版本？

Bug 13104881  ORA-600 [6101] INDEX corruption with cross platform transported redo  This note gives a brief overview of bug 13104881.

[ 本帖最后由 ylw6006 于 2012-4-23 11:27 编辑 ]

ylw6006

原帖由 maclean 于 2012-4-23 13:48 发表
Patch 13104881: ORA-600 [6101] DATA CORRUPTION IN 11.2.0.2 WINDOWS TO LINUX STANDBY DUPLICATION

Hdr: 13104881 11.2.0.2 RDBMS 11.2.0.2 RAM INDEX PRODID-5 PORTID-226 ORA-600 12421325
Abstract: ORA-600  ...

实践了下，附上参考文档，希望对后来人会有帮助！http://ylw6006.blog.51cto.com/470441/849909

ylw6006

那也就是说，我可以选择64位的linux做主库(rhel5)，32位的windows做备库(win 2003)，采用最新版的11.2.0.3，可以忽略这个bug 13104881 ？

Maclean Liu(刘相兵

Patch 13104881: ORA-600 [6101] DATA CORRUPTION IN 11.2.0.2 WINDOWS TO LINUX STANDBY DUPLICATION

Hdr: 13104881 11.2.0.2 RDBMS 11.2.0.2 RAM INDEX PRODID-5 PORTID-226 ORA-600 12421325
Abstract: ORA-600 [6101] DATA CORRUPTION IN 11.2.0.2 WINDOWS TO LINUX STANDBY DUPLICATION


PROBLEM:
--------
Customer is facing ORA-600  [6101], [7996], [8000], [48]  
when they apply the redo in linux standby after duplicating the primary
database from windows


bug 13104881 这个case 是 windows primary => linux standby  ，而非 Linux primary => windows standby


当然实际不推荐使用 cross platform data guard ，特别是 Linux/Unix 到 Windows ，因为OS 路径风格等问题 会造成管理麻烦，    同时也不建议在 Windows XP上使用oracle。

建议至少使用 Windows 2003 EE OR DataCenter Edition 。