XX局資源庫系統(tǒng)數(shù)據(jù)庫遷移項目實施報告.doc

xxxx局資源庫系統(tǒng)數(shù)據(jù)庫遷移項目實施報告2011-11-27- 42 -目 錄1.概述31.1.項目背景31.2.面臨的問題31.3.解決方案32.實施計劃32.1.數(shù)據(jù)庫遷移的流程32.2.時間進度完成情況42.3.實施結果53.實施過程53.1.服務器62和63的安裝與配置53.1.1.操作系統(tǒng)環(huán)境準備.修改內核參數(shù).創(chuàng)建oracle軟件安裝所需文件系統(tǒng).創(chuàng)建數(shù)據(jù)庫遷移用文件系統(tǒng)63.1.2.安裝oracle 10g for itanuim 軟件.安裝準備63.2.數(shù)據(jù)庫遷移過程123.2.1.備份生產數(shù)據(jù)庫(31)123.2.2.復制131備份數(shù)據(jù)至62服務器143.2.3.恢復62上的數(shù)據(jù)庫143.2.4.升級數(shù)據(jù)庫至213.2.5.升級數(shù)據(jù)庫至233.2.6.將數(shù)據(jù)庫的文件系統(tǒng)轉換為asm313.2.7.將單實例轉換為rac343.2.8.遷移完的其它設置383.2.9.測試391. 概述1.1. 項目背景xxxx局資源庫數(shù)據(jù)庫目前版本為，運行于兩臺hp主機上，服務器配置serviceguard 集群軟件，對數(shù)據(jù)庫提供雙機熱備保護。數(shù)據(jù)規(guī)模約120gb。數(shù)據(jù)庫運行于非歸檔模式，使用rman備份數(shù)據(jù)庫。1.2. 面臨的問題由于應用系統(tǒng)的特點，對數(shù)據(jù)庫的可用性要求很高，要求數(shù)據(jù)庫724可用。業(yè)務的發(fā)展，對數(shù)據(jù)庫系統(tǒng)提出了更多的容量和處理能力要求，數(shù)據(jù)庫系統(tǒng)壓力越來越大，系統(tǒng)的處理能力接近極限。隨著系統(tǒng)使用年限的增加，系統(tǒng)的維護成本也逐年提高，系統(tǒng)已漸漸不能適應業(yè)務的需求，需要對系統(tǒng)進行擴容改裝。1.3. 解決方案目前已采購新的hp服務器和存儲設備。cup：6顆雙核，每核1.6g。內存48g，操作系統(tǒng)：hp unix11i v3，磁盤陣列為28個146g 。計劃在新系統(tǒng)上安裝oracle 10g rac數(shù)據(jù)庫軟件。2. 實施計劃2.1. 數(shù)據(jù)庫遷移的流程本次數(shù)據(jù)庫遷移需要從oracle9i（）遷移到oracle10g（）。遷移流程如下：1， 將31數(shù)據(jù)庫的數(shù)據(jù)通過rman遷移到2服務器上的臨時數(shù)據(jù)庫中。2， 將2服務器上的臨時數(shù)據(jù)庫從升級到。3， 將2服務器上的臨時數(shù)據(jù)庫從的數(shù)據(jù)庫升級到4， 將2服務器上的臨時數(shù)據(jù)庫從文件系統(tǒng)方式轉變?yōu)閍sm工作方式。5， 將2服務器上的臨時數(shù)據(jù)庫轉換為rac工作模式，隨即轉變?yōu)檎江h(huán)境。2.2. 時間進度完成情況2010-11-25l 項目協(xié)調會，確認實施計劃及實施內容l 在新的機器上安裝10g rac()2010-11-26l 準備9i測試環(huán)境l 準備遷移方案l 備份目前資源庫的數(shù)據(jù)，并ftp到新的環(huán)境中。2010-11-27l 測試整個遷移方案。l 預估遷移時間l 編寫實施報告2010-12-03l 應用測試2010-12-03正式遷移下表為關鍵步驟實測耗時經修正后的列表xxxx局資源數(shù)據(jù)庫遷移關鍵步驟耗時一覽（不包含軟件安裝時間）步驟耗時131數(shù)據(jù)庫備份3小時131備份數(shù)據(jù)ftp到622.5小時在服務器62上恢復數(shù)據(jù)庫25分鐘數(shù)據(jù)庫升級到30分鐘備份數(shù)據(jù)庫30分鐘數(shù)據(jù)庫升級至1小時數(shù)據(jù)庫備份30分鐘數(shù)據(jù)文件遷移至asm35分鐘單實例遷移至rac40分鐘測試30分鐘其它1小時總共：大約11小時2.3. 實施結果62上測試用數(shù)據(jù)庫已升級到，運行狀態(tài)正常數(shù)據(jù)庫已遷移到itanuim服務器上，運行于rac模式，運行狀態(tài)正常3. 實施過程3.1. 服務器62和63的安裝與配置3.1.1. 操作系統(tǒng)環(huán)境準備. 修改內核參數(shù)ksi_alloc_max (nproc*8) executable_stack=0 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 6. 創(chuàng)建oracle軟件安裝所需文件系統(tǒng)文件系統(tǒng)lv名稱/dev/vg00/lvora文件系統(tǒng)lv size30gb文件系統(tǒng)mount點/oracle. 創(chuàng)建數(shù)據(jù)庫遷移用文件系統(tǒng)在62主機上創(chuàng)建vgbak卷組，并創(chuàng)建lvora-bak，并在lvora-bak上創(chuàng)建文件系統(tǒng)mount到/database2路徑。3.1.2. 安裝oracle 10g for itanuim 軟件. 安裝準備.1. 修改核心參數(shù)已由hp完成.2. 存儲準備數(shù)據(jù)庫安裝可用磁盤列表如下：disk-namedisk-sizevdisk-namehostname-1hostname-2mount-pointdisk421gocr-1ggabzyk01gabzyk02disk431gvote-1ggabzyk01gabzyk02disk441gasmspfile-1ggabzyk01gabzyk02disk451gasm-other-1-1ggabzyk01gabzyk02disk54100gasm-other-2-1ggabzyk01gabzyk02disk63100gasm-data-100g-1gabzyk01gabzyk02disk72100gasm-data-100g-2gabzyk01gabzyk02disk81100gasm-data-100g-3gabzyk01gabzyk02disk90100gasm-data-100g-4gabzyk01gabzyk02disk99100gasm-data-100g-5gabzyk01gabzyk02disk108100gasm-data-100g-6gabzyk01gabzyk02disk117100gasm-data-100g-7gabzyk01gabzyk02disk126100gasm-data-100g-8gabzyk01gabzyk02disk135100gasm-data-100g-9gabzyk01gabzyk02disk144100gasm-data-100g-10gabzyk01gabzyk02disk1531000goracle-bakgabzyk01/backup.3. 網絡準備host-info節(jié)點1名稱gabzyk01節(jié)點2名稱gabzyk02節(jié)點1 lan信息lan名稱ip地址子網掩碼網關lan0(心跳)lan250lan2lan3節(jié)點2 lan信息lan名稱ip地址子網掩碼網關lan0(心跳)無lan350lan2lan.4. 創(chuàng)建oracle用戶1. root用戶分別登錄alice01、alice02主機2. 執(zhí)行sam命令創(chuàng)建oracle用戶和組，信息如下：用戶名oracle口令oracleshellksh用戶id500組信息組名：oinstall：500id命令輸出uid=500(oracle) gid=500(oinstall)3. 修改oracle用戶.profile，在.profile文件中增加如下內容，并登錄oracle用戶export oracle_base=/oracleexport oracle_home=$oracle_base/product/10.2.0/db_1export ora_crs_home=$oracle_base/product/10.2.0/crsexport ld_library_path=$oracle_home/lib:/lib:/usr/local/libexport oracle_sid=orcl12export path=$oracle_home/bin:$ora_crs_home/bin:$pathumask 022unset username4. 創(chuàng)建oracle安裝目錄mkdir p oracle_basemkdir p oracle_homemkdir p ora_crs_home5. 配置alice01、alice02兩臺主機的互信：root用戶登錄主機，編輯.rhosts文件，在文件中輸入+，保存退出.5. 安裝clusterware軟件由于itanuim服務器的操作系統(tǒng)版本高于oracle軟件需求版本，啟動安裝程序是會校驗失敗，導致不能啟動安裝程序，需要早啟動安裝程序時添加-ignoresysprereqs參數(shù)調高操作系統(tǒng)版本檢查。具體命令是：runinstaller -ignoresysprereqs1. 將oracle clusterware軟件復制到alice01服務上，路徑為：/oracle/product/10.2.0/crs2. oracle用戶登錄alice01主機3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動xmanager passive6. xclock測試圖形應用能正常啟動7. /runinstaller -ignoresysprereqs啟動oracle clusterware安裝程序8. 根據(jù)提示安裝軟件9. 根據(jù)安裝程序提示完成安裝后步驟10. 執(zhí)行crs_stat -t檢查clusterware運行狀態(tài)，輸出應為：crs_stat -t名稱 類型 目標 狀態(tài) 主機 -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 .6. 安裝database軟件1. 將oracle database軟件復制到62服務上，路徑為：/oracle/product/10.2.0/db_12. oracle用戶登錄alice01主機3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動xmanager passive6. xclock測試圖形應用能正常啟動7. /runinstaller -ignoresysprereqs啟動oracle database安裝程序8. 根據(jù)提示安裝軟件，安裝過程中不創(chuàng)建數(shù)據(jù)庫9. 根據(jù)安裝程序提示完成安裝后步驟.7. 安裝 clusterware 軟件補丁1. 將oracle 補丁軟件復制到62服務上.2. oracle用戶登錄62主機3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動xmanager passive6. xclock測試圖形應用能正常啟動7. /runinstaller -ignoresysprereqs啟動oracle安裝程序8. 根據(jù)提示安裝軟件，應選擇crs_home作為安裝路徑9. 根據(jù)安裝程序提示完成安裝后步驟.8. 安裝 database軟件 補丁1. 將oracle 補丁軟件復制到62服務上.2. oracle用戶登錄alice01主機3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動xmanager passive6. xclock測試圖形應用能正常啟動7. /runinstaller -ignoresysprereqs啟動oracle安裝程序8. 根據(jù)提示安裝軟件，應選擇oracle_home作為安裝路徑9. 根據(jù)安裝程序提示完成安裝后步驟.9. 配置listener1. oracle用戶登錄alice01服務器2. export display=客戶端ip:0.03. 啟動xmanager passive4. xclock測試圖形應用能正常啟動5. netca 啟動oracle網絡配置助手6. 選擇cluster配置7. 根據(jù)提示完成listener配置8. 檢查集群狀態(tài)應為:2008-09-19 14:43:39alice01 /u01/10203patch $ crs_stat -t名稱 類型 目標 狀態(tài) 主機 -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 輸出顯示兩臺服務器上的listener已自動添加到集群中，并且已經online.10. 配置asm磁盤組1. oracle用戶登錄alice01服務器2. export display=客戶端ip:0.03. 啟動xmanager passive4. xclock測試圖形應用能正常啟動5. dbca 啟動數(shù)據(jù)庫配置助手6. 選擇集群配置7. 選擇配置asm，asm實例sys用戶口令為oracle8. 創(chuàng)建asm磁盤組，采用外部冗余方式，創(chuàng)建一個磁盤組：oradata3.2. 數(shù)據(jù)庫遷移過程3.2.1. 備份生產數(shù)據(jù)庫(31)由于目前的生產數(shù)據(jù)庫是非歸檔方式，所以只能進行冷備。備份腳本如下：lsnrct stopshutdown 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_bakdatabaseinclude 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=/database2/backup/%u.ctl current controlfile;release channel c1;shutdown immediate備份控制文件、參數(shù)文件、密碼文件：cp /database1/redo* /database2/backupcp /database1/control* /database2/backupcp initorcl.ora /database2/backupcp 密碼文件 /database2/backup備份過程中可通過如下的語句查詢備份進度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% and totalwork != 0 and sofar totalwork;3.2.2. 復制131備份數(shù)據(jù)至62服務器1. 登錄131服務器2. 將/database2/backup目錄的內容ftp到62服務器的/database2/backup下。ftp 2binprompt offmput *3. ftp完成后，比對兩邊服務器文件大小。3.2.3. 恢復62上的數(shù)據(jù)庫1. 修改參數(shù)文件su - oraclecd /database2/backup/cp contro* /database1/cp redo* /database1/cp initorcl.ora orapworcl1 /database2/9i/db_1/dbs/mv initorcl.ora initorcl1.oramkdir -p /database2/9i/admin/orcl1/bdump mkdir -p /database2/9i/admin/orcl1/cdumpmkdir -p /database2/9i/admin/orcl1/udumpvi /database2/9i/db_1/dbs/ initorcl1.ora注釋如下參數(shù)：sort_area_size=524288hash_join_enabled=true修改如下參數(shù)：background_dump_dest=/database2/9i/admin/orcl1/bdumpcore_dump_dest=/database2/9i/admin/orcl1/cdumpuser_dump_dest=/database2/9i/admin/orcl1/udumpinstance_name=orcl12. 啟動數(shù)據(jù)庫export oracle_base=/database2/9iexport oracle_home=$oracle_base/db_1export path=$oracle_home/bin:$pathexport oracle_sid=orcl1startup nomount pfile=?/dbs/initorcl1.ora; create spfile from pfile=?/dbs/initorcl1.ora; shutdown abortstartup nomountalter 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;shutdown abort;startup mount;3. 恢復數(shù)據(jù)庫runallocate 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; 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; 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; 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 /