oracle夸版本迁移,Oracle rman 跨小版本迁移(小到大)

环境描述原系统:     11.2.0.3.0目标系统    11.2.0.4.01.原系统进行备份run{allocate channel c1 type disk;allocate channel c2 type disk;backup database  format  '/u01/full_%n_%T_%t_%s_%p.bak';sql 'alter system archive log current';backup archivelog all format '/u01/arch_%d_%T_%s_%p.bak' delete input;backup current controlfile format '/u01/ctl_%d_%T_%s_%p.bak';release channel c1;release channel c2;}2.传输备份3.异机恢复3.1 编辑pfile并启库3.2 还原控制文件RMAN> restore controlfile from '/u01/ctl_MYTEST_20171010_8_1.bak';3.3 还原归档RMAN> list backup of archivelog all;using target database control file instead of recovery catalogList of Backup Sets===================BS Key  Size       Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------6       602.50K    DISK        00:00:00     10-OCT-17BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20171010T233223Piece Name: /u01/arch_MYTEST_20171010_6_1.bakList of Archived Logs in backup set 6Thrd Seq     Low SCN    Low Time  Next SCN   Next Time---- ------- ---------- --------- ---------- ---------1    626     12816578   10-OCT-17 12817363   10-OCT-17BS Key  Size       Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------7       223.00K    DISK        00:00:00     10-OCT-17BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20171010T233223Piece Name: /u01/arch_MYTEST_20171010_7_1.bakList of Archived Logs in backup set 7Thrd Seq     Low SCN    Low Time  Next SCN   Next Time---- ------- ---------- --------- ---------- ---------1    627     12817363   10-OCT-17 12818121   10-OCT-171    628     12818121   10-OCT-17 12818129   10-OCT-17RMAN>  restore archivelog sequence between 627 and 628;Starting restore at 11-OCT-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=7510 device type=DISKchannel ORA_DISK_1: starting archived log restore to default destinationchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=627channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=628channel ORA_DISK_1: reading from backup piece /u01/arch_MYTEST_20171010_7_1.bakchannel ORA_DISK_1: piece handle=/u01/arch_MYTEST_20171010_7_1.bak tag=TAG20171010T233223channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:01Finished restore at 11-OCT-173.3 还原数据文件RUN{ALLOCATE CHANNEL c1 DEVICE TYPE DISK;set newname for datafile 1 to "/u01/app/oracle/mytest/system.301.940986413";set newname for datafile 2 to "/u01/app/oracle/mytest/sysaux.304.940986413";set newname for datafile 3 to "/u01/app/oracle/mytest/undotbs1.303.940986413";set newname for datafile 4 to "/u01/app/oracle/mytest/users.302.940986413";set newname for tempfile 1 to "/u01/app/oracle/mytest/temp.256.940986481";SET UNTIL sequence 628 thread 1;RESTORE DATABASE;SWITCH DATAFILE ALL;RECOVER DATABASE;}3.4 处理logfileALTER DATABASE RENAME FILE ''+DG/mytest/onlinelog/group_3.293.940986475''  to  ''/u01/app/oracle/mytest/group_3.293.940986475'';ALTER DATABASE RENAME FILE ''+DG/mytest/onlinelog/group_2.300.940986471''  to  ''/u01/app/oracle/mytest/group_2.300.940986471'';ALTER DATABASE RENAME FILE ''+DG/mytest/onlinelog/group_1.292.940986469''  to  ''/u01/app/oracle/mytest/group_1.292.940986469'';4.启库5.运行脚本5.1 catupgrd.sql   数据字典升级脚5.2 utlrp.sql  编译失效对象5.3 catuppst.sql  执行一些未在升级包中的操作5.4 utlu112s.sql  升级结果