如何在Windows平臺(tái)上安裝SAP iDa

1、如何在Windows平臺(tái)上安裝SAP iDa版本歷史版本 日期 作者文檔介紹1.02008-7-1Jon ShiV1.0文檔介紹本文檔主要描述了如何在Windows平臺(tái)上安裝配置SAP iDA（以后臺(tái)數(shù)據(jù)庫(kù)為Oracle為例）以下是安裝環(huán)境介紹:OS NameMicrosoft(R) Windows(R) Server 2003, Enterprise EditionVersion5.2.3790 Service Pack 1 Build 3790Release 9.2.0.6.0 - Production on Tue Jul 1 01:00:35 2008Oracle9i Enterpri

2、se Edition Release 9.2.0.6.0 - 64bit ProductionPL/SQL Release 9.2.0.6.0 - ProductionBR651I BRTOOLS 6.20 (110)CommVault SIMPANA 7.0 SP3 目 錄文檔介紹3安裝過程5檢查Backint的符號(hào)鏈接21防火墻配置22安裝CommVault Galaxy 7.0 ServicePack 322在CommCell控制臺(tái)上配置SAP實(shí)例23UTIL_FILE 文件配置26基本SAP備份腳本30備份和刪除redo logs腳本示例34離線全備份腳本示例34在線備份腳本示例35關(guān)

3、閉和啟動(dòng)SAP應(yīng)用命令35安裝過程任務(wù)截圖和注解登陸以管理員用戶登陸Windows SAP系統(tǒng)將光盤放入光驅(qū)進(jìn)行安裝，安裝過程與安裝其它數(shù)據(jù)庫(kù)模塊類似。安裝完成后，需要重新啟動(dòng)主機(jī); 安裝CommVault相關(guān)補(bǔ)丁在Windows SAP系統(tǒng)上創(chuàng)建一個(gè)本地用戶，用于配置SAP for ORACLE SID,要求具有的權(quán)限如右圖所示從Windows主機(jī)注冊(cè)表中獲取SAP相關(guān)配置信息(My ComputerHKEY_LOCAL_MACHINESOFTWARESAPSIDEnvironment)，如ORACLE_SID、ORACLE_HOME以及SAPDATA_HOME等配置Oracle SID f

4、or SAP,輸入輸入相關(guān)的配置信息，如ORACLE_SID/ 登陸SAP系統(tǒng)的Windows用戶/Oracle_HOME和SAP DATA PATH等輸入連接字符串等信息輸入用于備份的存儲(chǔ)策略等信息確認(rèn)SAP管理目錄下的backint.exe是CommVault提供的。準(zhǔn)備用于SAP備份用的參數(shù)文件此文件(initBWP.utl)在windows平臺(tái)中可以放在任何目錄下，可以在備份時(shí)，指定其對(duì)應(yīng)路徑名。Note:在Windows平臺(tái)上，不需要修改initBWP.sap文件輸入如右圖所示幾項(xiàng)內(nèi)容CvInstanceNameInstance001CvClientNamecnsvwshs0063n

5、umstreams1準(zhǔn)備腳本開始進(jìn)行備份再次檢查Backint的文件是否正確TaskScreenshot / Notes確認(rèn)SAP Backint文件使用為CommVault提供的文件防火墻配置如果需要，可以在客戶端和CommServe上配置Filrewall的相應(yīng)端口 安裝CommVault Galaxy 7.0 ServicePack 3在CommCell控制臺(tái)上配置備份任務(wù)任 務(wù)截圖/注解登陸到CommCell控制臺(tái)創(chuàng)建一個(gè)子客戶端并使用后置腳本進(jìn)行redo logs和DB的備份Note: 在Windows平臺(tái)運(yùn)行腳本時(shí)，一定要選擇正確的用戶運(yùn)行腳本， 在此次配置中，備份腳本中不包括Se

6、rvice Name等oracle信息，利用”/”登陸系統(tǒng)，需要利用Windows本地用戶運(yùn)行。確認(rèn)SAP實(shí)例創(chuàng)建完成 UTIL_FILE 文件配置以下是SAP UTIL_FILE 示例關(guān)于UTIL_FILE 和brbackup/brrestore 的更多選項(xiàng)和信息，請(qǐng)查看SAP brtools相關(guān)文檔 D:oracleora92databaseinitBWD.sap 注意：在Windows平臺(tái)中不需要對(duì)這個(gè)文件作修改！initBWD.utl”:注意：在Windows平臺(tái)中以下這個(gè)配置文件可以放在任何目錄中，只要在備份腳本中指定其位置即可。numstreams1CvInstanceNameIn

7、stance001CvClientNameCnsvwshs0062基本SAP備份腳本以下命令是brbackup離線備份腳本示例=echo offREM SAP brbackup script for Windows NTset tmpfile=D:oraclescriptbrbackup.logSET ORACLE_SID=BWDSET ORACLE_HOME=D:oracleora92SET SAPDATA_HOME=e:oracleBWDREM Starting brbackup offline backup action on Windows NTD:usrsapBWDSYSexerun

