NBU SAP brtools备份配置.docx

NBU SAP brtools备份配置.docx

《NBU SAP brtools备份配置.docx》由会员分享，可在线阅读，更多相关《NBU SAP brtools备份配置.docx（28页珍藏版）》请在冰豆网上搜索。

NBUSAPbrtools备份配置

SAPbrtools备份配置

1、安装NBU7.0或者7.5

安装过程略

2、配置Windows上NetBackupClientServiceforNetBackupforSAP的登录帐户

由于在默认情况下，NetBackup客户端服务是以SYSTEM帐户启动的，因此，还必须特别注意数据库用户身份验证。

如果您使用的是操作系统身份验证而不是密码，则SYSTEM帐户不具备连接到目标数据库的权限。

如果使用操作系统身份验证，请在具有SYSDBA权限的帐户下运行NetBackup客户端服务。

注意：

在群集环境中，在群集中的每个数据库节点上执行这些步骤。

对于脱离主机

备份，在备用客户端上执行这些步骤。

配置NetBackup客户端服务的登录帐户

1打开Windows的“服务”应用程序。

2双击“NetBackup客户端服务”条目。

3单击“登录”选项卡。

4键入具有SYSDBA权限的帐户名称。

5键入密码。

6单击“确定”。

7停止并启动NetBackup客户端服务。

8关闭服务控制面板应用程序。

3、复制NetBackupforSAP二进制文件

将backint.exe从NetBackup安装目录复制到SAP工具目录。

例如，假设Oracle实例名称为CER，则输入以下命令：

copyinstall_path\NetBackup\bin\backint.exe

c:

\usr\sap\CER\sys\exe\run

拷贝C:

\ProgramFiles\Veritas\NetBackup\bin\backint.exe到D:

\usr\sap\IDS\SYS\exe\uc\NTAMD64目录下。

修改windows系统的环境变更，添加path路径，使用setpath="C:

\ProgramFiles\Veritas\NetBackup\bin",或者

“我的电脑→属性→高级”标签的“环境变量”按钮设置，设置path，添加：

C:

\ProgramFiles\Veritas\NetBackup\bin

4、修改oracle_home\database目录下：

initSID.utl文件。

1）检查%ORACLE_HOME%\database目录中，如果initSID.utl文件已存在，修改文件。

2）创建新的参数文件。

将NetBackupforSAP软件产品中包含的参数文件复制到相应的目录：

对于Windows：

%ORACLE_HOME%\database

copyinstall_path\NetBackup\dbext\sap\scripts\initSAP.utl

%ORACLE_HOME%\database\initSAP.utl

3）用文本编辑器修改initSID.utl文件，将参数设置为合适的值。

以下参数是必需的：

client、switch_list、switch_log和switch_sem。

可以根据是否使用RMAN来设置以下附加参数：

■如果使用RMAN，请设置policy、schedule和server。

■如果不使用RMAN，请设置drives、policy、schedule和server。

修改如下：

#$Header:

nt_initSAP.utl,v1.72009/10/0211:

16:

34$

#

#********************************************************************************

#$Copyright:

Copyright1993-2012SymantecCorporation,AllRightsReserved$

#********************************************************************************

#

#backintparameters

#

#switch_list:

isrequiredandisusedasacontrolfiletocommunicatewith

#BACKINTandBRBACKUPforonlinebackups.Aswitchlistfileiscreated

#everytimeBRBACKUPwantstobackupafileorwhenitwantstoindicatethat

#abackupisfinished.Theswitch_listparametermustbesettoafilepath

#thatislocatedin:

$ORACLE_HOME\sapbackup\.switch.lis.

#

switch_listD:

\oracle\IDS\sapbackup\.switch.lis

#

#

#switch_sem:

isrequiredandisusedasacontrolfilewhichisusedbetween

#BACKINTandBRBACKUPtocommunicate.Aftertheswitchlistfilehasbeen

#createdandclosed,BACKINTcreatestheswitchsemaphorefileandwaitsuntil

#itisdeletedbyBRBACKUP.Theswitch_semparametermustbesettoafile

