首页 >> 大全

oracle 版本兼容模式

2023-11-01 大全 27 作者:考证青年

一.RMAN 兼容

MOS的文档:RMAN [ID 73431.1]

1.1 About RMAN

The RMAN can :

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

(2)

(3) in

(4)

(5) (used , for or point-in-time )

Each a . uses up to 5 , but only up to 4 for RMAN .

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

:10.1.0.4, 9.2.0.6, 8.1.7.4

关于 版本号的更多说明,参考我的Blog:

版本号 说明

1.2 RMAN

In , the rules of RMAN as :

--一般来说,RMAN兼容性规则如下:

(1) The RMAN be the same as the . Legal in Table B-1.

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

(2) The RMAN be than or equal to the RMAN .

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

(3) The RMAN is with from .

--RMAN 对 目标数据库向后兼容,支持早期版本的目标数据库

Table B-1 RMAN Table

Table B-1 shows for RMAN .

Note 1 : Dueto - RMAN OF 11G INTO 10G FAILS -04028

1.3. RMAN :

When of is will rise one of the :

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

RMAN-6186 - : "PL/SQL %s.%s %s in %s is "

RMAN-6429 - : "%s is not with this ".

二.RMAN 对不同操作系统的支持

MOS 文档:RMAN // Mixed [ID .1]

Mixed for:

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

+

+ -based using or sets

+ and using or sets

Note that that the is at the same as the (i.e. was not from a prior to that inthe for that ).

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

(1) For 10g 2 and above :

--在 10gR2 之后的版本,支持如下操作系统之间的RMAN 操作:

x86-64 Linux x86-64

HP-PA HP-IA

IA (64-bit) / (64-) 64-bit for AMD / (x86-64)

(2) For 11g 1 and above ( 11.1 ):

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

Linux

(3)For 11g 2(11.2.0.2) and above :

SPARC (64-bit) AIX(64-bit) - Note: this is not due toBug

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

三. 不同平台和版本之间使用RMAN的常见问题

MOS 文档:

Asked about And [ID .1]

3.1 Can I my using a later of ?

RMAN can taken on an older into a newer . The must be taken on 9.2 or later .

--RMAN 可以 备份从旧的DB 到新的,但这个旧 必须大于等于9.2.

This canbe used as part of an out-of-place , in which the older to the newer and then the are runas . Since the older can the , be to an in-place , where the must .

--这种方法也是out-of-place 升级的一部分,其可以将旧的备份恢复到新的db上。

For , Iwant to a 10.2 to 11.2, using taken on the 10.. The 11.2 will on a new host.

--例如,将DB 从10.2 升级到11.2.

The steps are:

操作步骤如下:

1. 11.2 and on new host and the 11.2 home per this doc.

2. Allow disk and/or tape to be from the new host.

3. to the 11.2 and the to a -in-time per this doc. --Do not open the at this time.

4. the 10.2 to 11.2 per the doc, from the point after the 11.2 has .

that you pre-/ post- for as under docs for :

.1 for to 11gR2

Note: the above is for 10.2 that had never been to 11.2. If the been , and you need to a that was was as 10.2, you just need to and it, will done by the .

RMAN "" is not as it will to open the after (step #3).

--在上面的第三部操作不要打开数据库。

3.2 Can I or two ?

As you , you can also do so . See #1 for .

--可以在不同的 版本之间进行恢复,同样也可以在两个不同的之间恢复。

Note, you the in the file. If , you can :

--注意,必须按照文档里的步骤进行,如果需要进行,可以执行如下:

SQL> open ;

OR

SQL> open ;

_oracle兼容低版本_兼容oracle语法

As the to or to a .

RMAN "" to the you may not use RMAN for this case, only .

3.3 Can I or two the same ?

--在不同操作系统版本上使用

For , canI my 9.2.0.1.0 RMAN taken a host 9 to where 9.2.0.1.0 is but where that host is 10?

--能否在 9上 到上?

If the CDs (media pack) can be used to .2.0.1.0 on 9 and 10, this type of is .

--这里的决定条件是安装介质能否安装在这两种操作系统上,如果安装在2个不同版本的操作系统上都都能安装,那么可以进行 或者。

For , isit to or my 9.2. 64-bit to a 9.2.32-?

--能否 或者 从64位到32位?

It is keep the same bit when a /. , the use of , the use of the same allow for a / bit (32 bit or 64bit) of . Note, this may be to the with this be to .

--一般都是推荐在相同的bit 上进行操作。 这里注意命令,其必须要求是相同的bit 。

If you will the 64-bit the 32-bit files or vice versa,after the has ended the bit must be .sql.

--在上面提到,一般推荐是相同的bit 上操作,但是也可以在不同的bit 上操作,除了命令。如果不同,在 之后必须执行.sql 脚本。

See this on bit sizes:

.1 32-bit and 64-bit Word Sizes

If you do .sql you will see but not to:

ORA-06553:PLS-801: ERROR [56319]

--如果不执行这个脚本,就会遇到ORA-6553 的错误。

3.4 Is it to a to an of ?

Say for are to to 11.2 from 10.2. After a on 11.2 for a few days you take a new of the 11.2 . to know if run into a with 11.2 if you could the 11. to 10.2 on host (or 10.2 on the same host the 11.2 ).

--比如从11.2 到10.2?

Such a if the had never been after . In this , if the 11.2 had been run =10.2 then it is to a of the 11.2 a 10.2 , then the .

-- 存在可能,如果自升级以后 参数没有变化,比如升级之前是10.2,升级之后还是10.2,那么就可以从11. 到10.2, 之后执行 操作。

If the 11. has ever been with = 11.2, then this is not . good way for HA and the old (if you fall back) is to use the Data Guard which (a that just the ). After the tonew (and still on old ), you can that is well. If it is not, you can old .

--如果升级之后,数据库用 =11.2 来open,那么就没有可能回去。另一种替代的方法是使用HA。

3.5 Can I or my two such as to Linux?

--能否在不同操作系统之间使用RMAN ?

In , you or two .

--一般来说,不能。

Note: Refer .1 which lists mixed and for //.

在[.1]文档中列出了支持的各种操作系统组合。 具体见第二小结。

In to 10g the only to from one to / . With 10g, using the RMAN , you can using the 10g Cross- . For more this note:

--在第二小节可以看到,RMAN 对不同操作系统的支持是从10gR2后支持,所以对10g之前版本的迁移,只能使用exp/imp.

10g以后可以使用RMAN 的Cross-e 。

.1

and:

In 10.2and later if the and OS are the same you may issue a" " so that are and ready to the . For more about "" see:

and User's Guide 10g 2 (10.2)

15, RMAN Cross- and

Note: Refer .1 for 10.2 and 11.1 to skip non-UNDO . This can the time. Also, note that 11.2 SKIP , to this.

关于我们

最火推荐

小编推荐

联系我们


版权声明:本站内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容, 请发送邮件至 88@qq.com 举报,一经查实,本站将立刻删除。备案号:桂ICP备2021009421号
Powered By Z-BlogPHP.
复制成功
微信号:
我知道了