安装配置手册模板

安装配置手册模板资料内容仅供您学习参考，如有不当或者侵权，请联系改正或者删除。NBU7.0OracleforAIX安装配置手册浙江星汉信息技术有限公司目录一、NBU7.0AIX客户端安装配置 3二、NBU7.0AIX客户端脚本配置 8三、NBU7.0Catalog目录库备份设置 17四、NBU7.0oracleforaix备份作业设置 22

一、NBU7.0AIX客户端安装配置1、先设置客户端的hosts文件,包括备份服务器的hosts也要对应双向解析。#[root@p550b:/]#more/etc/hostsloopbacklocalhost#loopback(lo0)name/addressp550a_boot1p550ap550a_boot2p550a_perp550b_boot1p550bp550b_boot2p550b_perora_svr=====NBUbackupserver=====42hpdl380-backup2、#放入NBU7.0ForAIX光盘,在系统挂载安装盘[root@p550a:/dev]#mount-vcdrfs-oro/dev/cd0/mnt3、执行安装,并选择2客户端安装,提示选择Y继续[root@p550a:/mnt]#./install然后根据提示输入备份服务器的名称hpdl380-backup(一定要为备份服务器名,不建议用IP),提示选择Y继续选择后则开始安装软件如下:安装结束后选择3退出4、修改客户端NBU配置参数[root@p550b:/usr/openv/netbackup]#vibp.conf修改双机HACMP系统一台P550的/usr/openv/netbackup/bp.conf配置文件信息SERVER=hpdl380-backupCLIENT_NAME=p550a改为SERVER=hpdl380-backupCLIENT_NAME=ora_svrREQUIRED_INTERFACE=ora_svr5、修改客户端oracle数据库为归档模式[root@p550b:/usr/openv/netbackup]#su-oracle[oracle@p550b:/home/oracle]$sqlplus"/assysdba"SQL*Plus:Release.0-ProductiononFriFeb2515:48:48Copyright(c)1982,,Oracle.AllRightsReserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease.0-64bitProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsSQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/oracle/product/10.2.0/dbs/archOldestonlinelogsequence255Nextlogsequencetoarchive257Currentlogsequence257SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupmount;ORACLEinstancestarted.TotalSystemGlobalAreabytesFixedSize2084400bytesVariableSizebytesDatabaseBuffersbytesRedoBuffers14692352bytesDatabasemounted.SQL>alterdatabasearchivelog;Databasealtered.SQL>altersystemsetlog_archive_dest_1='location=/archlog'scope=spfile;Systemaltered.SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>startupORACLEinstancestarted.TotalSystemGlobalAreabytesFixedSize2084400bytesVariableSizebytesDatabaseBuffersbytesRedoBuffers14692352bytesDatabasemounted.Databaseopened.SQL>archiveloglist;DatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination/archlogOldestonlinelogsequence255Nextlogsequencetoarchive257Currentlogsequence257SQL>createpfilefromspfile;Filecreated.至此oracle数据库归档开启完成;

6、oracle用户执行备份软件NBU和oracle数据库连接库程序oracle_link[root@p550b:/]#su-oracle[oracle@p550b:/home/oracle]$cd/usr/openv/netbackup/bin[oracle@p550b:/usr/openv/netbackup/bin]$./oracle_link提示选择Y继续至此NBU的oracle数据库客户端安装完成;