#paththatislocatedin:

$ORACLE_HOME\sapbackup\.switch.sem.

#

switch_semD:

\oracle\IDS\sapbackup\.switch.sem

#

#

#switch_log:

isrequiredandisusedasacontrolfilewhichisusedbetween

#BACKINTandBRBACKUPtocommunicate.Aftertheswitchsemaphorefilehas

#beendeleted,BACKINTopensandreadstheswitchlogfiletodetermineif

#theprocessissuccessful.TheswitchlogfileiscreatedbyBRBACKUP.The

#switch_logparametermustbesettoafilepaththatislocatedin:

#$ORACLE_HOME\sapbackup\.switch_log.

#

switch_logD:

\oracle\IDS\sapbackup\.switch.log

#

#

#backint_dir:

isanoptionalparameterandmustbesettoadirectorythatis

#public.BACKINTusesthisdirectoryforworkspaceandtostorefilescalled

#backint.times,whichkeepstrackofbackupinformation.

#

#backint_dirD:

\oracle\IDS\sapscript\backint_dir

#

#

#server:

isanoptionalparameterandisthemachinenameoftheNetBackup

#Masterserver.TheNetBackupMasterserveristhenameofthemachinethat

#providesmostoftheadministrationandcontrolforNetbackupoperationsand

#containstheNetBackupdatabase.IfBACKINTfindsa$SAP_SERVERenvironment

#variable,theserverparameter'svaluewillbeoverridenbythevalueof

#$SAP_SERVER.Also,iftheserverparameterisnotspecifiedandthereisno

#environmentvariablethenthecurrentlyconfiguredserverforthe

#NetBackupClientwillbeused.

#

serverszbaksrv

#

#

#client:

isanoptionalparameterandmustbesettoamachinenamethathas

#theNetBackupclientsoftware,anOracledatabase,andaSAPenvironment.

#Insomecasestheserverandclientmachinewillbethesamemachine.If

#BACKINTfindsa$SAP_CLIENTenvironmentvariable,theclientparametervalue

#willbeoverridenbytheassignedenvironmentvariable.Iftheclient

#parameterisnotspecifiedandthereisnoenvironmentvariable,thenthe

#currentlyconfiguredNetBackupClientwillbeused.IfBACKINTcouldnot

#getthecurrentlyconfiguredNetBackupClientalso,thenitusesthevalue

#returnedbythegethostname（）libraryfunction.

#

clientccides

#

#

#drives:

isanoptionalparameterandshouldbesettothenumberof

#simultaneoustapedrivestokickoffbackup.SetNetBackupServertosupport

#multiplesimultaneousclientbackupsandthenumberofstorageunits/tape

#drivesforthisbackuppolicy.Basedonthenumberofdrivesspecified

#BACKINTwillsimultaneouslyrunthesamenumberofbackupjobs.

#Soforexample,ifthedrivesparameterissetto5,then5

#backupjobswillrunatthesametime.Thedrivesparameter

#shouldbesettothefollowingrule:

#

#drives=NumberofstorageunitsperpolicyXMPXnumber

#

#ThedrivesparametervalueshouldnotexceedtheSetMaxiumJobsperClient

#globalattribute.IfBACKINTfindsa$SAP_DRIVESenvironmentvariable,the

#driveparametervaluewillbeoverridenbythevalueofthe$SAP_DRIVES

#variable.Ifthedriveparameterisnotspecifiedandthereisno

#environmentvariable,defaultvalueofonewillbeused.

#

drives2

#

#

#policy:

isanoptionlparameterandshouldbesettothenameofaSAPpolicy

#typethathasbeendefinedinNetbackup.TheSAPpolicymusthaveaschedule

#typeofApplicationBackupdefinedinorderforBACKINTtowork.IfBACKINTfinds

#a$SAP_POLICYenvironmentvariable,thepolicyparametervaluewillbe

#overridenbythevalueofthe$SAP_POLICYvariable.Ifthepolicyparameter

#isnotspecifiedandthereisnoenvironmentvariable,thenBACKINTwill

