Oracle Goldengate OGG 11g与各操作系统及数据库版本的兼容列表

2012/02/08 by 3 Comments

Oracle Goldengate OGG 11g (11.1.1.0.0)与各操作系统及数据库版本的兼容列表如下，仅供参考：

 

Oracle GoldenGate Certification Matrix 11.1.1.0.0
Version Supported Processor Type OS Version OS
32/64 bit		 Oracle FM
32/64 bit		 JDK Vendor
Version*		 JDK
32/64 bit		 Oracle
Database*		 Exceptions and Additional Information
11gR1 (11.1.1.1+) x86 Red Hat EL 4 (UL7+) 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
 MySQL 5.0 supports Delivery only
11gR1 (11.1.1.1+) x86 Red Hat EL 5 (UL3+) 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
 MySQL 5.0 supports Delivery only
11.1.1.0.0 x86 SLES 10 (SP1+) 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
 MySQL 5.0 supports Delivery only
11.1.1.0.0 x86 Windows 2003 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13		 MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x86 Windows XP Professional with SP3+ 32 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13		 MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x64 Red Hat EL 4 (UL7+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13
11.1.1.0.0 x64 Red Hat EL 5 (UL3+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
Teradata 12
Teradata 13
11.1.1.0.0 x64 SLES 10 (SP1+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13		 MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x64 Windows 2003 with SP2/R2+ 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
MySQL 5.0
MySQL 5.1
Sybase 12.5.4
Sybase 15
TimesTen 7.05
Teradata 12
Teradata 13		 MySQL 5.0 supports Delivery only
TimeTen supports Delivery only
11.1.1.0.0 x64 Windows Server 2008 with SP1+ 64 NA NA NA Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
Sybase 12.5.4
Sybase 15
MySQL 5.0
MySQL 5.1
Teradata 12
Teradata 13
Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
11.1.1.0.0 Itanium-2 Windows Server 2008 with SP1+ 64 NA NA NA Microsoft SQL Server 2000
Microsoft SQL Server 2005
Microsoft SQL Server 2008
11.1.1.0.0 SPARC Solaris 2.9 Update 9+ 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
11.1.1.0.0 SPARC Solaris 10 Update 4+ 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
11.1.1.0.0 PA-RISC HP-UX 11i (11.23)
B.11.23.0703.059a Base Quality Pack Bundle for HP-UX 11i v2, March 2007+		 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
11.1.1.0.0 PA-RISC HP-UX 11i (11.31)
B.11.31.0803.318a Base Quality Pack Bundle for HP-UX 11i v3, March 2008+		 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
11.1.1.0.0 Itanium-2 HP-UX 11i (11.23)
B.11.23.0703.059a Base Quality Pack Bundle for HP-UX 11i v2, March 2007+		 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
11.1.1.0.0 POWER AIX 5.3 (TL8+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
11.1.1.0.0 POWER AIX 6.1 (TL2+) 64 NA NA NA Oracle 9.2.0.7+
Oracle 10.2.0.4+
Oracle 11.1.+
Oracle 11.2.+
IBM DB2 9.1
IBM DB2 9.5
IBM DB2 9.7
Sybase 12.5.4
Sybase 15
Filed Under: GoldenGate, Oracle Tagged With: , ,

了解rman catalog的兼容性

2011/05/10 by 1 Comment

几天前被问到关于rman catalog兼容性的问题，catalog所在数据库版本与目标数据库版本不同会有影响吗？在我概念当中catalog所在数据库的版本并不会影响rman catalog的使用，但catalog schema的版本却有着明确要求，至于具体的兼容关系就不清楚了。

查了下MOS找到文档<RMAN Compatibility Matrix>,这个文档解释地比较清楚，存在3个基本的原则：

  1. RMAN可执行文件的版本需要和target database目标数据库的版本一致(弱一致要求)，具体的合法组合如下面列出的表格
  2. RMAN catalog schema版本必须大于等于RMAN可执行文件(强一致要求)
  3. RMAN catalog对target database目标数据库向后兼容，即支持早期版本的目标数据库

具体的可用版本组合:

Target/Auxiliary
Database		 RMAN Executable Catalog Database Catalog Schema
8.1.7.4 8.1.7.4 >=8.1.7 8.1.7.4
8.1.7.4 8.1.7.4 >=8.1.7 >=9.0.1.4
9.0.1 9.0.1 >=8.1.7 >= RMAN executable
9.2.0 >=9.0.1.3 and <= Target database >=8.1.7 >= RMAN executable
10.1.0 >=9.0.1.3 and <= Target database >=9.0.1 >= RMAN executable
10.2.0 >=9.0.1.3 and <= target database >=9.0.1 >= RMAN executable
11.1.0 >=9.0.1.3 and <= target database >=10.2.0.3 (note 1) >= RMAN executable
11.2.0 >=9.0.1.3 and <= target database >=9.0.1 >= RMAN executable

从上表中可以看到除去target database为11.1.0时因为Bug 6756872 – RMAN REGISTER OF 11G TARGET INTO 10G CATALOG FAILS WITH ORA-04028，要求catalog所在数据库大于10.2.0.3外，对catalog所在数据库的版本没有一个强要求，一般10gR2都可以满足兼容性。而对于catalog schema的版本则有着明确的高版本要求，究其原因是RMAN使用的DBMS_RCVMAN内置包要求与之版本一致的恢复目录表结构recovery catalog tables，如果达不到这种要求，那么可能出现rman 20299错误:

[maclean@rh2 ~]$ oerr rman 20299
20299, 1, "DBMS_RCVMAN package not compatible with the recovery catalog"
// *Cause:  The version of the recovery catalog tables does not work with this
//          version of the DBMS_RCVMAN package.
// *Action: Check that the recovery catalog packages and schema are installed
//          correctly.  The UPGRADE CATALOG command can be used to upgrade
//          the recovery catalog tables and packages to the most current
//          version.
//
Filed Under: Oracle, Oracle数据恢复、数据库恢复、灾难恢复 Tagged With: , ,

Difference between parameter COMPATIBLE and OPTIMIZER_FEATURES_ENABLE

2010/09/13 by 3 Comments 
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> set linesize 200;
SQL> col name for a30;
SQL> col value for a20;

SQL> select name,value
  2    from v$system_parameter
  3   where name in ('compatible', 'optimizer_features_enable');

NAME                           VALUE
------------------------------ --------------------
compatible                     10.2.0.3.0
optimizer_features_enable      10.2.0.4

/* 10.2.0.4升级完毕后compatible参数默认值为10.2.0.3，不同于optimizer_features_enable */

[Read more…]

Filed Under: Oracle Tagged With: , , , , , , ,

沪ICP备14014813号-2

沪公网安备 31010802001379号