rman升级10.2.0.4db到11.2.0.4racv2 文库文档.docx

RMAN升级DB到 RAC 一 、 源库准备工作 1. 检查源库的字符集参数(适合于目标DB已经创建的情况下) select * from vSNLS PARAMETERS; 0... 1.0 20.30,11 40 50 80 1 SQL> select古 2 3 PARAMETER from vSNLS PARAMETERS; VALUE 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 NLS NLS TERRITORY NLS CURRENCY NLS ISO CURRENCY _ _ NLS NUMERIC CHARACTERS _ _ NLS _ _ NLS DATE FORMAT _ _ NLS DATE LANGUAGE _ _ NLS _ _ NLS SORT NLS TIME FORMAT _ _ NLS TIMESTAMP FORMAT _ _ NLS TIME TZ FORMAT _ _ _ NLS TIMESTAMP TZ FORMAT _ _ _ AMERICAN AMERICA S AMERICA 1 GREGORIAN DD-MON-RR AMERICAN ZHS16GBK BINARY HH.MI.SSXFF DD-MON-RR HH.MI.SSXFF DD-MON-RR AI HH.MI.SSXFF AM TZR HH.MI.SSXFF AM AM TZR NLS DUAL CURRENCY _ _ NLS NCHAR CHARACTERSET _ _ NLS COMP _ NLS LENGTH SEMANTICS _ _ NLS NCHAR CONV EXCP _ _ _ AL16UTF16 BINARY BYTE FALSE 19 rowa selected. 2. 将11g中的utlu112isql拷贝到源主机上执行，进行升级检查(以sysdba的角色进入运行) 注意本步骤非常重要，如果源库没有执行该脚本就做了全备，会在目标库的升级中出现问题。 a.Log in to the system as the owner of the environment of the database being upgraded. b. Start SQL*Plus. b 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.log e.Run the Pre-Upgrade Information Tool: SQL>@?/rdbms/admin/utlu112i.sql f. Turn off the spooling of script results to the log file: SQL> SPOOL OFF 3. 运行升级检查脚本 dbupgdiag.sql Script.to Collect DB Upgrade/Migrate Diagnostic Information(dbupgdiag.sql)[ID 556610.1] cd脚本位置 sqlplus/as sysdba alter session set nls language='American'; @dbupgdiag.sql exit [oraclemeadb utilg]S sqlplus "/as syadba” SQL*Pluz:Release .0- Production on Thu Oct 110:20:432015 Copyright(c)1982,2007,Oracle. All Rights Reser