某政府部門ORACLE數(shù)據(jù)庫系統(tǒng)數(shù)據(jù)遷移實施報告

1 XXXXXXXX 局資源庫系統(tǒng)局資源庫系統(tǒng) 數(shù)據(jù)庫遷移項目實施報告數(shù)據(jù)庫遷移項目實施報告 2010 11 27 2 目 錄 1 概述 3 1 1 項目背景 3 1 2 面臨的問題 3 1 3 解決方案 3 2 實施計劃 3 2 1 數(shù)據(jù)庫遷移的流程 3 2 2 時間進(jìn)度完成情況 4 2 3 實施結(jié)果 5 3 實施過程 5 3 1 服務(wù)器 62 和 63 的安裝與配置 5 3 1 1 操作系統(tǒng)環(huán)境準(zhǔn)備 5 3 1 1 1 修改內(nèi)核參數(shù) 5 3 1 1 2 創(chuàng)建 Oracle 軟件安裝所需文件系統(tǒng) 6 3 1 1 3 創(chuàng)建數(shù)據(jù)庫遷移用文件系統(tǒng) 6 3 1 2 安裝 Oracle 10g for Itanuim 軟件 6 3 1 2 1 安裝準(zhǔn)備 6 3 2 數(shù)據(jù)庫遷移過程 12 3 2 1 備份生產(chǎn)數(shù)據(jù)庫 10 88 82 131 12 3 2 2 復(fù)制 131 備份數(shù)據(jù)至 62 服務(wù)器 14 3 2 3 恢復(fù) 62 上的 9 2 0 1 數(shù)據(jù)庫 14 3 2 4 升級數(shù)據(jù)庫至 9 2 0 8 21 3 2 5 升級數(shù)據(jù)庫至 10 2 0 5 23 3 2 6 將數(shù)據(jù)庫的文件系統(tǒng)轉(zhuǎn)換為 ASM 31 3 2 7 將單實例轉(zhuǎn)換為 RAC 34 3 2 8 遷移完的其它設(shè)置 38 3 2 9 測試 39 3 1 概述概述 1 1 項目背景項目背景 XXXX 局資源庫數(shù)據(jù)庫目前版本為 9 2 0 1 運行于兩臺 HP 主機(jī)上 服務(wù)器配置 ServiceGuard 集群軟件 對數(shù)據(jù)庫提供雙機(jī)熱備保護(hù) 數(shù)據(jù)規(guī)模約 120GB 數(shù)據(jù)庫運行于非歸檔模式 使用 rman 備份數(shù)據(jù)庫 1 2 面臨的問題面臨的問題 由于應(yīng)用系統(tǒng)的特點 對數(shù)據(jù)庫的可用性要求很高 要求數(shù)據(jù)庫 7 24 可用 業(yè)務(wù) 的發(fā)展 對數(shù)據(jù)庫系統(tǒng)提出了更多的容量和處理能力要求 數(shù)據(jù)庫系統(tǒng)壓力越來越大 系統(tǒng)的處理能力接近極限 隨著系統(tǒng)使用年限的增加 系統(tǒng)的維護(hù)成本也逐年提高 系統(tǒng)已漸漸不能適應(yīng)業(yè)務(wù) 的需求 需要對系統(tǒng)進(jìn)行擴(kuò)容改裝 1 3 解決方案解決方案 目前已采購新的 HP 服務(wù)器和存儲設(shè)備 cup 6 顆雙核 每核 1 6G 內(nèi)存 48G 操 作系統(tǒng) hp unix11i v3 磁盤陣列為 28 個 146G 計劃在新系統(tǒng)上安裝 Oracle 10g RAC 數(shù)據(jù)庫軟件 2 實施計劃實施計劃 2 1 數(shù)據(jù)庫遷移的數(shù)據(jù)庫遷移的流程流程 本次數(shù)據(jù)庫遷移需要從 oracle9i 9 2 0 1 遷移到 oracle10g 10 2 0 5 遷移流程 如下 1 將 10 88 82 131 數(shù)據(jù)庫的數(shù)據(jù)通過 RMAN 遷移到 10 88 82 62 服務(wù)器上的臨時 數(shù)據(jù)庫中 4 2 將 10 88 82 62 服務(wù)器上的臨時數(shù)據(jù)庫從 9 2 0 1 升級到 9 2 0 8 3 將 10 88 82 62 服務(wù)器上的臨時數(shù)據(jù)庫從 9 2 0 8 的數(shù)據(jù)庫升級到 10 2 0 5 4 將 10 88 82 62 服務(wù)器上的臨時數(shù)據(jù)庫從文件系統(tǒng)方式轉(zhuǎn)變?yōu)?ASM 工作方式 5 將 10 88 82 62 服務(wù)器上的臨時數(shù)據(jù)庫轉(zhuǎn)換為 RAC 工作模式 隨即轉(zhuǎn)變?yōu)檎?式環(huán)境 2 2 時間進(jìn)度完成情況時間進(jìn)度完成情況 2010 11 25 項目協(xié)調(diào)會 確認(rèn)實施計劃及實施內(nèi)容 在新的機(jī)器上安裝 10g RAC 10 2 0 5 2010 11 26 準(zhǔn)備 9i 測試環(huán)境 準(zhǔn)備遷移方案 備份目前資源庫的數(shù)據(jù) 并 ftp 到新的環(huán)境中 2010 11 27 測試整個遷移方案 預(yù)估遷移時間 編寫實施報告 2010 12 03 應(yīng)用測試 2010 12 03 正式遷移 5 下表為關(guān)鍵步驟實測耗時經(jīng)修正后的列表 XXXX 局資源數(shù)據(jù)庫遷移關(guān)鍵步驟耗時一覽 不包含軟件安裝時間 步驟步驟耗時耗時 131 數(shù)據(jù)庫備份3 小時 131 備份數(shù)據(jù) ftp 到 622 5 小時 在服務(wù)器 62 上恢復(fù) 9 2 0 1 數(shù)據(jù)庫25 分鐘 9 2 0 1 數(shù)據(jù)庫升級到 9 2 0 830 分鐘 備份 9 2 0 8 數(shù)據(jù)庫30 分鐘 9 2 0 8 數(shù)據(jù)庫升級至 10 2 0 51 小時 10 2 0 5 數(shù)據(jù)庫備份30 分鐘 數(shù)據(jù)文件遷移至 ASM35 分鐘 單實例遷移至 RAC40 分鐘 測試30 分鐘 其它1 小時 總共 大約 11 小時 2 3 實施結(jié)果實施結(jié)果 62 上測試用 9 2 0 1 數(shù)據(jù)庫已升級到 10 2 0 5 運行狀態(tài)正常 數(shù)據(jù)庫已遷移到 Itanuim 服務(wù)器上 運行于 RAC 模式 運行狀態(tài)正常 3 實施過程實施過程 3 1 服務(wù)器服務(wù)器 62 和和 63 的安裝與配置的安裝與配置 3 1 1 操作系統(tǒng)環(huán)境準(zhǔn)備 3 1 1 1 修改內(nèi)核參數(shù) KSI ALLOC MAX NPROC 8 EXECUTABLE STACK 0 6 MAX THREAD PROC 1024 MAXDSIZ 1073741824 bytes MAXDSIZ 64BIT 2147483648 bytes MAXSSIZ 134217728 bytes MAXSSIZ 64BIT 1073741824 MAXSWAPCHUNKS 16384 MAXUPRC NPROC 9 10 1 MSGMAP MSGTQL 2 MSGMNI NPROC MSGSEG 32767 MSGTQL NPROC B25293 01 NCSIZE NINODE 1024 NFILE 15 NPROC 2048 NFLOCKS NPROC B25293 01 NINODE 8 NPROC 2048 NKTHREAD NPROC 7 4 16 NPROC 4096 SEMMAP SEMMNI 2 SEMMNI NPROC B25293 01 SEMMNS SEMMNI 2 SEMMNU NPROC 4 SEMVMX 32767 SHMMAX AvailMem SHMMNI 512 SHMSEG 120 VPS CEILING 64 7 3 1 1 2 創(chuàng)建 Oracle 軟件安裝所需文件系統(tǒng) 文件系統(tǒng) lv 名稱 dev vg00 lvora 文件系統(tǒng) lv size 30GB 文件系統(tǒng) mount 點 oracle 3 1 1 3 創(chuàng)建數(shù)據(jù)庫遷移用文件系統(tǒng) 在 62 主機(jī)上創(chuàng)建 vgbak 卷組 并創(chuàng)建 lvora bak 并在 lvora bak 上創(chuàng)建文件系統(tǒng) mount 到 database2 路徑 3 1 2 安裝 Oracle 10g for Itanuim 軟件 3 1 2 1 安裝準(zhǔn)備 3 1 2 1 1 修改核心參數(shù)修改核心參數(shù) 已由 HP 完成 3 1 2 1 2 存儲準(zhǔn)備存儲準(zhǔn)備 數(shù)據(jù)庫安裝可用磁盤列表如下 disk namedisk namedisk sizedisk sizevdisk namevdisk namehostname 1hostname 1hostname 2hostname 2mount pointmount point disk421GOCR 1Ggabzyk01gabzyk02 disk431GVote 1Ggabzyk01gabzyk02 disk441GASMspfile 1Ggabzyk01gabzyk02 disk451GASM OTHER 1 1Ggabzyk01gabzyk02 disk54100GASM OTHER 2 1Ggabzyk01gabzyk02 disk63100GASM DATA 100G 1gabzyk01gabzyk02 disk72100GASM DATA 100G 2gabzyk01gabzyk02 disk81100GASM DATA 100G 3gabzyk01gabzyk02 disk90100GASM DATA 100G 4gabzyk01gabzyk02 disk99100GASM DATA 100G 5gabzyk01gabzyk02 disk108100GASM DATA 100G 6gabzyk01gabzyk02 disk117100GASM DATA 100G 7gabzyk01gabzyk02 disk126100GASM DATA 100G 8gabzyk01gabzyk02 disk135100GASM DATA 100G 9gabzyk01gabzyk02 disk144100GASM DATA 100G 10gabzyk01gabzyk02 8 disk1531000Goracle bakgabzyk01 backup 3 1 2 1 3 網(wǎng)絡(luò)準(zhǔn)備網(wǎng)絡(luò)準(zhǔn)備 host infohost info 節(jié)點 1 名稱 GABZYK01 節(jié)點 2 名稱 GABZYK02 節(jié)點 1 LAN 信息 lan 名稱IP 地址子網(wǎng)掩碼網(wǎng)關(guān) lan0 心跳 192 168 1 1255 255 255 0 lan110 88 82 62255 255 255 010 88 82 250 lan2 lan3 節(jié)點 2 LAN 信息 lan 名稱IP 地址子網(wǎng)掩碼網(wǎng)關(guān) lan0 心跳 192 168 1 2255 255 255 0 無 lan110 88 82 63255 255 255 010 88 82 250 lan2 lan3 3 1 2 1 4 創(chuàng)建創(chuàng)建 oracle 用戶用戶 1 root 用戶分別登錄 alice01 alice02 主機(jī) 2 執(zhí)行 sam 命令創(chuàng)建 oracle 用戶和組 信息如下 用戶名 oracle 口令 oracle Shellksh 用戶 id 500 組信息組名 oinstall 500 id 命令輸出 uid 500 oracle gid 500 oinstall 3 修改 oracle 用戶 profile 在 profile 文件中增加如下內(nèi)容 并登錄 oracle 用戶 export ORACLE BASE oracle export ORACLE HOME ORACLE BASE product 10 2 0 db 1 export ORA CRS HOME ORACLE BASE product 10 2 0 crs 9 export LD LIBRARY PATH ORACLE HOME lib lib usr local lib export ORACLE SID orcl12 export PATH ORACLE HOME bin ORA CRS HOME bin PATH umask 022 unset USERNAME 4 創(chuàng)建 oracle 安裝目錄 mkdir p ORACLE BASE mkdir p ORACLE HOME mkdir p ORA CRS HOME 5 配置 alice01 alice02 兩臺主機(jī)的互信 root 用戶登錄主機(jī) 編輯 rhosts 文件 在文件中輸入 保存退出 3 1 2 1 5 安裝安裝 clusterware 軟件軟件 由于 Itanuim 服務(wù)器的操作系統(tǒng)版本高于 Oracle 軟件需求版本 啟動安裝程序是會 校驗失敗 導(dǎo)致不能啟動安裝程序 需要早啟動安裝程序時添加 ignoreSysPrereqs 參數(shù) 調(diào)高操作系統(tǒng)版本檢查 具體命令是 runInstaller ignoreSysPrereqs 1 將 oracle 10 2 0 1 clusterware 軟件復(fù)制到 alice01 服務(wù)上 路徑為 oracle product 10 2 0 crs 2 oracle 用戶登錄 alice01 主機(jī) 3 export TMP u01 tmp 4 export DISPLAY 客戶端 ip 0 0 5 啟動 xmanager passive 6 xclock 測試圖形應(yīng)用能正常啟動 7 runInstaller ignoreSysPrereqs 啟動 oracle Clusterware 安裝程序 8 根據(jù)提示安裝軟件 9 根據(jù)安裝程序提示完成安裝后步驟 10 執(zhí)行 crs stat t 檢查 clusterware 運行狀態(tài) 輸出應(yīng)為 crs stat t 10 名稱 類型 目標(biāo) 狀態(tài) 主機(jī) ora k01 gsd application ONLINE ONLINE gabzyk01 ora k01 ons application ONLINE ONLINE gabzyk01 ora k01 vip application ONLINE ONLINE gabzyk01 ora k02 gsd application ONLINE ONLINE gabzyk02 ora k02 ons application ONLINE ONLINE gabzyk02 ora k02 vip application ONLINE ONLINE gabzyk02 3 1 2 1 6 安裝安裝 database 軟件軟件 1 將 oracle 10 2 0 1 database 軟件復(fù)制到 62 服務(wù)上 路徑為 oracle product 10 2 0 db 1 2 oracle 用戶登錄 alice01 主機(jī) 3 export TMP u01 tmp 4 export DISPLAY 客戶端 ip 0 0 5 啟動 xmanager passive 6 xclock 測試圖形應(yīng)用能正常啟動 7 runInstaller ignoreSysPrereqs 啟動 oracle database 安裝程序 8 根據(jù)提示安裝軟件 安裝過程中不創(chuàng)建數(shù)據(jù)庫 9 根據(jù)安裝程序提示完成安裝后步驟 3 1 2 1 7 安裝安裝 clusterware 軟件軟件 10 2 0 5 補(bǔ)丁補(bǔ)丁 1 將 oracle 10 2 0 3 補(bǔ)丁軟件復(fù)制到 62 服務(wù)上 2 oracle 用戶登錄 62 主機(jī) 3 export TMP u01 tmp 4 export DISPLAY 客戶端 ip 0 0 5 啟動 xmanager passive 11 6 xclock 測試圖形應(yīng)用能正常啟動 7 runInstaller ignoreSysPrereqs 啟動 oracle 安裝程序 8 根據(jù)提示安裝軟件 應(yīng)選擇 CRS HOME 作為安裝路徑 9 根據(jù)安裝程序提示完成安裝后步驟 3 1 2 1 8 安裝安裝 database 軟件軟件 10 2 0 5 補(bǔ)丁補(bǔ)丁 1 將 oracle 10 2 0 3 補(bǔ)丁軟件復(fù)制到 62 服務(wù)上 2 oracle 用戶登錄 alice01 主機(jī) 3 export TMP u01 tmp 4 export DISPLAY 客戶端 ip 0 0 5 啟動 xmanager passive 6 xclock 測試圖形應(yīng)用能正常啟動 7 runInstaller ignoreSysPrereqs 啟動 oracle 安裝程序 8 根據(jù)提示安裝軟件 應(yīng)選擇 ORACLE HOME 作為安裝路徑 9 根據(jù)安裝程序提示完成安裝后步驟 3 1 2 1 9 配置配置 Listener 1 oracle 用戶登錄 alice01 服務(wù)器 2 export DISPLAY 客戶端 ip 0 0 3 啟動 xmanager passive 4 xclock 測試圖形應(yīng)用能正常啟動 ca 啟動 oracle 網(wǎng)絡(luò)配置助手 6 選擇 cluster 配置 7 根據(jù)提示完成 listener 配置 12 8 檢查集群狀態(tài)應(yīng)為 2008 09 19 14 43 39 alice01 u01 10203patch crs stat t 名稱 類型 目標(biāo) 狀態(tài) 主機(jī) ora 01 lsnr application ONLINE ONLINE gabzyk01 ora k01 gsd application ONLINE ONLINE gabzyk01 ora k01 ons application ONLINE ONLINE gabzyk01 ora k01 vip application ONLINE ONLINE gabzyk01 ora 02 lsnr application ONLINE ONLINE gabzyk02 ora k02 gsd application ONLINE ONLINE gabzyk02 ora k02 ons application ONLINE ONLINE gabzyk02 ora k02 vip application ONLINE ONLINE gabzyk02 輸出顯示兩臺服務(wù)器上的 listener 已自動添加到集群中 并且已經(jīng) online 3 1 2 1 10 配置配置 ASM 磁盤組磁盤組 1 oracle 用戶登錄 alice01 服務(wù)器 2 export DISPLAY 客戶端 ip 0 0 3 啟動 xmanager passive 4 xclock 測試圖形應(yīng)用能正常啟動 5 dbca 啟動數(shù)據(jù)庫配置助手 6 選擇集群配置 7 選擇配置 ASM ASM 實例 sys 用戶口令為 oracle 8 創(chuàng)建 ASM 磁盤組 采用外部冗余方式 創(chuàng)建一個磁盤組 ORADATA 3 2 數(shù)據(jù)庫遷移過程數(shù)據(jù)庫遷移過程 3 2 1 備份生產(chǎn)數(shù)據(jù)庫 10 88 82 131 由于目前的生產(chǎn)數(shù)據(jù)庫是非歸檔方式 所以只能進(jìn)行冷備 備份腳本如下 13 lsnrct stop shutdown immediate startup mount rman target run allocate channel c1 type disk maxpiecesize 1800m allocate channel c2 type disk maxpiecesize 1800m allocate channel c3 type disk maxpiecesize 1800m allocate channel c4 type disk maxpiecesize 1800m allocate channel c5 type disk maxpiecesize 1800m allocate channel c6 type disk maxpiecesize 1800m allocate channel c7 type disk maxpiecesize 1800m allocate channel c8 type disk maxpiecesize 1800m backup incremental level 0 format database2 backup U bak tag cold full bak database include current controlfile release channel c1 release channel c2 release channel c3 release channel c4 release channel c5 14 release channel c6 release channel c7 release channel c8 run allocate channel c1 type disk backup format database2 backup U ctl CURRENT CONTROLFILE release channel c1 shutdown immediate 備份控制文件 參數(shù)文件 密碼文件 cp database1 redo database2 backup cp database1 control database2 backup cp initorcl ora database2 backup cp 密碼文件 database2 backup 備份過程中可通過如下的語句查詢備份進(jìn)度 SELECT SID SERIAL CONTEXT SOFAR TOTALWORK ROUND SOFAR TOTALWORK 100 2 COMPLETE FROM V SESSION LONGOPS WHERE OPNAME LIKE RMAN AND OPNAME NOT LIKE aggregate 15 AND TOTALWORK 0 AND SOFAR TOTALWORK 3 2 2 復(fù)制 131 備份數(shù)據(jù)至 62 服務(wù)器 1 登錄 131 服務(wù)器 2 將 database2 backup 目錄的內(nèi)容 ftp 到 62 服務(wù)器的 database2 backup 下 ftp 10 88 82 62 bin prompt off mput 3 ftp 完成后 比對兩邊服務(wù)器文件大小 3 2 3 恢復(fù) 62 上的 9 2 0 1 數(shù)據(jù)庫 1 修改參數(shù)文件 su oracle cd database2 backup cp contro database1 cp redo database1 cp initorcl ora orapworcl1 database2 9i db 1 dbs mv initorcl ora initorcl1 ora mkdir p database2 9i admin orcl1 bdump mkdir p database2 9i admin orcl1 cdump mkdir p database2 9i admin orcl1 udump vi database2 9i db 1 dbs initorcl1 ora 16 注釋如下參數(shù) sort area size 524288 hash join enabled TRUE 修改如下參數(shù) background dump dest database2 9i admin orcl1 bdump core dump dest database2 9i admin orcl1 cdump user dump dest database2 9i admin orcl1 udump instance name orcl1 2 啟動數(shù)據(jù)庫 export ORACLE BASE database2 9i export ORACLE HOME ORACLE BASE db 1 export PATH ORACLE HOME bin PATH export ORACLE SID orcl1 startup nomount pfile dbs initorcl1 ora create spfile from pfile dbs initorcl1 ora shutdown abort startup nomount alter system set sga max size 4g scope spfile alter system set pga aggregate target 2g scope spfile ALTER SYSTEM SET SHARED POOL SIZE 1024m SCOPE spfile ALTER SYSTEM SET JAVA POOL SIZE 1024m SCOPE spfile 17 shutdown abort startup mount 3 恢復(fù)數(shù)據(jù)庫 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 set newname for datafile 1 to database2 9i oradata orcl1 system01 dbf set newname for datafile 2 to database2 9i oradata orcl1 undotbs01 dbf set newname for datafile 3 to database2 9i oradata orcl1 example01 dbf set newname for datafile 4 to database2 9i oradata orcl1 indx01 dbf set newname for datafile 5 to database2 9i oradata orcl1 tools01 dbf set newname for datafile 6 to database2 9i oradata orcl1 users01 dbf set newname for datafile 7 to database2 9i oradata orcl1 ACCIDENT dbf set newname for datafile 8 to database2 9i oradata orcl1 ACCi DATA dbf set newname for datafile 9 to database2 9i oradata orcl1 IMPORTVEH1 dbf set newname for datafile 10 to database2 9i oradata orcl1 ntiis 26 dbf 18 set newname for datafile 11 to database2 9i oradata orcl1 undotbs03 dbf set newname for datafile 12 to database2 9i oradata orcl1 MANAGE1 dbf set newname for datafile 13 to database2 9i oradata orcl1 undotbs04 dbf set newname for datafile 14 to database2 9i oradata orcl1 WZZD ZD1 dbf set newname for datafile 15 to database2 9i oradata orcl1 UNDOTBS11 dbf set newname for datafile 16 to database2 9i oradata orcl1 undotbs05 dbf set newname for datafile 17 to database2 9i oradata orcl1 undotbs02 dbf set newname for datafile 18 to database2 9i oradata orcl1 database2dacr ora set newname for datafile 19 to database2 9i oradata orcl1 P NEW DATA1 ora set newname for datafile 20 to database2 9i oradata orcl1 P INDEX ora set newname for datafile 21 to database2 9i oradata orcl1 P TEMP ora set newname for datafile 22 to database2 9i oradata orcl1 ntiis ora set newname for datafile 23 to database2 9i oradata orcl1 ntiis 2 ora set newname for datafile 24 to database2 9i oradata orcl1 ntiis index ora set newname for datafile 25 to database2 9i oradata orcl1 ntiis 12 1 ora set newname for datafile 26 to database2 9i oradata orcl1 ntiis 12 2 ora set newname for datafile 27 to database2 9i oradata orcl1 ntiis index 12 1 ora set newname for datafile 28 to database2 9i oradata orcl1 ntiis index 12 2 ora set newname for datafile 29 to database2 9i oradata orcl1 ntiis 3 dbf set newname for datafile 30 to database2 9i oradata orcl1 ntiis 4 dbf set newname for datafile 31 to database2 9i oradata orcl1 ntiis 5 dbf set newname for datafile 32 to database2 9i oradata orcl1 ntiis 6 dbf 19 set newname for datafile 33 to database2 9i oradata orcl1 ntiis 7 dbf set newname for datafile 34 to database2 9i oradata orcl1 ntiis 8 dbf set newname for datafile 35 to database2 9i oradata orcl1 ntiis 9 dbf set newname for datafile 36 to database2 9i oradata orcl1 ntiis 10 dbf set newname for datafile 37 to database2 9i oradata orcl1 ntiis 11 dbf set newname for datafile 38 to database2 9i oradata orcl1 ntiis 12 dbf set newname for datafile 39 to database2 9i oradata orcl1 ntiis 13 dbf set newname for datafile 40 to database2 9i oradata orcl1 ntiis 14 dbf set newname for datafile 41 to database2 9i oradata orcl1 ntiis index 1 ora set newname for datafile 42 to database2 9i oradata orcl1 ntiis index 2 ora set newname for datafile 43 to database2 9i oradata orcl1 ntiis 15 dbf set newname for datafile 44 to database2 9i oradata orcl1 P NEW DATA2 ora set newname for datafile 45 to database2 9i oradata orcl1 ntiis index 3 ora set newname for datafile 46 to database2 9i oradata orcl1 ntiis 12 3 ora set newname for datafile 47 to database2 9i oradata orcl1 IV DATA1 ora set newname for datafile 48 to database2 9i oradata orcl1 IV DATA2 ora set newname for datafile 49 to database2 9i oradata orcl1 IV INDEX1 ora set newname for datafile 50 to database2 9i oradata orcl1 IV INDEX2 ora set newname for datafile 51 to database2 9i oradata orcl1 IV USER1 ora set newname for datafile 52 to database2 9i oradata orcl1 ntiis index 4 ora set newname for datafile 53 to database2 9i oradata orcl1 ntiis index 5 ora set newname for datafile 54 to database2 9i oradata orcl1 ntiis 16 dbf set newname for datafile 55 to database2 9i oradata orcl1 ntiis 17 dbf set newname for datafile 56 to database2 9i oradata orcl1 ntiis 18 dbf 20 set newname for datafile 57 to database2 9i oradata orcl1 ntiis 19 dbf set newname for datafile 58 to database2 9i oradata orcl1 ntiis 20 dbf set newname for datafile 59 to database2 9i oradata orcl1 ntiis 12 4 ora set newname for datafile 60 to database2 9i oradata orcl1 ntiis 12 5 ora set newname for datafile 61 to database2 9i oradata orcl1 ntiis 12 6 ora set newname for datafile 62 to database2 9i oradata orcl1 ntiis 21 dbf set newname for datafile 63 to database2 9i oradata orcl1 ntiis 22 dbf set newname for datafile 64 to database2 9i oradata orcl1 ntiis 23 dbf set newname for datafile 65 to database2 9i oradata orcl1 ntiis 24 dbf set newname for datafile 66 to database2 9i oradata orcl1 ntiis 25 dbf set newname for datafile 67 to database2 9i oradata orcl1 ntiis index 6 ora set newname for datafile 68 to database2 9i oradata orcl1 ntiis index 7 ora set newname for datafile 69 to database2 9i oradata orcl1 undotbs06 dbf set newname for datafile 70 to database2 9i oradata orcl1 undotbs07 dbf set newname for datafile 71 to database2 9i oradata orcl1 undotbs08 dbf set newname for datafile 72 to database2 9i oradata orcl1 undotbs09 dbf set newname for datafile 73 to database2 9i oradata orcl1 ACCi DATA 1 dbf set newname for datafile 74 to database2 9i oradata orcl1 ACCi DATA 2 dbf set newname for datafile 75 to database2 9i oradata orcl1 ACCi DATA 3 dbf set newname for datafile 76 to database2 9i oradata orcl1 ACCi DATA 4 dbf set newname for datafile 77 to database2 9i oradata orcl1 ACCi DATA 5 dbf set newname for datafile 78 to database2 9i oradata orcl1 ntiis index 8 ora set newname for datafile 79 to database2 9i oradata orcl1 ntiis index 9 ora set newname for datafile 80 to database2 9i oradata orcl1 P NEW DATA3 ora 21 set newname for datafile 81 to database2 9i oradata orcl1 ntiis 27 dbf set newname for datafile 82 to database2 9i oradata orcl1 ntiis 28 dbf set newname for datafile 83 to database2 9i oradata orcl1 ntiis 12 7 ora set newname for datafile 84 to database2 9i oradata orcl1 ntiis index 12 3 ora set newname for datafile 85 to database2 9i oradata orcl1 P NEW DATA4 ora set newname for datafile 86 to database2 9i oradata orcl1 ntiis 12 8 ora restore database switch datafile all release channel c1 release channel c2 release channel c3 release channel c4 release channel c5 release channel c6 release channel c7 release channel c8 alter database open 服務(wù)器應(yīng)該能夠正常啟動 4 創(chuàng)建臨時表空間 alter database tempfile database1 temp01 dbf drop alter database tempfile database1 temp02 dbf drop alter database tempfile database1 orcl ntiis temp ora drop 22 alter database tempfile database1 orcl ntiis temp 12 1 ora drop alter database tempfile database1 orcl IV TEMP ora drop ALTER TABLESPACE TEMP ADD TEMPFILE database2 9i oradata orcl1 temp01 dbf size 2047m ALTER TABLESPACE TEMP ADD TEMPFILE database2 9i oradata orcl1 temp02 dbf size 1000m ALTER TABLESPACE NTIIS TEMP ADD TEMPFILE database2 9i oradata orcl1 ntiis temp ora size 1020m ALTER TABLESPACE NTIIS TEMP 12 ADD TEMPFILE database2 9i oradata orcl1 ntiis temp 12 1 ora size 100m ALTER TABLESPACE IV TEMP ADD TEMPFILE database2 9i oradata orcl1 IV TEMP ora size 500m alter database datafile database2 9i oradata orcl1 system01 dbf resize 2048m 3 2 4 升級數(shù)據(jù)庫至 9 2 0 8 1 升級數(shù)據(jù)庫 cd home oracle startup nomount alter system set kghdsidx count 1 scope spfile shutdown abort STARTUP MIGRATE SPOOL patch 9208 log rdbms admin catpatch sql 23 SPOOL OFF 2 檢查升級是否成功 查看 home oracle patch 9208 log 是否有錯誤 ORA select comp name version status from dba registry rdbms admin utlrp sql 3 升級成功后進(jìn)行備份 mkdir p database2 before 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 database2 before upgrade10g U bak tag before upgrade10g 24 database include current controlfile release channel c1 release channel c2 release