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

xxxx局資源庫(kù)系統(tǒng)數(shù)據(jù)庫(kù)遷移項(xiàng)目實(shí)施報(bào)告2011-11-27- 42 -目 錄1.概述31.1.項(xiàng)目背景31.2.面臨的問題31.3.解決方案32.實(shí)施計(jì)劃32.1.數(shù)據(jù)庫(kù)遷移的流程32.2.時(shí)間進(jìn)度完成情況42.3.實(shí)施結(jié)果53.實(shí)施過程53.1.服務(wù)器62和63的安裝與配置53.1.1.操作系統(tǒng)環(huán)境準(zhǔn)備.修改內(nèi)核參數(shù).創(chuàng)建oracle軟件安裝所需文件系統(tǒng).創(chuàng)建數(shù)據(jù)庫(kù)遷移用文件系統(tǒng)63.1.2.安裝oracle 10g for itanuim 軟件.安裝準(zhǔn)備63.2.數(shù)據(jù)庫(kù)遷移過程123.2.1.備份生產(chǎn)數(shù)據(jù)庫(kù)(31)123.2.2.復(fù)制131備份數(shù)據(jù)至62服務(wù)器143.2.3.恢復(fù)62上的數(shù)據(jù)庫(kù)143.2.4.升級(jí)數(shù)據(jù)庫(kù)至213.2.5.升級(jí)數(shù)據(jù)庫(kù)至233.2.6.將數(shù)據(jù)庫(kù)的文件系統(tǒng)轉(zhuǎn)換為asm313.2.7.將單實(shí)例轉(zhuǎn)換為rac343.2.8.遷移完的其它設(shè)置383.2.9.測(cè)試391. 概述1.1. 項(xiàng)目背景xxxx局資源庫(kù)數(shù)據(jù)庫(kù)目前版本為，運(yùn)行于兩臺(tái)hp主機(jī)上，服務(wù)器配置serviceguard 集群軟件，對(duì)數(shù)據(jù)庫(kù)提供雙機(jī)熱備保護(hù)。數(shù)據(jù)規(guī)模約120gb。數(shù)據(jù)庫(kù)運(yùn)行于非歸檔模式，使用rman備份數(shù)據(jù)庫(kù)。1.2. 面臨的問題由于應(yīng)用系統(tǒng)的特點(diǎn)，對(duì)數(shù)據(jù)庫(kù)的可用性要求很高，要求數(shù)據(jù)庫(kù)724可用。業(yè)務(wù)的發(fā)展，對(duì)數(shù)據(jù)庫(kù)系統(tǒng)提出了更多的容量和處理能力要求，數(shù)據(jù)庫(kù)系統(tǒng)壓力越來越大，系統(tǒng)的處理能力接近極限。隨著系統(tǒng)使用年限的增加，系統(tǒng)的維護(hù)成本也逐年提高，系統(tǒng)已漸漸不能適應(yīng)業(yè)務(wù)的需求，需要對(duì)系統(tǒng)進(jìn)行擴(kuò)容改裝。1.3. 解決方案目前已采購(gòu)新的hp服務(wù)器和存儲(chǔ)設(shè)備。cup：6顆雙核，每核1.6g。內(nèi)存48g，操作系統(tǒng)：hp unix11i v3，磁盤陣列為28個(gè)146g 。計(jì)劃在新系統(tǒng)上安裝oracle 10g rac數(shù)據(jù)庫(kù)軟件。2. 實(shí)施計(jì)劃2.1. 數(shù)據(jù)庫(kù)遷移的流程本次數(shù)據(jù)庫(kù)遷移需要從oracle9i（）遷移到oracle10g（）。遷移流程如下：1， 將31數(shù)據(jù)庫(kù)的數(shù)據(jù)通過rman遷移到2服務(wù)器上的臨時(shí)數(shù)據(jù)庫(kù)中。2， 將2服務(wù)器上的臨時(shí)數(shù)據(jù)庫(kù)從升級(jí)到。3， 將2服務(wù)器上的臨時(shí)數(shù)據(jù)庫(kù)從的數(shù)據(jù)庫(kù)升級(jí)到4， 將2服務(wù)器上的臨時(shí)數(shù)據(jù)庫(kù)從文件系統(tǒng)方式轉(zhuǎn)變?yōu)閍sm工作方式。5， 將2服務(wù)器上的臨時(shí)數(shù)據(jù)庫(kù)轉(zhuǎn)換為rac工作模式，隨即轉(zhuǎn)變?yōu)檎江h(huán)境。2.2. 時(shí)間進(jìn)度完成情況2010-11-25l 項(xiàng)目協(xié)調(diào)會(huì)，確認(rèn)實(shí)施計(jì)劃及實(shí)施內(nèi)容l 在新的機(jī)器上安裝10g rac()2010-11-26l 準(zhǔn)備9i測(cè)試環(huán)境l 準(zhǔn)備遷移方案l 備份目前資源庫(kù)的數(shù)據(jù)，并ftp到新的環(huán)境中。2010-11-27l 測(cè)試整個(gè)遷移方案。l 預(yù)估遷移時(shí)間l 編寫實(shí)施報(bào)告2010-12-03l 應(yīng)用測(cè)試2010-12-03正式遷移下表為關(guān)鍵步驟實(shí)測(cè)耗時(shí)經(jīng)修正后的列表xxxx局資源數(shù)據(jù)庫(kù)遷移關(guān)鍵步驟耗時(shí)一覽（不包含軟件安裝時(shí)間）步驟耗時(shí)131數(shù)據(jù)庫(kù)備份3小時(shí)131備份數(shù)據(jù)ftp到622.5小時(shí)在服務(wù)器62上恢復(fù)數(shù)據(jù)庫(kù)25分鐘數(shù)據(jù)庫(kù)升級(jí)到30分鐘備份數(shù)據(jù)庫(kù)30分鐘數(shù)據(jù)庫(kù)升級(jí)至1小時(shí)數(shù)據(jù)庫(kù)備份30分鐘數(shù)據(jù)文件遷移至asm35分鐘單實(shí)例遷移至rac40分鐘測(cè)試30分鐘其它1小時(shí)總共：大約11小時(shí)2.3. 實(shí)施結(jié)果62上測(cè)試用數(shù)據(jù)庫(kù)已升級(jí)到，運(yùn)行狀態(tài)正常數(shù)據(jù)庫(kù)已遷移到itanuim服務(wù)器上，運(yùn)行于rac模式，運(yùn)行狀態(tài)正常3. 實(shí)施過程3.1. 服務(wù)器62和63的安裝與配置3.1.1. 操作系統(tǒng)環(huán)境準(zhǔn)備. 修改內(nèi)核參數(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點(diǎn)/oracle. 創(chuàng)建數(shù)據(jù)庫(kù)遷移用文件系統(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 軟件. 安裝準(zhǔn)備.1. 修改核心參數(shù)已由hp完成.2. 存儲(chǔ)準(zhǔn)備數(shù)據(jù)庫(kù)安裝可用磁盤列表如下：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. 網(wǎng)絡(luò)準(zhǔn)備host-info節(jié)點(diǎn)1名稱gabzyk01節(jié)點(diǎn)2名稱gabzyk02節(jié)點(diǎn)1 lan信息lan名稱ip地址子網(wǎng)掩碼網(wǎng)關(guān)lan0(心跳)lan250lan2lan3節(jié)點(diǎn)2 lan信息lan名稱ip地址子網(wǎng)掩碼網(wǎng)關(guān)lan0(心跳)無lan350lan2lan.4. 創(chuàng)建oracle用戶1. root用戶分別登錄alice01、alice02主機(jī)2. 執(zhí)行sam命令創(chuàng)建oracle用戶和組，信息如下：用戶名oracle口令oracleshellksh用戶id500組信息組名：oinstall：500id命令輸出uid=500(oracle) gid=500(oinstall)3. 修改oracle用戶.profile，在.profile文件中增加如下內(nèi)容，并登錄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兩臺(tái)主機(jī)的互信：root用戶登錄主機(jī)，編輯.rhosts文件，在文件中輸入+，保存退出.5. 安裝clusterware軟件由于itanuim服務(wù)器的操作系統(tǒng)版本高于oracle軟件需求版本，啟動(dòng)安裝程序是會(huì)校驗(yàn)失敗，導(dǎo)致不能啟動(dòng)安裝程序，需要早啟動(dòng)安裝程序時(shí)添加-ignoresysprereqs參數(shù)調(diào)高操作系統(tǒng)版本檢查。具體命令是：runinstaller -ignoresysprereqs1. 將oracle clusterware軟件復(fù)制到alice01服務(wù)上，路徑為：/oracle/product/10.2.0/crs2. oracle用戶登錄alice01主機(jī)3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動(dòng)xmanager passive6. xclock測(cè)試圖形應(yīng)用能正常啟動(dòng)7. /runinstaller -ignoresysprereqs啟動(dòng)oracle clusterware安裝程序8. 根據(jù)提示安裝軟件9. 根據(jù)安裝程序提示完成安裝后步驟10. 執(zhí)行crs_stat -t檢查clusterware運(yùn)行狀態(tài)，輸出應(yīng)為：crs_stat -t名稱 類型 目標(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 .6. 安裝database軟件1. 將oracle database軟件復(fù)制到62服務(wù)上，路徑為：/oracle/product/10.2.0/db_12. oracle用戶登錄alice01主機(jī)3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動(dòng)xmanager passive6. xclock測(cè)試圖形應(yīng)用能正常啟動(dòng)7. /runinstaller -ignoresysprereqs啟動(dòng)oracle database安裝程序8. 根據(jù)提示安裝軟件，安裝過程中不創(chuàng)建數(shù)據(jù)庫(kù)9. 根據(jù)安裝程序提示完成安裝后步驟.7. 安裝 clusterware 軟件補(bǔ)丁1. 將oracle 補(bǔ)丁軟件復(fù)制到62服務(wù)上.2. oracle用戶登錄62主機(jī)3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動(dòng)xmanager passive6. xclock測(cè)試圖形應(yīng)用能正常啟動(dòng)7. /runinstaller -ignoresysprereqs啟動(dòng)oracle安裝程序8. 根據(jù)提示安裝軟件，應(yīng)選擇crs_home作為安裝路徑9. 根據(jù)安裝程序提示完成安裝后步驟.8. 安裝 database軟件 補(bǔ)丁1. 將oracle 補(bǔ)丁軟件復(fù)制到62服務(wù)上.2. oracle用戶登錄alice01主機(jī)3. export tmp=/u01/tmp4. export display=客戶端ip:0.05. 啟動(dòng)xmanager passive6. xclock測(cè)試圖形應(yīng)用能正常啟動(dòng)7. /runinstaller -ignoresysprereqs啟動(dòng)oracle安裝程序8. 根據(jù)提示安裝軟件，應(yīng)選擇oracle_home作為安裝路徑9. 根據(jù)安裝程序提示完成安裝后步驟.9. 配置listener1. oracle用戶登錄alice01服務(wù)器2. export display=客戶端ip:0.03. 啟動(dòng)xmanager passive4. xclock測(cè)試圖形應(yīng)用能正常啟動(dòng)5. netca 啟動(dòng)oracle網(wǎng)絡(luò)配置助手6. 選擇cluster配置7. 根據(jù)提示完成listener配置8. 檢查集群狀態(tài)應(yīng)為:2008-09-19 14:43:39alice01 /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 輸出顯示兩臺(tái)服務(wù)器上的listener已自動(dòng)添加到集群中，并且已經(jīng)online.10. 配置asm磁盤組1. oracle用戶登錄alice01服務(wù)器2. export display=客戶端ip:0.03. 啟動(dòng)xmanager passive4. xclock測(cè)試圖形應(yīng)用能正常啟動(dòng)5. dbca 啟動(dòng)數(shù)據(jù)庫(kù)配置助手6. 選擇集群配置7. 選擇配置asm，asm實(shí)例sys用戶口令為oracle8. 創(chuàng)建asm磁盤組，采用外部冗余方式，創(chuàng)建一個(gè)磁盤組：oradata3.2. 數(shù)據(jù)庫(kù)遷移過程3.2.1. 備份生產(chǎn)數(shù)據(jù)庫(kù)(31)由于目前的生產(chǎn)數(shù)據(jù)庫(kù)是非歸檔方式，所以只能進(jìn)行冷備。備份腳本如下：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備份過程中可通過如下的語句查詢備份進(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% 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 2binprompt offmput *3. ftp完成后，比對(duì)兩邊服務(wù)器文件大小。3.2.3. 恢復(fù)62上的數(shù)據(jù)庫(kù)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. 啟動(dòng)數(shù)據(jù)庫(kù)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. 恢復(fù)數(shù)據(jù)庫(kù)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 /