OracleRMAN兼容性及不同版本和不同平台之间使用常见问题说明

Oracle RMAN 兼容性 及 不同版本和不同平台之间使用 常见问题说明

一.RMAN Catalog兼容性

MOS的文档：RMAN Compatibility Matrix [ID 73431.1]

1.1 About RMAN Compatibility

The RMAN environment can contain thefollowing components:

--RMAN 环境由以下5部分组成：

(1) RMAN executable

(2) Recovery catalog database

(3) Recovery catalog schema in therecovery catalog database

(4) Target database

(5) Auxiliary database (used forduplicate, duplicate for standby or tablespace point-in-time recovery)

Each componenthas a release number. Oracle uses up to 5 digits, but only up to 4 aresignificant for RMAN compatibility purposes.

--每个组件都有一个发行版本，其有5位数字组成，但只有前面4位影响RMAN 的兼容性。

Examples:10.1.0.4, 9.2.0.6, 8.1.7.4

关于Oracle 版本号的更多说明，参考我的Blog：

1.2 RMAN Compatibility Matrix

In general, the rules of RMAN compatibilityare as follows:

--一般来说，RMAN兼容性规则如下：

(1) The RMAN executable versionshould be the same as the target database. Legal exception combinations arelisted in Table B-1.

--RMAN 可执行文件的版本要和目标数据库的版本一致，但也有例外，具体参考下表。

(2) The RMAN catalog schema versionmust be greater than or equal to the RMAN executable.

--RMAN catalog schema 的版本必须大于等于RMAN 可执行文件的版本。

(3) The RMAN catalog is backwardscompatible with target databases from earlier releases.

--RMAN catalog对target database目标数据库向后兼容，支持早期版本的目标数据库

Table B-1 RMAN Compatibility Table
Table B-1 shows version requirements for RMAN components.

Note 1 : Dueto Bug6756872 - RMAN REGISTER OF 11G TARGET INTO 10G CATALOG FAILS WITHORA-04028

When compatibility of components is brokenRMAN will rise one of the following errors:

--当遇到兼容性问题时，会报如下错误：

RMAN-6186 -associated message: "PL/SQL package %s.%s version %s in %s database is tooold"

RMAN-6429 -associated message: "%s database is not compatible with this version ofRMAN".

MOS 文档：RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support [ID 1079563.1]

Mixed platforms aresupported for:

--混合平台之间支持如下操作：

+ Active Database DUPLICATE
+ Backup-based DUPLICATE using image copies or backup sets
+ RESTORE and RECOVER using image copies or backup sets

Note that thefollowing platform combinations assume that the sourcedatabase is created at the same version as the destination database(i.e. was not upgraded from a version prior to that listed inthe heading for that combination).

注意以下操作系统的组合，这里假设DB version相同：

（1） For Oracle Database 10g Release 2 and above releases:

--在Oracle 10gR2 之后的版本，，支持如下操作系统之间的RMAN 操作：

Solaris x86-64 <-> Linux x86-64

HP-PA <-> HP-IA

Windows IA (64-bit) / Windows (64-bitItanium) <-> Windows 64-bit for AMD / Windows (x86-64)

（2） For Oracle Database 11g Release 1 and above releases (requiresminimum 11.1 compatible setting):

--在Oracle 11gR1 之后的版本，支持如下操作系统之间的RMAN 操作，当然这里也包含第一条里提到的10gR2后的组合。

Linux <-> Windows

（3）For Oracle Database 11g Release 2(11.2.0.2) and above releases:

Solaris SPARC (64-bit) <-> AIX(64-bit) - Note: this platform combination is currently not supported due toBug 12702521

--在11gR2中，因为Bug 12702521的存在，SolarisSPARC (64-bit) <-> AIX (64-bit) 这2个版本之间不能进行RMAN 操作。