暂无图片
源端oracle 11.2.0.1.0目标端11.2.0.4(打最新补丁)可以做DG吗
我来答
分享
且听风吟
2022-08-22
源端oracle 11.2.0.1.0目标端11.2.0.4(打最新补丁)可以做DG吗

请问,源端oracle 11.2.0.1.0单实例环境,目标端是11.2.0.4(打最新补丁)可以做DG环境吗


当前环境是目标端11.2.0.1.0,但是被扫描出很多高危漏洞

我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
刘贵宾

phsical standby必须一致,logical standby可以不一致

但是不建议在生产上长时间这么搞

以下可供参考

https://www.modb.pro/db/27009

暂无图片 评论
暂无图片 有用 0
暂无图片
刘贵宾
答主
2022-08-22
官方文档 As of Oracle Database 11g, and subject to current restrictions documented in MetaLink note 4134841.1, Data Guard provides increased flexibility for Data Guard configurations in which the primary and standby systems may have different CPU architectures, operating systems (for example, Windows & Linux), operating system Data Guard Operational Prerequisites Getting Started with Data Guard 2-5 binaries (32-bit/64-bit), or Oracle database binaries (32-bit/64-bit). For specific information about mixed-platform support, see Oracle MetaLink note 413484.1 at https://metalink.oracle.com. The same release of Oracle Database Enterprise Edition must be installed on the primary database and all standby databases, except during rolling database upgrades using logical standby databases.
张sir

从oracle官方的角度讲,这种方案是不可以的。如果从野路子出发,不排除可以部署的情况,但是中间碰到一些奇奇怪怪的问题或者bug,可能就解决不了。既然要修复漏洞,建议还是找窗口打补丁吧。


Oracle Patch Assurance - Data Guard Standby-First Patch Apply ( Doc ID 1265700.1 )

However, differences in database home software were limited to rolling upgrade scenarios supported only by logical standby databases. In order to apply a later database home patch (e.g. Exadata bundle patch, or database PSU) to a Data Guard environment with physical standby, you had to perform one of the following actions:

Shutdown both the primary and standby databases and apply the update to both systems before restarting, or
Convert the physical standby database to a logical standby database and apply the update using the rolling upgrade process, then convert the standby database back to a physical standby (a feature known as transient logical standby).

暂无图片 评论
暂无图片 有用 0
布衣
暂无图片

跨版本做不了DG,备库只能到mount 状态。

暂无图片 评论
暂无图片 有用 0
薛晓刚

adg要求同平台同版本

暂无图片 评论
暂无图片 有用 0
二两烧麦

1、我能理解你为,为了解决漏洞问题,想先迁移数据到目标库,然后再升级11.2.0.1吗?
2、如果想达到这个目的,其实可以有多种方案。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