RMAN升级10204DB到11204RAC_V20(三星电气MES系统)..docxVIP

RMAN升级DB到 RAC 源库准备工作检查源库的字符集参数(适合于目标DB已经创建的情况下)select * from v$NLS_PARAMETERS;将11g中的utlu112i.sql 拷贝到源主机上执行,进行升级检查(以sysdba的角色进入运行)注意本步骤非常重要，如果源库没有执行该脚本就做了全备，会在目标库的升级中出现问题。a. Log in to the system as the owner of the environment of the database being upgraded.b. Start SQL*Plus.c. Connect to the database instance as a user with SYSDBA privileges.d. Set the system to spool results to a log file for later analysis:SQL SPOOL upgrade_info.loge. Run the Pre-Upgrade Information Tool:SQL @?/rdbms/admin/utlu112i.sqlf. Turn off the spooling of script results to the log file:SQL SPOOL OFF运行升级检查脚本dbupgdiag.sqlScript. to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql) [ID 556610.1]cd 脚本位置sqlplus / as sysdbaalter session set nls_language=American;@dbupgdiag.sqlexit如果该脚本报告有invalid对象，运行以下命令重编译无效对象：sqlplus?/?as?sysdba@?/rdbms/admin/utlrp.sql源库备份参数信息(并且把备份的文件传送到目标库) create pfile=/home/oracle/orcl10.pfile from spfile;记录源库DBID(非常重要后面恢复会用到)Select dbid from v$database编译源库无效对象@?/rdbms/admin/utlrp.sql;清理回收站PURGE DBA_RECYCLEBIN收集系统统计信息EXECUTE dbms_stats.gather_dictionary_stats记录源库的数据文件信息用于恢复的时候用select FILE_ID,FILE_NAME from dba_data_files;SQL col FILE_NAME format a80SQL / FILE_ID FILE_NAME---------- -------------------------------------------------------------------------------- 4 /u01/app/oracle/oradata/mesdb/users01.dbf 3 /u01/app/oracle/oradata/mesdb/sysaux01.dbf 2 /u01/app/oracle/oradata/mesdb/undotbs01.dbf 1 /u01/app/oracle/oradata/mesdb/system01.dbf 5 /u01/app/oracle/oradata/mesdb/example01.dbf 6 /u01/app/oracle/oradata/mesdb/large_tbs140106_01.dbf 7 /u01/app/oracle/oradata/mesdb/large_tbs140712_01.dbf 8 /u01/app/oracle/oradata/mesdb/large_tbs150106_01.dbf 9 /u01/app/oracle/oradata/mesdb/large_tbs150712_01.dbf 10 /u01/app/oracle/oradata/mesdb/large_tbs160106_01.dbf 11 /u01/app/oracle/oradata/mesdb/large_tbs160712_01.dbf 12 /u01/app/oracle/oradata/mesdb/large_tbs_idx140106_01.dbf 13 /u01/app/oracle/oradata/mesdb/large_tbs_idx140712_01.dbf 14 /u01/app/oracle/oradata/mesdb