NBU SAP brtools备份配置.docx

sap brtools备份配置1、安装nbu7.0或者7.5安装过程略2、配置 windows 上 netbackup client service fornetbackup for sap 的登录帐户由于在默认情况下，netbackup 客户端服务是以 system 帐户启动的，因此，还必须特别注意数据库用户身份验证。如果您使用的是操作系统身份验证而不是密码，则 system 帐户不具备连接到目标数据库的权限。如果使用操作系统身份验证，请在具有 sysdba 权限的帐户下运行 netbackup 客户端服务。注意：在群集环境中，在群集中的每个数据库节点上执行这些步骤。对于脱离主机备份，在备用客户端上执行这些步骤。配置 netbackup 客户端服务的登录帐户1 打开 windows 的“服务”应用程序。2 双击“netbackup 客户端服务”条目。3 单击“登录”选项卡。4 键入具有 sysdba 权限的帐户名称。5 键入密码。6 单击“确定”。7 停止并启动 netbackup 客户端服务。8 关闭服务控制面板应用程序。3、复制 netbackup for sap 二进制文件将 backint.exe 从 netbackup 安装目录复制到 sap 工具目录。例如，假设 oracle 实例名称为 cer，则输入以下命令：copy install_pathnetbackupbinbackint.exec:usrsapcersysexerun拷贝c:program filesveritasnetbackupbinbackint.exe 到d:usrsapidssysexeucntamd64目录下。修改windows系统的环境变更，添加path路径，使用set path=c:program filesveritasnetbackupbin, 或者“我的电脑属性高级”标签的“环境变量”按钮设置，设置path，添加：c:program filesveritasnetbackupbin4、修改oracle_homedatabase目录下：initsid.utl文件。1)检查%oracle_home%database 目录中，如果 initsid.utl 文件已存在，修改文件。2）创建新的参数文件。将 netbackup for sap 软件产品中包含的参数文件复制到相应的目录：对于 windows：%oracle_home%databasecopy install_pathnetbackupdbextsapscriptsinitsap.utl%oracle_home%databaseinitsap.utl3）用文本编辑器修改 initsid.utl 文件，将参数设置为合适的值。以下参数是必需的：client、switch_list、switch_log 和 switch_sem。可以根据是否使用 rman 来设置以下附加参数：如果使用 rman，请设置 policy、schedule 和 server。如果不使用 rman，请设置 drives、policy、schedule 和 server。修改如下：# $header: nt_initsap.utl,v 1.7 2009/10/02 11:16:34 $ #*# $copyright: copyright 1993 - 2012 symantec corporation, all rights reserved $#*# backint parameters# switch_list: is required and is used as a control file to communicate with # backint and brbackup for online backups. a switch list file is created # every time brbackup wants to backup a file or when it wants to indicate that# a backup is finished. the switch_list parameter must be set to a file path # that is located in: $oracle_homesapbackup.switch.lis.#switch_list d:oracleidssapbackup.switch.lis# switch_sem: is required and is used as a control file which is used between # backint and brbackup to communicate. after the switch list file has been # created and closed, backint creates the switch semaphore file and waits until# it is deleted by brbackup. the switch_sem parameter must be set to a file# path that is located in: $oracle_homesapbackup.switch.sem.#switch_sem d:oracleidssapbackup.switch.sem# switch_log: is required and is used as a control file which is used between # backint and brbackup to communicate. after the switch semaphore file has # been deleted, backint opens and reads the switch log file to determine if # the process is successful. the switch log file is created by brbackup. the# switch_log parameter must be set to a file path that is located in: # $oracle_homesapbackup.switch_log.#switch_log d:oracleidssapbackup.switch.log# backint_dir: is an optional parameter and must be set to a directory that is# public. backint uses this directory for work space and to store files called# backint.times, which keeps track of backup information.#backint_dir d:oracleidssapscriptbackint_dir# server: is an optional parameter and is the machine name of the netbackup # master server. the netbackup master server is the name of the machine that# provides most of the administration and control for netbackup operations and # contains the netbackup database. if backint finds a $sap_server environment# variable, the server parameters value will be overriden by the value of # $sap_server. also, if the server parameter is not specified and there is no # environment variable then the currently configured server for the # netbackup client will be used.#server szbaksrv# client: is an optional parameter and must be set to a machine name that has # the netbackup client software, an oracle database, and a sap environment. # in some cases the server and client machine will be the same machine. if # backint finds a $sap_client environment variable, the client parameter value # will be overriden by the assigned environment variable. if the client # parameter is not specified and there is no environment variable, then the # currently configured netbackup client will be used. if backint could not # get the currently configured netbackup client also, then it uses the value # returned by the gethostname() library function.#client ccides# drives: is an optional parameter and should be set to the number of # simultaneous tape drives to kickoff backup. set netbackup server to support# multiple simultaneous client backups and the number of storage units/tape # drives for this backup policy. based on the number of drives specified # backint will simultaneously run the same number of backup jobs.# so for example, if the drives parameter is set to 5, then 5 # backup jobs will run at the same time. the drives parameter # should be set to the following rule:# drives = number of storage units per policy x mpx number# the drives parameter value should not exceed the set maxium jobs per client # global attribute. if backint finds a $sap_drives environment variable, the# drive parameter value will be overriden by the value of the $sap_drives # variable. if the drive parameter is not specified and there is no # environment variable, default value of one will be used.# drives 2# policy: is an optionl parameter and should be set to the name of a sap policy# type that has been defined in netbackup. the sap policy must have a schedule# type of application backup defined in order for backint to work. if backint finds# a $sap_policy environment variable, the policy parameter value will be # overriden by the value of the $sap_policy variable. if the policy parameter # is not specified and there is no environment variable, then backint will# exit with an error.#policy test_ccides_sap # schedule: is optional and must be set to the name of type application backup # schedule that is associates with a sap policy type. the schedule can # define aspects of the backup such as how long netbackup retains images, # maximum mpx per drive, storage unit, and volume pool. if backint finds a # $sap_sched environment variable, the schedule parameter value will be # overriden by the value of the $sap_sched environment variable. if the # schedule parameter is not specified and there is no environment variable, # then, netbackup uses the first schedule of type application backup that it founds.#schedule default-application-backup # policy2: is optional and is the name of a policy to be used for the# secondary sap backup. the secondary backup is performed for each sap# database backup on files that are needed to track sap backup information.# this option would be used to save the backup information on a different# media. if policy2 is not specified, then the policy parameter value is used.#policy2 sap_sec_backup# schedule2: is optional and is the name of a application backup schedule to be # used for the secondary sap backup. the secondary backup is performed for # each sap database backup on files that are needed to track sap backup # information. this option would be used to save the backup information on a # different media. if schedule2 is not specified, then the schedule parameter # value is used.#schedule2 userbkps# sort_backup_type: size | custom | device | drive # this parameter is optional and is used to specify four different backup # sort option. if sort_backup_type is not specified it will default to # the size option.#sort_backup_type size # custom_sort_file: is optional and is used in conjunction with the # sort_backup_type and sort_restore_type parameter. if the custom option is # specified on either the sort_backup_type or sort_restore_type parameter, # then the custom_sort_file parameter needs to be set to a valid file. the # value for this parameter must be a full path name to a custom sort file and # must have public permissions. # #custom_sort_file c:oraclesapsapscriptscustom_sort_file# policy_log: is optional and is the name of a policy to be used for# backing up a second copy of an archive log. if this option is specified# then two backups will be performed on the same archive log. the first# backup will go to the policy name option and the second backup will go# to the policy_log name option.# #policy_log sap_archive_logs# sched_log: is optional and is the name of a schedule to create a second# backing up of an archive log. if this option is specified then two backup# will be performed on the same archive log. the first backup will go to the# schedule option and the second backup will be go to the sched_log and# option. the sched_log name must be a valid schedule name under the# policy_log name option, otherwise it must be a valid schedule name under# the policy name option.#sched_log default-application-backup# retry_backup: is an optional parameter and should be set to the number of# retries for a failed backup. if this option is specified backint will# retry a failed bpbackup job. the number of retries is determine by the# value on the retry_backup parameter.#retry_backup 2# fail_backup: is optional and is used to stop the backup process immediately# when an error occurs. the standard behavior of backint is to continue# processing even in the event of an error and then report what files failed# and what files were successful. if this parameter is specified then backint# will stop process on the first error and report failures for all the# files that were not backed up.#fail_backup# second_secondary_archive: is optional, and it can have value of 0 or 1.# if value is one, then 2 copies of secondary backup will be made. this# parameter will have an effect only if policy_log and/or schedule_log are# specified. the first backup will go to the policy name option and the# second backup will go to the policy_log name option. furthermore, it# will serve brarchive but it will have no effect on brbackup.#second_secondary_archive 0# backup_stream_buffersize: is optional. this parameter can be used to # specify the value of buffer size in case of stream backup. data is # received through stream (pipe) in case of sapdb. when passing this # data to netbackup, the buffer size specified by this value will be used.#backup_stream_buffersize 65535# restore_stream_buffersize: is optional. this parameter can be used to# specify the value of buffer size in case of stream restore. data is# received from netbackup and passed to sapdb through stream (pipe) in case # of restore. when receiving data from netbackup and copying it to pipe, # the buffer size specified by this value will be used.#restore_stream_buffersize 65535#inquire_query_period: in case of #null based inquire query, sap agent will #restrict the catalog search to six months by default. this parameter can be#used to specify the query period (in months). for example if user wants to #restrict the result of #null inquire query search to last 10 months then this#parameter should be set to 10.#inquire_query_period 10# multistream_restore: is optional, and it can have value of 0 or 1.# if value is 0, then netbackup master server (bprd process) takes care of performing# an efficient restore job from selected backup images. if value is 1, then# parallel restore streams will be started (similar to pre nbu 6.0 version),# number of restore streams will be decided based on values of drives and sort_restore_type.# the default value of multistream_restore is set to 0.# multistream_restore 05、修改oracle_homedatabase目录下：initsid.sap文件。修改如下：# (#) $id: /bas/700_rel/src/ccm/rsbr/initnt.sap#15 $ sap# # sap br*tools sample profile. # the parameter syntax is the same as for init.ora parameters. # enclose parameter values which consist of more than one symbol in # double quotes. # after any symbol, parameter definition can be continued on the next # line. # a parameter value list should be enclosed in parentheses, the list # items should be delimited by commas. # there can be any number of white spaces (blanks, tabs and new lines) # between symbols in parameter definition. # comment lines must start with a hash character. # # backup mode all | all_data | full | incr | sap_dir | ora_dir# | all_dir | | | -# | | ()# default: allbackup_mode = all# restore mode all | all_data | full | incr | incr_only | incr_full# | incr_all | | | -# | | () | partial | non_db# redirection with = is not supported here - use option -m instead# default: allrestore_mode = all# backup type offline | offline_force | offline_standby | offline_split# | offline_mirror | offline_stop | online | online_cons | online_split# | online_mirror | online_standby | offstby_split | offstby_mirror# default: offlinebackup_type = offline# backup device type# tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk# | disk_copy | disk_standby | stage | stage_copy | stage_standby# | util_file | util_file_online | rman_util | rman_disk | rman_stage# | rman_prep# default: tapebackup_dev_type = util_file# backup root directory | ()# default: %sapdata_home%sapbackupbackup_root_dir = d:oracleidssapbackup# stage root directory | ()# default: value of the backup_root_dir parameterstage_root_dir = d:oracleidssapbackup# compression flag no | yes | hardware | only# default: nocompress = no# compress command# first $-character is replaced by the source file name# second $-character is replaced by the target file name# = .z# for compress command the -c option must be set# recommended setting for brbackup -k only run:# %sapexe%mkszip -l 0 -c $ $# no defaultcompress_cmd = d:usrsapidssysexeucntamd64mkszip -c $ $# uncompress command# first $-character is replaced by the source file name# second $-character is replaced by the target file name# = .z# for uncompress command the -c option must be set# no defaultuncompress_cmd = d:usrsapidssysexeucntamd64uncompress -c $ $# directory for compression | ()# default: value of the backup_root_dir parametercompress_dir = d:oracleidssapreorg# brarchive function save | second_copy | double_save | save_delete# | second_copy_delete | double_save_delete | copy_save# | copy_delete_save | delete_saved | delete_copied# default: savearchive_function = save# directory for archive log copies to disk# default: first value of the backup_root_dir parameterarchive_copy_dir = d:oracleidssapbackup# directory for archive log copies to stage# default: first value of the stage_root_dir parameterarchive_stage_dir = d:oracleidssapbackup# delete archive logs from duplex destination only | no | yes | check# default: only# archive_dupl_del = only# new sapdata home directory for disk_copy | disk_standby# no default# new_db_home = x:oraclec11# stage sapdata home directory for stage_copy | stage_standby# default: value of the new_db_home parameter# stage_db_home = /oracle/c11# original sapdata home directory for split mirror disk backup# no default# orig_db_home = /oracle/c11# remote host name# no default# remote_host = # remote user name# default: current operating system user# remote_user = # tape copy command cpio | cpio_gnu | dd | dd_gnu | rman | rman_gnu# | rman_dd | rman_dd_gnu# default: cpiotape_copy_cmd = cpio# disk copy command copy | copy_gnu | dd | dd_gnu | rman | rman_gnu# | rman_set | rman_set_gnu | ocopy# default: copydisk_copy_cmd = copy# stage copy command rcp | scp | ftp# default: rcpstage_copy_cmd = rcp# pipe copy command rsh | ssh# default: rshpipe_copy_cmd = rsh# flags for cpio output command# default: -ovbcpio_flags = -ovb# flags for cpio input command# default: -iuvbcpio_in_flags = -iuvb# flags for cpio command for copy of directories to disk# default: -pdcu# use flags -pdu for gnu toolscpio_disk_flags = -pdcu# flags for dd output command# default: obs=16k# caution: option obs= not supported for windows# recommended setting:# unix: obs=nk bs=nk, example: obs=64k bs=64k# windows: bs=nk, example: bs=64kdd_flags = bs=64k# flags for dd input command# default: ibs=16k# caution: option ibs= not supporte