oracle冷备之32位-->64位的操作

环境:servera 目标机器 serverb 先用机器

首先在A机上建立数据环境,安装oracle软件,创建数据库.数据库路径需要跟b机相同.
A机创建完成之后需要停止所有oracle服务,然后停止b机oracle服务,当掉b机数据库.将b机数据库文件copy到a机相同目录之下.同时需要将b机oracle文件中db_1中的dbs和database目录copy到a机相同目录之下.
正常情况下,32位到32位的冷备基本就没有问题了.可是今天在启动的时候提示提示oracle版本不符合,10.2.0.3.0 10.2.0.1.0 这个需要修改一下compatible这个参数,(alter system set compatible=’10.2.0.3.0’ scope=spfile;)这个时候需要做shutdown immediate之后重启数据库.可以正常启动了.满以为可以正常使用了,可是用sqlplus做查询的时候有出现了. ora-06553: pls-801:内部错误[56319]

但是结果还是可以出来,但是界面程序就无法使用过了.在GOOGLE之后可以通过以下方法来处理.

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

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-801: internal error [56319]
步骤很简单，先把库DOWN掉
1、shutdown immediate
2. Startup upgrade
3、@$ORACLE_HOME/rdbms/admin/utlirp.sql;

4、Shutdown immediate

5、Startup

6、@$ORACLE_HOME/rdbms/admin/utlrp.sql;

7、Shutdown immediate
8、startup
最最主要的就是使用utlirp来把相关内容全部在64位平台下编译一遍，顺便补充下utlirp的作用：
Rem NAME
Rem utlirp.sql - UTiLity script. to Invalidate Pl/sql modules
Rem
Rem DESCRIPTION
Rem This script. can be used to invalidate and all pl/sql modules
Rem (procedures, functions, packages, types, triggers, views)
Rem in a database.
Rem
Rem This script. must be run when it is necessary to regenerate the
Rem compiled code because the PL/SQL code format is inconsistent with
Rem the Oracle executable (e.g., when migrating a 32 bit database to
Rem a 64 bit database or vice-versa).
Rem
Rem Please note that this script. does not recompile invalid objects
Rem automatically. You must restart the database and explicitly invoke
Rem utlrp.sql to recompile invalid objects.
Rem
Rem USAGE
Rem To use this script, execute the following sequence of actions:
Rem 1. Shut down the database and restart in UPGRADE mode
Rem (using STARTUP UPGRADE or ALTER DATABASE OPEN UPGRADE)
Rem 2. Run this script
Rem 3. Shut down the database and restart in normal mode
Rem 4. Run utlrp.sql to recompile invalid objects. This script. does
Rem not automatically recompile invalid objects.
Rem
Rem NOTES
Rem * This script. must be run using SQL*PLUS.
Rem * You must be connected AS SYSDBA to run this script.
Rem * This script. expects the following files to be available in the
Rem current directory:
Rem standard.sql
Rem dbmsstdx.sql
Rem * There should be no other DDL on the database while running the
Rem script. Not following this recommendation may lead to deadlocks.
Rem
特此记录过程.
之后就可以正常使用了.
折腾了几天的备份终于结束了.