【正文】 tus, version from dba_registry。15. 編譯錯誤對象shutdown immediatestartup restrict@?/rdbms/admin/16. 升級成功后的備份mkdir p /database2/after_upgrade10g/startup mount；rman target /run { allocate channel c1 type disk。 allocate channel c2 type disk。 allocate channel c3 type disk。 allocate channel c4 type disk。 allocate channel c5 type disk。 allocate channel c6 type disk。 allocate channel c7 type disk。 allocate channel c8 type disk。 backup incremental level=0 format=39。/database2/after_upgrade10g/%39。 tag=39。cold_full_bak_10g39。 database include current controlfile。 release channel c1。 release channel c2。 release channel c3。 release channel c4。 release channel c5。 release channel c6。 release channel c7。 release channel c8。}run { allocate channel c1 type disk。 backup format=39。/database2/after_upgrade10g/%39。 CURRENT CONTROLFILE。 release channel c1。}shutdown immediatecp /database1/* /database2/after_upgrade10g. 將數(shù)據(jù)庫的文件系統(tǒng)轉(zhuǎn)換為ASM1. 以oracle用戶登錄create pfile=39。?/dbs/39。 from spfile。2. 修改參數(shù)*.db_create_file_dest=39。+ORADATA39。*.db_create_online_log_dest_1=39。+ORADATA39。*.db_create_online_log_dest_2=39。+ORADATA39。去掉control_files3. 啟動數(shù)據(jù)庫startup nomount pfile=39。?/dbs/39。4. 將數(shù)據(jù)文件遷移到ASMrestore controlfile from 39。/database1/39。sql 39。alter database mount39。run { allocate channel c1 type disk。 allocate channel c2 type disk。 allocate channel c3 type disk。 allocate channel c4 type disk。 allocate channel c5 type disk。 allocate channel c6 type disk。 allocate channel c7 type disk。 allocate channel c8 type disk。 allocate channel c9 type disk。 allocate channel c10 type disk。 allocate channel c11 type disk。 allocate channel c12 type disk。 allocate channel c13 type disk。 allocate channel c14 type disk。 allocate channel c15 type disk。 allocate channel c16 type disk。backup as copy database format 39。+oradata39。}switch database to copy。alter database open。select name,TOTAL_MB,FREE_MB from v$asm_diskgroup。5. 將在線日志文件遷移到ASMalter database add logfile group 4 size 100m。alter database add logfile group 5 size 100m。alter database add logfile group 1 size 100m。alter system switch logfile。alter database drop logfile group 2。alter database drop logfile group 3。alter database drop logfile group 1。6. 將temp file遷移到ASMalter database tempfile 39。/database2/9i/oradata/orcl1/39。 drop。alter database tempfile 39。/database2/9i/oradata/orcl1/39。 drop。alter database tempfile 39。/database2/9i/oradata/orcl1/39。 drop。alter database tempfile 39。/database2/9i/oradata/orcl1/39。 drop。alter database tempfile 39。/database2/9i/oradata/orcl1/39。 drop。alter tablespace TEMP add tempfile 39。+oradata39。 size 4000m 。alter tablespace TEMP add tempfile 39。+oradata39。 size 1024m。alter tablespace NTIIS_TEMP add tempfile 39。+oradata39。 size 1024m。alter tablespace NTIIS_TEMP_12 add tempfile 39。+oradata39。 size 1024m。alter tablespace IV_TEMP add tempfile 39。+oradata39。 size 1024m。7. 驗證所有文件是否都遷移到ASMreport schema。set lines 400col NAME for a70select name,status from v$datafile。select name,status from v$tempfile。select * from v$controlfile。col member for a50select member,status from v$logfile。. 將單實例轉(zhuǎn)換為RAC1. 修改環(huán)境變量su oraclevi .profileexport ORACLE_SID=orcl112. LISTENERS_ORCL1 = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gabzyk01vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = gabzyk02vip)(PORT = 1521)) ) ORCL1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = gabzyk01vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = gabzyk02vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl1) ) )ORCL11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = gabzyk01vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl1) (INSTANCE_NAME = orcl11) ) )ORCL12 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = gabzyk02vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl1) (INSTANCE_NAME = orcl12) ) ) 3. 修改參數(shù)文件*.cluster_database =TRUE *.cluster_database_instances = 2 =undotbs1=orcl11 =1 =1 =LISTENERS_ORCL1=orcl12=2 =LISTENERS_ORCL1=2 =UNDOTBS24. 在節(jié)點1上執(zhí)行增加thread 2的在線日志組alter database add logfile thread 2 size 100m。alter database add logfile thread 2 size 100m。alter database add logfile thread 2 size 100m。alter database enable public thread 2。設(shè)置spfile到ASM中create spfile=39。+oradata/orcl1/39。 from pfile=39。?/dbs/39。 vi $ORACLE_HOME/dbs/spfile=39。+oradata/orcl1/39。生成密碼文件cd $ORACLE_HOME/dbsorapwd file=orapworcl11 password=oracle entries=5創(chuàng)建RAC相關(guān)的視圖@?/rdbms/admin/5. 在節(jié)點2上執(zhí)行crsctl stop crssu oraclecd $ORACLE_HOME/rdbms/libmake f rac_onrelink oracle設(shè)置spfilevi $ORACLE_HOME/dbs/spfile=39。+oradata/orcl1/39。mkdir p /oracle/admin/orcl1/bdumpmkdir p /oracle/admin/orcl1/cdumpmkdir p /oracle/admin/orcl1/udump6. 修改CRSsrvctl add database d orcl1 o /oracle/product/srvctl add instance d orcl1 i orcl11 n gabzyk01srvctl add instance d orcl1 i orcl12 n gabzyk02srvctl modify instance d orcl1 i orcl11 s +ASM1srvctl modify instance d orcl1 i orcl12 s +ASM27. 測試crsctl stop crscrsctl start crs. 遷移完的其它設(shè)置grant CREATE VIEW,CREATE TABLE,ALTER SESSION,CREATE CLUSTER,CREATE SYNONYM,CREATE SEQUENCE,CREATE DATABASE LINK toCD ,HR ,LS ,MG ,OE ,PM ,QS ,SH ,ZD ,CAR ,JGJ ,QJW ,ACCI ,PARA ,TJXZ ,HTABH ,NTIIS ,QS_CB ,QS_CS ,QS_ES ,QS_OS ,QS_WS ,TMDCS ,HUAHAI ,QS_ADM ,ZD_EST ,IVPXXBZ ,POSUSER ,ACCI2000,ACCI2006,DACR2004,GABCHECK,OASEARCH,QS_CBADM/. 測試. 數(shù)據(jù)庫啟動與停止步驟如果是服務(wù)器重啟，那么啟動oracle的步驟如下：登錄到節(jié)點gabzyk01su root/oracle/product/登錄到節(jié)點gabzyk02su root/oracle/product/如果要停止服務(wù)器，