#exitwithanerror.

#

policytest_ccides_sap

#

#

#schedule:

IsoptionalandmustbesettothenameoftypeApplicationBackup

#schedulethatisassociateswithaSAPpolicytype.Theschedulecan

#defineaspectsofthebackupsuchashowlongNetbackupretainsimages,

#maximumMPXperdrive,storageunit,andvolumepool.IfBACKINTfindsa

#$SAP_SCHEDenvironmentvariable,thescheduleparametervaluewillbe

#overridenbythevalueofthe$SAP_SCHEDenvironmentvariable.Ifthe

#scheduleparameterisnotspecifiedandthereisnoenvironmentvariable,

#then,NetBackupusesthefirstscheduleoftypeApplicationBackupthatitfounds.

#

scheduleDefault-Application-Backup

#

#

#policy2:

isoptionalandisthenameofapolicytobeusedforthe

#secondarySAPbackup.ThesecondarybackupisperformedforeachSAP

#databasebackuponfilesthatareneededtotrackSAPbackupinformation.

#Thisoptionwouldbeusedtosavethebackupinformationonadifferent

#media.Ifpolicy2isnotspecified,thenthepolicyparametervalueisused.

#

#policy2sap_sec_backup

#

#

#schedule2:

isoptionalandisthenameofaApplicationBackupscheduletobe

#usedforthesecondarySAPbackup.Thesecondarybackupisperformedfor

#eachSAPdatabasebackuponfilesthatareneededtotrackSAPbackup

#information.Thisoptionwouldbeusedtosavethebackupinformationona

#differentmedia.Ifschedule2isnotspecified,thenthescheduleparameter

#valueisused.

#

#schedule2userbkps

#

#

#sort_backup_type:

[size|custom|device|drive]

#Thisparameterisoptionalandisusedtospecifyfourdifferentbackup

#sortoption.Ifsort_backup_typeisnotspecifieditwilldefaultto

#thesizeoption.

#

#sort_backup_typesize

#

#

#custom_sort_file:

isoptionalandisusedinconjunctionwiththe

#sort_backup_typeandsort_restore_typeparameter.Ifthecustomoptionis

#specifiedoneitherthesort_backup_typeorsort_restore_typeparameter,

#thenthecustom_sort_fileparameterneedstobesettoavalidfile.The

#valueforthisparametermustbeafullpathnametoacustomsortfileand

#musthavepublicpermissions.

#

#custom_sort_fileC:

\oracle\SAP\sapscripts\custom_sort_file

#

#

#policy_log:

isoptionalandisthenameofapolicytobeusedfor

#backingupasecondcopyofanarchivelog.Ifthisoptionisspecified

#thentwobackupswillbeperformedonthesamearchivelog.Thefirst

#backupwillgotothe"policy"nameoptionandthesecondbackupwillgo

#tothe"policy_log"nameoption.

#

#policy_logsap_archive_logs

#

#

#sched_log:

isoptionalandisthenameofascheduletocreateasecond

#backingupofanarchivelog.Ifthisoptionisspecifiedthentwobackup

#willbeperformedonthesamearchivelog.Thefirstbackupwillgotothe

#"schedule"optionandthesecondbackupwillbegotothe"sched_log"and

#option.The"sched_log"namemustbeavalidschedulenameunderthe

#"policy_log"nameoption,otherwiseitmustbeavalidschedulenameunder

#the"policy"nameoption.

#

#sched_logDefault-Application-Backup

#

#

#retry_backup:

isanoptionalparameterandshouldbesettothenumberof

#retriesforafailedbackup.IfthisoptionisspecifiedBACKINTwill

#retryafailedbpbackupjob.Thenumberofretriesisdeterminebythe

#valueontheretry_backupparameter.

#

#retry_backup2

#

#

#fail_backup:

isoptionalandisusedtostopthebackupprocessimmediately

#whenanerroroccurs.ThestandardbehaviorofBACKINTistocontinue

#processingevenintheeventofanerrorandthenreportwhatfilesfailed

#andwhatfilesweresuccessful.Ifthisparamete