《NBU70OracleforAIX安装配置手册6154.docx》由会员分享，可在线阅读，更多相关《NBU70OracleforAIX安装配置手册6154.docx（52页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、NBU7.0 Oracle for AIX安装配置手册浙江星汉信息技技术有限公司司目 录一、NBU 77.0 AIIX客户端安安装配置3二、NBU 77.0 AIIX客户端脚脚本配置8三、NBU 77.0 Caatalogg目录库备份份设置17四、NBU 77.0 orracle for aaix备份作作业设置22一、NBU 77.0 AIXX客户端安装配置1、先设置客户户端的hossts文件，包包括备份服务务器的hostss也要对应双向向解析。#rootp550bb:/#mmore /etc/hoosts127.0.00.1 looopbackk locallhost # looopback
2、k (lo00) namme/adddress10.10.110.1 p5500a_booot1 p550aa20.20.220.1 p5500a_booot2172.16.1.7 p5500a_perr10.10.110.2 p5500b_booot1 p550bb20.20.220.2 p5500b_booot2172.16.1.8 p5500b_perr172.16.1.9 ora_svr=NBBU bacckup sserverr=172.16.1.2422 hpddl380-backuup 2、#放入NBBU 7.00 For AIX光盘盘，在系统挂挂载安装盘rootpp550a:/
3、dev#mounnt -v cdrfss -o rro /deev/cd00 /mntt 3、执行安装，并选择2客户端安装，提示选择Y继续 rootp550aa:/mnt#./insttall然后根据提示输输入备份服务务器的名称hhpdl3880-bacckup（一一定要为备份份服务器名，不不建议用IPP）, 提示选择Y继续选择后则开始安安装软件如下下：安装结束后选择择3退出4、修改客户端端NBU配置参参数rootpp550b:/usr/openvv/netbaackup#vi bp.coonf修改双机HACCMP系统一一台P550的/usr/openvv/netbaackup/bp.coon
4、f配置文文件信息SERVER = hpddl380-backuupCLIENT_NAME = p5550a改为SERVER = hpddl380-backuupCLIENT_NAME = oraa_svrREQUIREED_INTTERFACCE = oora_svvr5、修改客户端端oraclle数据库为为归档模式rootpp550b:/usr/openvv/netbaackup#su - ooracleeoracleep5500b:/hoome/orracle$sqlpplus /as ssysdbaaSQL*Pluus: Reeleasee 10.22.0.4.0 - PProducct
5、ion on Frri Febb 25 115:48:48 20011Copyrigght (cc) 19882, 20007, OOraclee. Alll Rigghts RReservved.Connectted too:Oracle Databbase 110g Ennterprrise EEditioon Rellease 10.2.0.4.00 - 644bit PProducctionWith thhe Parrtitiooning, OLAPP, Datta Minning aand Reeal Appplicaation Testiing opptionssSQL arrch
6、ivee log list;Databasse logg modee AArchivve ModdeAutomattic arrchivaal EEnableedArchivee desttinatiion /oraclle/prooduct/10.2.0/dbss/archhOldest onlinne logg sequuence 2255Next loog seqquencee to aarchivve 2257Currentt log sequeence 2257SQL shhutdowwn immmediatteDatabasse cloosed.Databasse dissmoun
7、tted.ORACLE instaance sshut ddown.SQL sttartupp mounnt; ORACLE instaance sstarteed.Total SSystemm Globbal Arrea 166106122736 bbytesFixed SSize 20844400 bbytesVariablle Sizze 44362088080 bbytesDatabasse Bufffers 111576277904 bbytesRedo Buufferss 146922352 bbytesDatabasse mouunted.SQL allter ddatabaas
8、e arrchiveelog;Databasse alttered.SQL allter ssystemm set log_aarchivve_desst_1=locattion=/archllog sscope=spfille;System alterred.SQL shhutdowwn immmediatteDatabasse cloosed.Databasse dissmountted.ORACLE instaance sshut ddown.SQL sttartuppORACLE instaance sstarteed.Total SSystemm Globbal Arrea 1661
9、06122736 bbytesFixed SSize 20844400 bbytesVariablle Sizze 44362088080 bbytesDatabasse Bufffers 111576277904 bbytesRedo Buufferss 146922352 bbytesDatabasse mouunted.Databasse opeened.SQL arrchivee log list;Databasse logg modee AArchivve ModdeAutomattic arrchivaal EEnableedArchivee desttinatiion /arch
10、llogOldest onlinne logg sequuence 2255Next loog seqquencee to aarchivve 2257Currentt log sequeence 2257SQL crreate pfilee fromm spfiile;File crreatedd.至此oraclle数据库归归档开启完成成；6、oraclle用户执行备份份软件NBUU和oraclle数据库连连接库程序oraccle_liinkrootpp550b:/#suu - orracleoracleep5500b:/hoome/orracle$cd /usr/openvv/netbaa
11、ckup/binoracleep5500b:/ussr/openvv/netbaackup/bin$./oraclle_linnk提示选择Y继续续至此NBU的ooraclee数据库客户端安装完成；二、NBU 77.0 AIIX客户端脚脚本配置1、 先创建相关目录录和文件rootpp550b:/#cdd /usrr/openvvrootpp550b:/usr/openvv#mkdiir contrrolfillerootpp550b:/usr/openvv#mkdiir orasccriptssrootpp550b:/usr/openvv#cd conntrolffilerootpp550b:/
12、usr/openvv/contrrolfille#toucch conntrol.orarootpp550b:/usr/openvv/contrrolfille#cd .rootpp550b:/usr/openvv#cd oraascripptsrootpp550b:/usr/openvv/orasccriptss#toucch aixx_ora_full.sh2、 相关目录和文件件赋予属主和和权限rootpp550b:/usr/openvv/orasccriptss#cd .rootpp550b:/usr/openvv#ls -ltotal 772drwxr-xxr-x 2 rooot sy
13、sttem 2566 Feb 25 166:03 ccontroolfileedrwxr-xxr-x 5 rooot bin 40966 Feb 25 155:40 jjavadrwxr-xxr-x 7 rooot bin 81922 Feb 25 155:37 llibdrwxr-xxr-x 5 rooot systtem 2566 Feb 25 155:40 llogsdrwxr-xxr-x 2 rooot bin 2566 Jan 05 20010 mmsgdrwxr-xxr-x 8 rooot bin 40966 Feb 25 155:40 nnetbacckupdrwxr-xxr-x
14、 2 rooot systtem 2566 Feb 25 166:04 oorascrripts-r-r-r- 1 rooot binn 54335 Febb 25 115:40 regidd.19922-11.ccom.syymanteec,Entterpriise_neetbackkup-7.0.0.00_1.swwidtaggdrwxr-xxr-x 2 rooot bin 40966 Jan 05 20010 rresourrcesdrwxr-xxr-x 2 rooot bin 2566 Jan 05 20010 sshare-r-r-r- 1 rooot binn 54335 Jann
15、 05 22010 swidttag.xmmldrwxr-xxr-x 2 rooot bin 2566 Feb 25 155:43 ttmpdrwxr-xxr-x 5 rooot bin 2566 Feb 25 155:37 vvarrootpp550b:/usr/openvv#chowwn -R oraclle:dbaa contrrolfillerootpp550b:/usr/openvv#chmood -R 777 ccontroolfileerootpp550b:/usr/openvv#chowwn -R oraclle:dbaa orasccriptssrootpp550b:/usr
16、/openvv#chmood -R 777 oorascrriptsrootpp550b:/usr/openvv#ls -ltotal 772drwxrwxxrwx 2 ooraclee dbba 2256 Feeb 25 16:033 conttrolfiiledrwxr-xxr-x 5 rooot bin 40966 Feb 25 155:40 jjavadrwxr-xxr-x 7 rooot bin 81922 Feb 25 155:37 llibdrwxr-xxr-x 5 rooot systtem 2566 Feb 25 155:40 llogsdrwxr-xxr-x 2 rooot
17、 bin 2566 Jan 05 20010 mmsgdrwxr-xxr-x 8 rooot bin 40966 Feb 25 155:40 nnetbacckupdrwxrwxxrwx 2 ooraclee dbba 2256 Feeb 25 16:044 orasscriptts-r-r-r- 1 rooot binn 54335 Febb 25 115:40 regidd.19922-11.ccom.syymanteec,Entterpriise_neetbackkup-7.0.0.00_1.swwidtaggdrwxr-xxr-x 2 rooot bin 40966 Jan 05 20
18、010 rresourrcesdrwxr-xxr-x 2 rooot bin 2566 Jan 05 20010 sshare-r-r-r- 1 rooot binn 54335 Jann 05 22010 swidttag.xmmldrwxr-xxr-x 2 rooot bin 2566 Feb 25 155:43 ttmpdrwxr-xxr-x 5 rooot bin 2566 Feb 25 155:37 vvar3、 编辑NBU备份份数据库的RRman脚本本aix_oora_fuull.shhrootpp550b:/usr/openvv/orasccriptss#vi aixx_ora_
19、full.sh粘贴如下内容（完完全备份orracle数数据库和归档档日志，并删删除备份好的的归档日志，注注意修改实例例名oraccle_siid和oraclle_homme和实际环环境一致）=#!/bin/sh# $Headder: hhot_daatabasse_bacckup.ssh,v 1.99 20022/02/006 16:48:566 lstrrub Sttab $#bcpyrgght#*#* $VRTTScprgght: CCopyriight 11993 - 20022 VERIITAS SSoftwaare Coorporaation, All Rightts Resserv
20、edd $ *#*#ecpyrgght# -# hott_dataabase_backuup.sh# -# Thiss scriipt usses Reecoverry Mannager to taake a hot (inconnsisteent) ddatabaase# backkup. AA hot backuup is inconnsisteent beecausee porttions of thhe dattabasee are# beinng moddifiedd and writtten too the disk whilee the backuup is progrressi
21、nng.# You must run yyour ddatabaase inn ARCHHIVELOOG modde to make hot bbackupps. Itt is# assuumed tthat tthis sscriptt willl be eexecutted byy userr roott. In orderr for RMAN# to wwork pproperrly wee swittch usser (ssu -) to thhe oraacle ddba acccountt befoore# execcutionn. If this scrippt runns un
22、dder a user accouunt thhat haas Oraacle ddba# privvilegee, it will be exxecuteed usiing thhis ussers accouunt.# -# -# Deterrmine the uuser wwhich is exxecutiing thhis sccript.# - CUSER=id |ccut -dd( -f2 | cut -d ) -f1 # -# Put ooutputt in .out. Channge ass desiired.# Note: outpput diirectoory reequi
23、rees wriite peermisssion.# -RMAN_LOOG_FILLE=$00.datee +%Y%m%d%HH%M%S.out# -# You mmay waant too deleete thhe outtput ffile sso thaat bacckup iinformmationn doess# not aaccumuulate. If not, delette thee folllowingg linees.# -if -ff $RMMAN_LOOG_FILLE then rm -f $RMAAN_LOGG_FILEEfi# -# Initiializee the
24、 log ffile.# - echo $RMAAN_LOGG_FILEEchmod 6666 $RRMAN_LLOG_FIILE # -# Log tthe sttart oof thiis scrript.# - echo Sccript $0 $RMAAN_LOGG_FILEEecho = sttartedd on date = $RMAN_LOG_FFILEecho $RMAAN_LOGG_FILEE # -# Replaace /ddb/oraacle/pproducct/oraa81, bbelow, withh the Oraclle homme patth.# -ORACLE_
25、HOME=/oraccle/prroductt/10.22.0export ORACLLE_HOMME# -# Replaace orra81, beloww, witth thee Oraccle SIID of the ttargett dataabase.# -ORACLE_SID=oorclywwexport ORACLLE_SIDD# -# Replaace orra81, beloww, witth thee Oraccle DBBA useer id (accoount).# -ORACLE_USER=oraclle# -# Set tthe taarget conneect s
26、ttring.# Replaace ssys/maanagerr, beelow, with the ttargett connnect sstringg.# -TARGET_CONNEECT_STTR= / # -# Set tthe Orracle Recovvery MManageer namme.# -RMAN=$OORACLEE_HOMEE/bin/rman# -# Printt out the vvalue of thhe varriablees sett by tthis sscriptt.# -echo $RMAAN_LOGG_FILEEecho RMANN: $RMMAN $
27、RMMAN_LOOG_FILLEecho ORACCLE_SIID: $OORACLEE_SID $RMAN_LOG_FFILEecho ORACCLE_USSER: $ORACLLE_USEER $RMAAN_LOGG_FILEEecho ORACCLE_HOOME: $ORACLLE_HOMME $RMAAN_LOGG_FILEE# -# Printt out the vvalue of thhe varriablees sett by bbphdb.# -echo $RMMAN_LOOG_FILLEecho NB_OORA_FUULL: $NB_ORRA_FULLL $RMAAN_LOG
28、G_FILEEecho NB_OORA_INNCR: $NB_ORRA_INCCR $RMAAN_LOGG_FILEEecho NB_OORA_CIINC: $NB_ORRA_CINNC $RMAAN_LOGG_FILEEecho NB_OORA_SEERV: $NB_ORRA_SERRV $RMAAN_LOGG_FILEEecho NB_OORA_POOLICY: $NB_ORA_PPOLICYY $RMANN_LOG_FILE# -# NOTE: Thiss scriipt asssumess thatt the databbase iis prooperlyy openned. IIf
29、dessired,# this wouldd be tthe pllace tto verrify tthat.# -echo $RMAAN_LOGG_FILEE# -# If thhis sccript is exxecuteed froom a NNetBacckup sscheduule, NNetBacckup# sets an NBB_ORA envirronmennt varriablee baseed on the sscheduule tyype.# The NNB_ORAA variiable is thhen ussed too dynaamicallly seet BAC
30、CKUP_TTYPE# For eexamplle, whhen:# sscheduule tyype iss BACKKUP_TYYPE iss# - -# Autommatic Full INCREEMENTAAL LEVVEL=0# Autommatic Diffeerentiial Inncremeental INCREEMENTAAL LEVVEL=1# Autommatic Cumullativee Incrrementtal INCREEMENTAAL LEVVEL=1 CUMULLATIVEE# # For uuser iinitiaated bbackupps, BAACKU
31、P_TYPE defauults tto inccremenntal# levell 0 (ffull). To changge thee defaault ffor a user initiiated# backuup to increementaal or increementaal cummulatiive, uuncommment# one oof thee folllowingg two liness.# BACKUUP_TYPPE=INNCREMEENTAL LEVELL=1# BACKUUP_TYPPE=INNCREMEENTAL LEVELL=1 CUUMULATTIVE# #
32、 Note that we usse inccremenntal llevel 0 to speciify fuull baackupss.# That is beecausee, altthoughh theyy are identtical in coontentt, onlly# the iincremmentall leveel 0 bbackupp can have increementaal bacckups of# levell 0 appliied too it.# - if $NB_ORRA_FULLL = 1 then echoo Fulll bacckup rrequessted $RRMAN_LLOG_FIILE BACKKUP_TYYPE=IINCREMMENTALL LEVEEL=0 elif $NB_ORA_IINCR = 1 then