使用dg迁移32位oracle到64位oracle

2024-02-09 18:48
文章标签 oracle 使用 64 迁移 32 dg

本文主要是介绍使用dg迁移32位oracle到64位oracle,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

跳至内容
 
 
jian (可用)
上次刷新时间: 2017-5-9 下午5:25 HKT(0)  
与我们联系 
帮助
面板
知识
服务请求
补丁程序和更新程序
社区
认证
系统
收集器
高级客户服务
设置
 
  
 
      
全局搜索 

  
 
提供反馈...
 
单击此项可添加到收藏夹转到底部转到底部

APPLIES TO:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 12.1.0.2 [Release 9.0.1 to 12.1]
Information in this document applies to any platform.

PURPOSE

***Checked for relevance on 8-Jul-2015***

***Checked for relevance on 26-Oct-2016***?

Recompile packages in a database after a Data Guard role transition in a mixed Oracle Binaries Data Guard configuration.

DETAILS

Summary

Beginning with Oracle Database 10g, there are certain configurations where Data Guard Redo Apply (physical standby) can support different Oracle binaries between primary and standby databases as long as all systems in the Data Guard configuration are running the same OS family. For example, you may have a primary database with 32bit Oracle binaries on Red Hat 32bit, and a physical standby database with 64bit Oracle binaries on Red Hat 64bit.

Note:  The Oracle RDBMS software version must be the same as per normal Data Guard requirements.

Such configurations must follow additional procedures during Data Guard role transitions (switchover and failover) as described in this note, below. If these procedures are not followed then errors will occur when trying to open the new primary database. One example error sequence would be:

ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56327]

<>
\

 
For additional information on how Data Guard supports configurations in which the primary database/system may not be identical to its standby database(s)/system(s), please see Note 413484.1

Restrictions

SQL Apply (logical standby) always requires that the bit-ness of the Oracle Database is identical on all systems in a Data Guard configuration. Continuing with the example provided in the summary above of a Red Hat 32bit/64bit primary/standby, if you are using SQL Apply you must use 32 bit Oracle binaries on both primary and standby.The bit-ness of the Oracle database must be identical if you are using any Oracle release before Oracle Database 10g for both SQL Apply and Redo Apply. Continuing with the example provided in the summary above of a Red Hat 32bit/64bit primary/standby, if you are using Oracle9i you must use 32 bit Oracle binaries on both primary and standby (either physical or logical standby).

The Data Guard Broker does not support different binaries in the same Data Guard configuration in Oracle Database 10g. All such configurations must be managed from the SQL*Plus command line. Beginning with Data Guard 11g onward, this restriction is lifted and the Data Guard Broker does support Oracle 11g databases of mixed word-size in the same Data Guard configuration.  Data Guard Fast-start Failover will failover in a mixed Oracle binary configuration but it will be unable to open the new primary database until the procedure below is followed.

Additional Role Transition Procedures when using mixed Oracle binaries

If you are running a physical standby configuration where the primary and standby have different Oracle binaries you will need to follow the instructions below on the new primary as part of any Data Guard role transition (switchover or failover) after a standby becomes a primary database (supported configurations are defined in MetaLink Note 413484.1). This procedure is necessary when transitioning roles in either direction.

Note: If you are using Oracle OLAP then you must also follow Note 352306.1 . Additionally, as a precaution for a failover, you may want to backup/export the user-created AW's ahead of time and periodically.

1. Shutdown the new primary database (If using RAC then set database to unclustered)

SQL> alter system set cluster_database=false scope=spfile;
SQL> shutdown immediate

 

2. Startup the new primary in UPGRADE mode

SQL> startup upgrade

 

3. Invalidate existing PL/SQL modules in preparation to convert the format required by the new primary. Note that there should be no other DDL on the database while running the script. Not following this recommendation may lead to deadlocks.

SQL> spool utlirp.log
SQL> @?/rdbms/admin/utlirp
SQL> spool off

 

4. Restart the database (If using RAC then set database back to clustered)

SQL> alter system set cluster_database=true scope=spfile;
SQL> shutdown immediate
SQL> startup

 

5. Recompile all invalid PL/SQL modules to be in the format required by the new primary database.

SQL> spool utlrp.log
SQL> @?/rdbms/admin/utlrp
SQL> spool off

 

6. Verify that all expected packages and classes are valid.

SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
SQL> SELECT distinct object_name FROM dba_objects WHERE status='INVALID';

 

此文档是否有帮助?

 
     
 

文档详细信息

 
通过电子邮件发送此文档的链接在新窗口中打开文档可打印页
 
 
 
 
 
 
 BULLETIN
 PUBLISHED
 2016-10-26
 2016-10-26
     
 

相关产品

 
Oracle Database - Enterprise Edition
     
 

信息中心

 
  
Index of Oracle Database Information Centers [1568043.2]
Information Center: Overview of Database Security Products [1548952.2]
     
 

文档引用

 
 此文档无可用的引用。 
     
 

