实验环境: 64位操作系统,最先是安装的64位oracle,冷备份数据文件,
          因需要重新安装的32位oracle环境,大胆实验了下，发现是可以正常启动之
          前64位下的数据文件的
 
只是还需要参考文档做处理才能正常使用
ID 1436552.1       


--以下是启动原64位冷备份的步骤,没有碰到任何问题,只修改了下文件路径


[oracle@bb dbs]$ vi initEMREP.ora 


*.compatible='11.2.0.4.0'
--修改控制文件位置到新地方
*.control_files='/home/oracle/backup/EMREP/control01.ctl','/home/oracle/backup/EMREP/control02.ctl'


*.db_name='EMREP'       




SQL> startup nomount;
ORACLE instance started.


Total System Global Area  866271232 bytes
Fixed Size                  1368044 bytes
Variable Size             557842452 bytes
Database Buffers          301989888 bytes
Redo Buffers                5070848 bytes
SQL> alter database mount;
Database altered.


alter database rename file '/u01/app/oracle/data/EMREP/system01.dbf' to '/home/oracle/backup/EMREP/system01.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/sysaux01.dbf' to '/home/oracle/backup/EMREP/sysaux01.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/undotbs01.dbf' to '/home/oracle/backup/EMREP/undotbs01.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/users01.dbf' 
to '/home/oracle/backup/EMREP/users01.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/mgmt_ecm_depot1.dbf' to '/home/oracle/backup/EMREP/mgmt_ecm_depot1.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/mgmt.dbf' 
to '/home/oracle/backup/EMREP/mgmt.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/mgmt_ad4j.dbf' 
to '/home/oracle/backup/EMREP/mgmt_ad4j.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/temp01.dbf' 
to '/home/oracle/backup/EMREP/temp01.dbf';


alter database rename file '/u01/app/oracle/data/EMREP/redo01.log' to '/home/oracle/backup/EMREP/redo01.log';


alter database rename file '/u01/app/oracle/data/EMREP/redo02.log' to '/home/oracle/backup/EMREP/redo02.log';


alter database rename file '/u01/app/oracle/data/EMREP/redo03.log' to '/home/oracle/backup/EMREP/redo03.log';


SQL> alter database open;
Database altered.


正当纳闷这么容易就启动了时,同事导数据出了错误,自己测试了下果然是有问题的


SQL> create table mm as select * from dba_objects where rownum<100;
Table created.
SQL> drop table mm;  --删除表的时候碰到问题
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56327]


参考Mos,问题还是比较容易解决的
ORA-00604 when using different bit datafiles than Oracle executable (文档 ID 1436552.1)


SQL> startup upgrade;
sql> @$ORACLE_HOME/rdbms/admin/utlip.sql
SQL> shutdown immediate;
SQL> startup
sql> @$ORACLE_HOME/rdbms/admin/utlrp.sql


到此问题得到圆满解决