Oracle11g从Windows到Linux跨平台迁移并升级.docVIP

Windows 11.2.1--Linux 11.2.3 ??? 1、rman备份 ??? 2、查看备份集头块格式 ??????????? select * from v$transportable_platform order by endian_format; ??????????? 得到结果win64和linux64数据文件头块格式相同不需要转换 ??? 3、ftp备份集文件到linux主机上（已安装好11.2.1软件） ??? 4、将windows的数据库BASE下的admin、diag文件夹和HOME下的network、dbs文件夹拷贝到linux中，并根据linux目录规则修改各文件夹中的文件 ??????????? 包括initorcl.ora??? ,??? listener.ora等，尤其注意修改参数文件中指定的控制文件位置（指向要恢复的位置） ??? 5、使用修改后的参数文件启动数据库到nomount状态 ????????? RMAN STARTUP NOMOUNT ??? 6、从指定位置恢复控制文件，启动数据库到mount状态 ??????????? RMAN RESTORE CONTROLFILE FROM /oracle/app/winDB/CTL_ORCL15_1; ??????????? RMAN ALTER SYSTEM MOUNT; ??? 7、将备份集注??到rman中 ??????????? catalog backuppiece /oracle/app/winDB/ARCH_ORCL21_1; ??????????? catalog backuppiece /oracle/app/winDB/ARCH_ORCL22_1; ??????????? catalog backuppiece /oracle/app/winDB/CTL_ORCL23_1; ??????????? catalog backuppiece /oracle/app/winDB/FULL_ORCL17_1; ??????????? catalog backuppiece /oracle/app/winDB/FULL_ORCL18_1; ??????????? catalog backuppiece /oracle/app/winDB/FULL_ORCL19_1; ??????????? catalog backuppiece /oracle/app/winDB/FULL_ORCL20_1;? ? 8、修改rman恢复数据文件存放的目录指向要存放数据文件的目录 ????????? RMANrun ??????????????? 2{allocate channel c1 type disk; ??????????????? 3allocate channel c2 type disk; ??????????????? 4set newname for datafile 1 to /oradata/orcl/system01.dbf; ??????????????? 5set newname for datafile 2 to /oradata/orcl/sysaux01.dbf; ??????????????? 6set newname for datafile 3 to /oradata/orcl/undotbs01.dbf; ??????????????? 7set newname for datafile 4 to /oradata/orcl/users01.dbf;? ??????????????? 8restore database; ??????????????? 9} ??? 9、切换控制文件中的数据文件位置信息 ??????????? RMAN switch database to copy; ??????? 以上全部可以在线做 ??? 10、windows上停应用，将剩余的归档文件和redo日志传送到linux上做最后的recover ??????????? 注意之前将linux和windows设置相同的归档日志命名方式和归档目录，方便做recover ??????????? RMAN recover database; ??? 11、做完后打开数据库 ??????????? RMAN alter database open resetlogs; ??? 12、升级? ??????????? 安装11.2.3，使用新的环境变量、参数文件挂11.2.