最近查看

 
DataPump Import (IMPDP) Fails With Errors ORA-39776 ORA-00600 [klaevcnulcolnum] [794507.1]
Export/import process for 12.0 or 12.1 using 11gR1 or 11gR2 [741818.1]
RPAS ODBC Server ''oasoa'' Processes Not Exiting Properly and Consuming CPU Resources When Hung [1350692.1]
Host Unexpectedly Reboots during RPAS Batch Process [2210682.1]
Oracle Linux: CPU Load Avg. Becomes High [2239156.1]
显示更多
     
未找到您要查找的产品?
 
 

相关内容

  
 
 

产品

  
 
  • Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > Oracle Data Guard
 

关键字

  
 
DATA GUARD; DATAGUARD; FAILOVER; PHYSICAL STANDBY; STANDBY DATABASE; SWITCHOVER
 

错误

  
 
ORA-604; ORA-6553; PLS-801
返回页首返回页首
Copyright (c) 2017, Oracle. All rights reserved. Legal Notices and Terms of Use Privacy Statement

这篇关于使用dg迁移32位oracle到64位oracle的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/695021

相关文章

使用Python和Pyecharts创建交互式地图

《使用Python和Pyecharts创建交互式地图》在数据可视化领域,创建交互式地图是一种强大的方式,可以使受众能够以引人入胜且信息丰富的方式探索地理数据,下面我们看看如何使用Python和Pyec... 目录简介Pyecharts 简介创建上海地图代码说明运行结果总结简介在数据可视化领域,创建交互式地

Java Stream流使用案例深入详解

《JavaStream流使用案例深入详解》:本文主要介绍JavaStream流使用案例详解,本文通过实例代码给大家介绍的非常详细,对大家的学习或工作具有一定的参考借鉴价值,需要的朋友参考下吧... 目录前言1. Lambda1.1 语法1.2 没参数只有一条语句或者多条语句1.3 一个参数只有一条语句或者多

Java Spring 中 @PostConstruct 注解使用原理及常见场景

《JavaSpring中@PostConstruct注解使用原理及常见场景》在JavaSpring中,@PostConstruct注解是一个非常实用的功能,它允许开发者在Spring容器完全初... 目录一、@PostConstruct 注解概述二、@PostConstruct 注解的基本使用2.1 基本代

C#使用StackExchange.Redis实现分布式锁的两种方式介绍

《C#使用StackExchange.Redis实现分布式锁的两种方式介绍》分布式锁在集群的架构中发挥着重要的作用,:本文主要介绍C#使用StackExchange.Redis实现分布式锁的... 目录自定义分布式锁获取锁释放锁自动续期StackExchange.Redis分布式锁获取锁释放锁自动续期分布式

springboot使用Scheduling实现动态增删启停定时任务教程

《springboot使用Scheduling实现动态增删启停定时任务教程》:本文主要介绍springboot使用Scheduling实现动态增删启停定时任务教程,具有很好的参考价值,希望对大家有... 目录1、配置定时任务需要的线程池2、创建ScheduledFuture的包装类3、注册定时任务,增加、删

使用Python实现矢量路径的压缩、解压与可视化

《使用Python实现矢量路径的压缩、解压与可视化》在图形设计和Web开发中,矢量路径数据的高效存储与传输至关重要,本文将通过一个Python示例,展示如何将复杂的矢量路径命令序列压缩为JSON格式,... 目录引言核心功能概述1. 路径命令解析2. 路径数据压缩3. 路径数据解压4. 可视化代码实现详解1

Pandas透视表(Pivot Table)的具体使用

《Pandas透视表(PivotTable)的具体使用》透视表用于在数据分析和处理过程中进行数据重塑和汇总,本文就来介绍一下Pandas透视表(PivotTable)的具体使用,感兴趣的可以了解一下... 目录前言什么是透视表?使用步骤1. 引入必要的库2. 读取数据3. 创建透视表4. 查看透视表总结前言

Python 交互式可视化的利器Bokeh的使用

《Python交互式可视化的利器Bokeh的使用》Bokeh是一个专注于Web端交互式数据可视化的Python库,本文主要介绍了Python交互式可视化的利器Bokeh的使用,具有一定的参考价值,感... 目录1. Bokeh 简介1.1 为什么选择 Bokeh1.2 安装与环境配置2. Bokeh 基础2

Android使用ImageView.ScaleType实现图片的缩放与裁剪功能

《Android使用ImageView.ScaleType实现图片的缩放与裁剪功能》ImageView是最常用的控件之一,它用于展示各种类型的图片,为了能够根据需求调整图片的显示效果,Android提... 目录什么是 ImageView.ScaleType?FIT_XYFIT_STARTFIT_CENTE

Java学习手册之Filter和Listener使用方法

《Java学习手册之Filter和Listener使用方法》:本文主要介绍Java学习手册之Filter和Listener使用方法的相关资料,Filter是一种拦截器,可以在请求到达Servl... 目录一、Filter(过滤器)1. Filter 的工作原理2. Filter 的配置与使用二、Listen