用rman备份64位的备份集 恢复32位数据库过程

1. 拷贝文件到linux系统
AfterSVC_SJTICKET_20081211_88
AfterSVC_SJTICKET_20081211_91
AfterSVC_SJTICKET_20081211_94
rmanback_2008_12_11_11_32.log
AfterSVC_SJTICKET_20081211_89
AfterSVC_SJTICKET_20081211_92
arch_SJTICKET_20081211_95
spfile_SJTICKET_20081211_97.bak
AfterSVC_SJTICKET_20081211_90
AfterSVC_SJTICKET_20081211_93
control_SJTICKET_20081211_96

2. export ORACLE_SID=SJTICKET
3. rman target /
4. startup nomount
5. restore spfile from ‘/opt/oracle/SJTICKET/ spfile_SJTICKET_20081211_97.bak’
6. 根据spfile建需要的文件夹 /opt/oracle/admin/SJTICKET/bdump cdump udump
/opt/oracle/oradata/SJTICKET/ 和 /opt/oracle/oradata/SJTICKET/Redo_archivelog/
Spfile 内容如下：
*.aq_tm_processes=1
*.background_dump_dest='/opt/oracle/admin/SJTICKET/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/oracle/oradata/SJTICKET/control01.ctl','/opt/oracle/oradata/SJTICKET/control02.ctl','/opt/oracle/oradata/SJTICKET/control03.ctl'
*.core_dump_dest='/opt/oracle/admin/SJTICKET/cdump'
*.db_block_size=8192
*.db_cache_size=838860800
*.db_domain='sjticket.com.cn'
*.db_file_multiblock_read_count=16
*.db_name='SJTICKET'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SJTICKETXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='SJTICKET'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_dest_1='location=/opt/oracle/oradata/SJTICKET/Redo_archivelog/'
*.log_archive_format='ora_%t_%s'
*.log_archive_start=TRUE
*.open_cursors=300
*.pga_aggregate_target=536870912
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=209715200
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/oracle/admin/SJTICKET/udump'
7. 建立密码文件
Orapwd file=$ORACLE_HOME/dbs/orapwSJTICKET.ora password=sysdba entries=20
8. 回到rman下 恢复控制文件
restore controlfile from ‘/opt/oracle/SJTICKET/ control_SJTICKET_20081211_96’

9. alter database mount;
10. list backup;
Piece Name: /opt/rman_bak/SJTICKET/2008-12-11/AfterSVC_SJTICKET_20081211_92
查看备份文件路径，将备份的数据文件和日志文件cp到备份中记录的目标文件夹下/opt/rman_bak/SJTICKET/2008-12-11（这是9i做法，如果是10g的话 ，可以用catalog start with ‘文件夹路径’即可）
11. 还原数据库 restore database
12. 恢复数据库 recover database until cancel(因为在线日志没有)
13. alter database open resetlog;

打开库 查询时 报错：ORA-06553: PLS-801: internal error [56319]
这是因为原库是64位数据库，而恢复在32位库上：

1、修改初始化文件,增加 _SYSTEM_TRIG_ENABLED = false参数
2、Stratup nomount
3、从源库备份一个控制文件，在目标库上重新创建控制文件。
4、Shutdown immediate
5、 Startup migrate
【
startup migrate|startup upgrade 区别
you can downgrade db using startup migrate since 10g.
you can upgrade db using startup upgrade since 10g.
you can upgrade/downgrade db using startup migrate till 9i.
】
6、@$ORACLE_HOME/rdbms/admin/utlirp.sql;
7、Shutdown immediate
8、Startup
9、@$ORACLE_HOME/rdbms/admin/utlrp.sql;
10、Shutdown immediate
11、再次修改初始化参数文件,删除参数 _SYSTEM_TRIG_ENABLED = false
12、Startup

转换完成(当时是照网上一个文档做的，现在仔细看来1、2、3、4、11这些步骤貌似都不需要的，最最主要的就是使用utlirp来把相关内容全部在32位平台下编译一遍)

参看网址：http://zhang41082.itpub.net/post/7167/456910
http://hi.baidu.com/rain_at_dna/blog/item/bc0d87178b9546044b90a76b.html