8、brbackup.exe -t offline_force -d util_file -c -parfile D:oracleora92databaseinitBWD.utl -u system/suzhou05 %tmpfile%=以下命令及腳本是用于redo log的備份及輸出示例：=echo offREM SAP brarchive script for Windows NTset tmpfile=D:oraclescriptbrarchive.logSET ORACLE_SID=BWDSET ORACLE_HOME=D:oracleora92SET SAPDATA_HOME=e:ora

9、cleBWDREM Starting brarchive action on Windows NTD:usrsapBWDSYSexerunbrarchive.exe -s -c -d util_file -parfile D:oracleora92databaseinitBWD.utl -u system/suzhou05 %tmpfile%=日志輸出相關(guān)信息為：BR0002I BRARCHIVE 6.40 (15)BR0006I Start of offline redo log processing: adyglwqn.sve 2008-07-01 02.34.05BR0477I Orac

10、le pfile D:oracleora92databaseinitBWD.ora created from spfile D:oracleora92databasespfileBWD.oraBR0280I BRARCHIVE time stamp: 2008-07-01 02.34.06BR0008I Offline redo log processing for database instance: BWDBR0009I BRARCHIVE action ID: adyglwqnBR0010I BRARCHIVE function ID: sveBR0048I Archive functi

11、on: saveBR0011I 484 offline redo log files found for processing, total size 24124.172 MBBR0130I Backup device type: util_fileBR0109I Files will be saved by backup utilityBR0126I Unattended mode active - no operator confirmation requiredBR0280I BRARCHIVE time stamp: 2008-07-01 02.34.06BR0229I Calling

12、 backup utility.BR0278I Command output of D:usrsapBWDSYSexerunbackint.exe -u BWD -f backup -i e:oracleBWDsaparch.adyglwqn.lst -t file -p D:oracleora92databaseinitBWD.utl -c:Number of streams desired= Number of files to backup=- Output of backup -BI_BACKUP=BI_CALLER=BI_REQUEST=- Parameter Specified -

13、CvInstanceName=CvClientName=numstreams=CV_restCopyPrec=srccrossclient=- backint Command Line -backintCmd=D:usrsapBWDSYSexerunbackint.exe -u BWD -f backup -i e:oracleBWDsaparch.adyglwqn.lst -t file -p D:oracleora92databaseinitBWD.utl -c CommServeHostName=cnsvwshs0225CommClientHostName=Galaxy CommCell

14、ID=2Galaxy ClientID=7Backup has been requestedGalaxy ClientInstanceID=73Galaxy ClientAppType=61Galaxy ClientAppID=413Success in getting Job id=4782 Token=Success in allocateStreamAttaching CommServer SessionretCode=0 setupPipelineBR0280I BRARCHIVE time stamp: 2008-07-01 02.36.18#ARCHIVE. D:oracleBWD

15、oraarchBWDarchARC07847.001#SAVED. SAP_1012669_4782 #2:23:2096BR0280I BRARCHIVE time stamp: 2008-07-01 02.36.24#ARCHIVE. D:oracleBWDoraarchBWDarchARC07848.001#SAVED. SAP_1012669_4782 #2:23:2097BR0280I BRARCHIVE time stamp: 2008-07-01 02.36.31#ARCHIVE. D:oracleBWDoraarchBWDarchARC07849.001#SAVED. SAP_

16、1012669_4782 #2:23:2098BR0280I BRARCHIVE time stamp: 2008-07-01 02.36.37#ARCHIVE. D:oracleBWDoraarchBWDarchARC07850.001#SAVED. SAP_1012669_4782 #2:23:2099.BR0280I BRARCHIVE time stamp: 2008-07-01 03.20.04#ARCHIVE. D:oracleBWDoraarchBWDarchARC08279.001#SAVED. SAP_1012669_4782 #2:23:2559BR0280I BRARCH

17、IVE time stamp: 2008-07-01 03.20.10#ARCHIVE. D:oracleBWDoraarchBWDarchARC08280.001#SAVED. SAP_1012669_4782 #2:23:2560備份作業(yè)相關(guān)信息，可以在CommCell控制臺(tái)上查看相關(guān)任務(wù)信息備份和刪除redo logs腳本示例echo offREM SAP brarchive script for Windows NTset tmpfile=D:oraclescriptbrarchive.logSET ORACLE_SID=BWDSET ORACLE_HOME=D:oracleora92

18、SET SAPDATA_HOME=e:oracleBWDREM Starting brarchive action on Windows NTD:usrsapBWDSYSexerunbrarchive.exe -sd -c -d util_file -parfile D:oracleora92databaseinitBWD.utl -u system/suzhou05 %tmpfile%離線全備份腳本示例echo offREM SAP brbackup script for Windows NTset tmpfile=D:oraclescriptbrbackup.logSET ORACLE_SID=BWDSET ORACLE_HOME=D:oracleora92SET SAPDATA_HOME=e:oracleBWDREM Starting brbackup offline backup action on Windows NTD:usrsapBWDSYSexerunbrbackup.exe -t offline_force -d util_file -c -p