二、NBU7.0AIX客户端脚本配置先创立相关目录和文件[root@p550b:/]#cd/usr/openv[root@p550b:/usr/openv]#mkdircontrolfile[root@p550b:/usr/openv]#mkdirorascripts[root@p550b:/usr/openv]#cdcontrolfile[root@p550b:/usr/openv/controlfile]#touchcontrol.ora[root@p550b:/usr/openv/controlfile]#cd..[root@p550b:/usr/openv]#cdorascripts[root@p550b:/usr/openv/orascripts]#touchaix_ora_full.sh相关目录和文件赋予属主和权限[root@p550b:/usr/openv/orascripts]#cd..[root@p550b:/usr/openv]#ls-ltotal72drwxr-xr-x2rootsystem256Feb2516:03controlfiledrwxr-xr-x5rootbin4096Feb2515:40javadrwxr-xr-x7rootbin8192Feb2515:37libdrwxr-xr-x5rootsystem256Feb2515:40logsdrwxr-xr-x2rootbin256Jan05msgdrwxr-xr-x8rootbin4096Feb2515:40netbackupdrwxr-xr-x2rootsystem256Feb2516:04orascripts-r--r--r--1rootbin5435Feb2515:40.symantec,Enterprise_netbackup-_1.swidtagdrwxr-xr-x2rootbin4096Jan05resourcesdrwxr-xr-x2rootbin256Jan05share-r--r--r--1rootbin5435Jan05swidtag.xmldrwxr-xr-x2rootbin256Feb2515:43tmpdrwxr-xr-x5rootbin256Feb2515:37var[root@p550b:/usr/openv]#chown-Roracle:dbacontrolfile[root@p550b:/usr/openv]#chmod-R777controlfile[root@p550b:/usr/openv]#chown-Roracle:dbaorascripts[root@p550b:/usr/openv]#chmod-R777orascripts[root@p550b:/usr/openv]#ls-ltotal72drwxrwxrwx2oracledba256Feb2516:03controlfiledrwxr-xr-x5rootbin4096Feb2515:40javadrwxr-xr-x7rootbin8192Feb2515:37libdrwxr-xr-x5rootsystem256Feb2515:40logsdrwxr-xr-x2rootbin256Jan05msgdrwxr-xr-x8rootbin4096Feb2515:40netbackupdrwxrwxrwx2oracledba256Feb2516:04orascripts-r--r--r--1rootbin5435Feb2515:40.symantec,Enterprise_netbackup-_1.swidtagdrwxr-xr-x2rootbin4096Jan05resourcesdrwxr-xr-x2rootbin256Jan05share-r--r--r--1rootbin5435Jan05swidtag.xmldrwxr-xr-x2rootbin256Feb2515:43tmpdrwxr-xr-x5rootbin256Feb2515:37var编辑NBU备份数据库的Rman脚本aix_ora_full.sh[root@p550b:/usr/openv/orascripts]#viaix_ora_full.sh粘贴如下内容(完全备份oracle数据库和归档日志,并删除备份好的归档日志,注意修改实例名oracle_sid和oracle_home和实际环境一致)=================================================================#!/bin/sh#$Header:hot_database_backup.sh,v1.9/02/0616:48:56lstrubStab$##bcpyrght#***************************************************************************#*$VRTScprght:Copyright1993-VERITASSoftwareCorporation,AllRightsReserved$*#***************************************************************************#ecpyrght###hot_database_backup.sh##ThisscriptusesRecoveryManagertotakeahot(inconsistent)database#backup.Ahotbackupisinconsistentbecauseportionsofthedatabaseare#beingmodifiedandwrittentothediskwhilethebackupisprogressing.#YoumustrunyourdatabaseinARCHIVELOGmodetomakehotbackups.Itis#assumedthatthisscriptwillbeexecutedbyuserroot.InorderforRMAN#toworkproperlyweswitchuser(su-)totheoracledbaaccountbefore#execution.IfthisscriptrunsunderauseraccountthathasOracledba#privilege,itwillbeexecutedusingthisuser'saccount.###Determinetheuserwhichisexecutingthisscript.#CUSER=`id|cut-d"("-f2|cut-d")"-f1`##Putoutputin<thisfilename>.out.Changeasdesired.#Note:outputdirectoryrequireswritepermission.#RMAN_LOG_FILE=${0}.`date+%Y%m%d%H%M%S`.out##Youmaywanttodeletetheoutputfilesothatbackupinformationdoes#notaccumulate.Ifnot,deletethefollowinglines.#if[-f"$RMAN_LOG_FILE"]thenrm-f"$RMAN_LOG_FILE"fi##Initializethelogfile.#echo>>$RMAN_LOG_FILEchmod666$RMAN_LOG_FILE##Logthestartofthisscript.#echoScript$0>>$RMAN_LOG_FILEecho====startedon`date`====>>$RMAN_LOG_FILEecho>>$RMAN_LOG_FILE##Replace/db/oracle/product/ora81,below,withtheOraclehomepath.#ORACLE_HOME=/oracle/product/10.2.0exportORACLE_HOME##Replaceora81,below,withtheOracleSIDofthetargetdatabase.#ORACLE_SID=orclywexportORACLE_SID##Replaceora81,below,withtheOracleDBAuserid(account).#ORACLE_USER=oracle##Setthetargetconnectstring.#Replace"sys/manager",below,withthetargetconnectstring.#TARGET_CONNECT_STR=/##SettheOracleRecoveryManagername.#RMAN=$ORACLE_HOME/bin/rman##Printoutthevalueofthevariablessetbythisscript.#echo>>$RMAN_LOG_FILEecho"RMAN:$RMAN">>$RMAN_LOG_FILEecho"ORACLE_SID:$ORACLE_SID">>$RMAN_LOG_FILEecho"ORACLE_USER:$ORACLE_USER">>$RMAN_LOG_FILEecho"ORACLE_HOME:$ORACLE_HOME">>$RMAN_LOG_FILE##Printoutthevalueofthevariablessetbybphdb.#echo>>$RMAN_LOG_FILEecho"NB_ORA_FULL:$NB_ORA_FULL">>$RMAN_LOG_FILEecho"NB_ORA_INCR:$NB_ORA_INCR">>$RMAN_LOG_FILEecho"NB_ORA_CINC:$NB_ORA_CINC">>$RMAN_LOG_FILEecho"NB_ORA_SERV:$NB_ORA_SERV">>$RMAN_LOG_FILEecho"NB_ORA_POLICY:$NB_ORA_POLICY">>$RMAN_LOG_FILE##NOTE:Thisscriptassumesthatthedatabaseisproperlyopened.Ifdesired,#thiswouldbetheplacetoverifythat.#echo>>$RMAN_LOG_FILE##IfthisscriptisexecutedfromaNetBackupschedule,NetBackup#setsanNB_ORAenvironmentvariablebasedonthescheduletype.#TheNB_ORAvariableisthenusedtodynamicallysetBACKUP_TYPE#Forexample,when:#scheduletypeisBACKUP_TYPEis##AutomaticFullINCREMENTALLEVEL=0#AutomaticDifferentialIncrementalINCREMENTALLEVEL=1#AutomaticCumulativeIncrementalINCREMENTALLEVEL=1CUMULATIVE##Foruserinitiatedbackups,BACKUP_TYPEdefaultstoincremental#level0(full).Tochangethedefaultforauserinitiated#backuptoincrementalorincrementalcumulative,uncomment#oneofthefollowingtwolines.#BACKUP_TYPE="INCREMENTALLEVEL=1"#BACKUP_TYPE="INCREMENTALLEVEL=1CUMULATIVE"##Notethatweuseincrementallevel0tospecifyfullbackups.#Thatisbecause,althoughtheyareidenticalincontent,only#theincrementallevel0backupcanhaveincrementalbackupsof#level>0appliedtoit.#if["$NB_ORA_FULL"="1"]thenecho"Fullbackuprequested">>$RMAN_LOG_FILEBACKUP_TYPE="INCREMENTALLEVEL=0"elif["$NB_ORA_INCR"="1"]thenecho"Differentialincrementalbackuprequested">>$RMAN_LOG_FILEBACKUP_TYPE="INCREMENTALLEVEL=1"elif["$NB_ORA_CINC"="1"]thenecho"Cumulativeincrementalbackuprequested">>$RMAN_LOG_FILEBACKUP_TYPE="INCREMENTALLEVEL=1CUMULATIVE"elif["$BACKUP_TYPE"=""]thenecho"Default-Fullbackuprequested">>$RMAN_LOG_FILEBACKUP_TYPE="INCREMENTALLEVEL=0"fi##CallRecoveryManagertoinitiatethebackup.Thisexampledoesnotusea#RecoveryCatalog.Ifyouchoosetouseone,replacetheoption'nocatalog'#fromthermancommandlinebelowwiththe#'rcvcat<userid>/<passwd>@<tnsalias>'statement.##Note:AnyenvironmentvariablesneededatruntimebyRMAN#mustbesetandexportedwithintheswitchuser(su)command.##Backsupthewholedatabase.Thisbackupispartoftheincremental#strategy(thismeansitcanhaveincrementalbackupsoflevels>0#appliedtoit).##Wedonotneedtoexplicitlyrequestthecontrolfiletobeincluded#inthisbackup,asitisautomaticallyincludedeachtimefile1of#thesystemtablespaceisbackedup(theinference:asitisawhole#databasebackup,file1ofthesystemtablespacewillbebackedup,#hencethecontrolfilewillalsobeincludedautomatically).##Typically,alevel0backupwouldbedoneatleastonceaweek.##Thescenarioassumes:#oyouarebackingyourdatabaseuptotwotapedrives#oyouwanteachbackupsettoincludeamaximumof5files#oyouwishtoincludeofflinedatafiles,andread-onlytablespaces,#inthebackup#oyouwantthebackuptocontinueifanyfilesareinaccessible.#oyouarenotusingaRecoveryCatalog#oyouareexplicitlybackingupthecontrolfile.Sinceyouare#specifyingnocatalog,thecontrolfilebackupthatoccurs#automaticallyastheresultofbackingupthesystemfileis#notsufficient;itwillnotcontainrecordsforthebackupthat#iscurrentlyinprogress.#oyouwanttoarchivethecurrentlog,backupallthe#archivelogsusingtwochannels,puttingamaximumof20logs#inabackupset,anddeletingthemoncethebackupiscomplete.##Notethattheformatstringisconstructedtoguaranteeuniquenessand#toenhanceNetBackupforOraclebackupandrestoreperformance.###NOTEWHENUSINGTNSALIAS:Whenconnectingtoadatabase#usingaTNSalias,youmustuseasendcommandoraparmsoperandto#specifyenvironmentvariables.Inotherwords,whenaccessingadatabase#throughalistener,theenvironmentvariablessetatthesystemlevelarenot#visiblewhenRMANisrunning.Formoreinformationontheenvironment#variables,pleaserefertotheNetBackupforOracleAdmin.Guide.##CMD_STR="ORACLE_HOME=$ORACLE_HOMEexportORACLE_HOMEORACLE_SID=$ORACLE_SIDexportORACLE_SID$RMANtarget/nocatalogmsglog$RMAN_LOG_FILEappend<<EOFRUN{ALLOCATECHANNELch00TYPE'SBT_TAPE';SEND'NB_ORA_POLICY=aix_ora_full';BACKUP$BACKUP_TYPESKIPINACCESSIBLETAGhot_db_bk_level0FILESPERSET30#recommendedformatFORMAT'bk_%s_%p_%t'DATABASE;sql'altersystemarchivelogcurrent';RELEASECHANNELch00;#backupallarchivelogsALLOCATECHANNELch00TYPE'SBT_TAPE';SEND'NB_ORA_POLICY=aix_ora_full';BACKUPfilesperset20FORMAT'al_%s_%p_%t'ARCHIVELOGALLDELETEINPUT;RELEASECHANNELch00;##Note:Duringtheprocessofbackingupthedatabase,RMANalsobacksupthe#controlfile.Thisversionofthecontrolfiledoesnotcontainthe#informationaboutthecurrentbackupbecause"nocatalog"hasbeenspecified.#Tooincludetheinformationaboutthecurrentbackup,thecontrolfileshould#bebackedupasthelaststepoftheRMANsection.Thisstepwouldnotbe#necessaryifwewereusingarecoverycatalog.#ALLOCATECHANNELch00TYPE'SBT_TAPE';BACKUP#recommendedformatFORMAT'cntrl_%s_%p_%t'CURRENTCONTROLFILE;RELEASECHANNELch00;ALLOCATECHANNELch00TYPEDISK;COPYCURRENTCONTROLFILEto'/usr/openv/controlfile/control.ora';RELEASECHANNELch00;}EOF"#Initiatethecommandstringif["$CUSER"="root"]thensu-$ORACLE_USER-c"$CMD_STR">>$RMAN_LOG_FILERSTAT=$?else/usr/bin/sh-c"$CMD_STR">>$RMAN_LOG_FILERSTAT=$?fi##Logthecom