# @(#) $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: all backup_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: all restore_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: offline backup_type = online # 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: tape backup_dev_type = rman_util # backup root directory [ | ()] # default: %SAPDATA_HOME%\sapbackup backup_root_dir = E:\oracle\Q41\sapbackup # stage root directory [ | ()] # default: value of the backup_root_dir parameter stage_root_dir = E:\oracle\Q41\sapbackup # compression flag [no | yes | hardware | only] # default: no compress = 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 default compress_cmd = "D:\usr\sap\Q41\SYS\exe\uc\NTAMD64\mkszip -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 default uncompress_cmd = "D:\usr\sap\Q41\SYS\exe\uc\NTAMD64\uncompress -c $ > $" # directory for compression [ | ()] # default: value of the backup_root_dir parameter compress_dir = E:\oracle\Q41\sapreorg # 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: save archive_function = save_delete # directory for archive log copies to disk # default: first value of the backup_root_dir parameter archive_copy_dir = E:\oracle\Q41\saparch # directory for archive log copies to stage # default: first value of the stage_root_dir parameter archive_stage_dir = E:\oracle\Q41\sapbackup # 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:\oracle\C11 # 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: cpio tape_copy_cmd = cpio # disk copy command [copy | copy_gnu | dd | dd_gnu | rman | rman_gnu # | rman_set | rman_set_gnu | ocopy] # default: copy disk_copy_cmd = copy # stage copy command [rcp | scp | ftp] # default: rcp stage_copy_cmd = rcp # pipe copy command [rsh | ssh] # default: rsh pipe_copy_cmd = rsh # flags for cpio output command # default: -ovB cpio_flags = -ovB # flags for cpio input command # default: -iuvB cpio_in_flags = -iuvB # flags for cpio command for copy of directories to disk # default: -pdcu # use flags -pdu for gnu tools cpio_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=64k" dd_flags = "bs=64k" # flags for dd input command # default: "ibs=16k" # caution: option "ibs=" not supported for Windows # recommended setting: # Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k" # Windows: "bs=nk", example: "bs=64k" dd_in_flags = "bs=64k" # number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ] # default: 1 saveset_members = 1 # additional parameters for RMAN # rman_channels and rman_filesperset are only used when rman_util, # rman_disk or rman_stage # rman_channels defines the number of parallel sbt channel allocations # rman_filesperset = 0 means: # one file per save set - for non-incremental backups # all files in one save set - for incremental backups # the others have the same meaning as for native RMAN # rman_channels = 1 # rman_filesperset = 0 # rman_maxpiecesize = 0 # in KB - former name rman_kbytes # rman_rate = 0 # in KB - former name rman_readrate # rman_maxopenfiles = 0 # rman_maxsetsize = 0 # in KB - former name rman_setsize # additional parameters for RMAN version 8.1 # the parameters have the same meaning as for native RMAN # rman_diskratio = 0 # deprecated in Oracle 10g # rman_pool = 0 # rman_copies = 0 | 1 | 2 | 3 | 4 # former name rman_duplex # rman_proxy = no | yes | only rman_proxy = no # special parameters for an external backup library, example: # rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)" # rman_parms="ENV=(XINT_PROFILE=D:\oracle\Q41\11202\database\initQ41_tivoli.utl)" rman_parms="ENV=(NB_ORA_SAP=D:\oracle\Q41\11202\database\initQ41.utl)" # rman_send = "''" # rman_send = ("channel sbt_1 '' parms=''", # "channel sbt_2 '' parms=''") rman_send = "'NB_ORA_PC_SCHED=Default-Application-Backup'" # rman_compress = yes # rman_maxcorrupt = (|:, ...) # remote copy-out command (backup_dev_type = pipe) # $-character is replaced by current device address # no default copy_out_cmd = "dd ibs=8k obs=64k of=$" # remote copy-in command (backup_dev_type = pipe) # $-character is replaced by current device address # no default copy_in_cmd = "dd ibs=64k obs=8k if=$" # rewind command # $-character is replaced by current device address # no default # operating system dependent, examples: # HP-UX: "mt -f $ rew" # TRU64: "mt -f $ rewind" # AIX: "tctl -f $ rewind" # Solaris: "mt -f $ rewind" # Windows: "mt -f $ rewind" # Linux: "mt -f $ rewind" rewind = "mt -f $ rewind" # rewind and set offline command # $-character is replaced by current device address # default: value of the rewind parameter # operating system dependent, examples: # HP-UX: "mt -f $ offl" # TRU64: "mt -f $ offline" # AIX: "tctl -f $ offline" # Solaris: "mt -f $ offline" # Windows: "mt -f $ offline" # Linux: "mt -f $ offline" rewind_offline = "mt -f $ offline" # tape positioning command # first $-character is replaced by current device address # second $-character is replaced by number of files to be skipped # no default # operating system dependent, examples: # HP-UX: "mt -f $ fsf $" # TRU64: "mt -f $ fsf $" # AIX: "tctl -f $ fsf $" # Solaris: "mt -f $ fsf $" # Windows: "mt -f $ fsf $" # Linux: "mt -f $ fsf $" tape_pos_cmd = "mt -f $ fsf $" # mount backup volume command in auto loader / juke box # used if backup_dev_type = tape_box | pipe_box # no default # mount_cmd = " $ $ $ [$]" # dismount backup volume command in auto loader / juke box # used if backup_dev_type = tape_box | pipe_box # no default # dismount_cmd = " $ $ [$]" # split mirror disks command # used if backup_type = offline_split | online_split | offline_mirror # | online_mirror # no default # split_cmd = " [$]" # resynchronize mirror disks command # used if backup_type = offline_split | online_split | offline_mirror # | online_mirror # no default # resync_cmd = " [$]" # additional options for SPLITINT interface program # no default # split_options = "" # resynchronize after backup flag [no | yes] # default: no # split_resync = no # pre-split command # no default # pre_split_cmd = "" # post-split command # no default # post_split_cmd = "" # pre-shut command # no default # pre_shut_cmd = "" # post-shut command # no default # post_shut_cmd = "" # volume size in KB = K, MB = M or GB = G (backup device dependent) # default: 1200M # recommended values for tape devices without hardware compression: # 60 m 4 mm DAT DDS-1 tape: 1200M # 90 m 4 mm DAT DDS-1 tape: 1800M # 120 m 4 mm DAT DDS-2 tape: 3800M # 125 m 4 mm DAT DDS-3 tape: 11000M # 112 m 8 mm Video tape: 2000M # 112 m 8 mm high density: 4500M # DLT 2000 10/20 GB: 10000M # DLT 2000XT 15/30 GB: 15000M # DLT 4000 20/40 GB: 20000M # DLT 7000 35/70 GB: 35000M # recommended values for tape devices with hardware compression: # 60 m 4 mm DAT DDS-1 tape: 1000M # 90 m 4 mm DAT DDS-1 tape: 1600M # 120 m 4 mm DAT DDS-2 tape: 3600M # 125 m 4 mm DAT DDS-3 tape: 10000M # 112 m 8 mm Video tape: 1800M # 112 m 8 mm high density: 4300M # DLT 2000 10/20 GB: 9000M # DLT 2000XT 15/30 GB: 14000M # DLT 4000 20/40 GB: 18000M # DLT 7000 35/70 GB: 30000M tape_size = 400G # volume size in KB = K, MB = M or GB = G used by brarchive # default: value of the tape_size parameter # tape_size_arch = 100G # level of parallel execution # default: 0 - set to number of backup devices exec_parallel = 5 # address of backup device without rewind # [ | ()] # no default # operating system dependent, examples: # HP-UX: /dev/rmt/0mn # TRU64: /dev/nrmt0h # AIX: /dev/rmt0.1 # Solaris: /dev/rmt/0mn # Windows: /dev/nmt0 | /dev/nst0 # Linux: /dev/nst0 tape_address = /dev/nmt0 # address of backup device without rewind used by brarchive # default: value of the tape_address parameter # operating system dependent # tape_address_arch = /dev/nmt0 # address of backup device with rewind # [ | ()] # no default # operating system dependent, examples: # HP-UX: /dev/rmt/0m # TRU64: /dev/rmt0h # AIX: /dev/rmt0 # Solaris: /dev/rmt/0m # Windows: /dev/mt0 | /dev/st0 # Linux: /dev/st0 tape_address_rew = /dev/mt0 # address of backup device with rewind used by brarchive # default: value of the tape_address_rew parameter # operating system dependent # tape_address_rew_arch = /dev/mt0 # address of backup device with control for mount/dismount command # [ | ()] # default: value of the tape_address_rew parameter # operating system dependent # tape_address_ctl = /dev/... # address of backup device with control for mount/dismount command # used by brarchive # default: value of the tape_address_rew_arch parameter # operating system dependent # tape_address_ctl_arch = /dev/... # volumes for brarchive # [ | () | SCRATCH] # no default volume_archive = (Q41A01, Q41A02, Q41A03, Q41A04, Q41A05, Q41A06, Q41A07, Q41A08, Q41A09, Q41A10, Q41A11, Q41A12, Q41A13, Q41A14, Q41A15, Q41A16, Q41A17, Q41A18, Q41A19, Q41A20, Q41A21, Q41A22, Q41A23, Q41A24, Q41A25, Q41A26, Q41A27, Q41A28, Q41A29, Q41A30) # volumes for brbackup # [ | () | SCRATCH] # no default volume_backup = (Q41B01, Q41B02, Q41B03, Q41B04, Q41B05, Q41B06, Q41B07, Q41B08, Q41B09, Q41B10, Q41B11, Q41B12, Q41B13, Q41B14, Q41B15, Q41B16, Q41B17, Q41B18, Q41B19, Q41B20, Q41B21, Q41B22, Q41B23, Q41B24, Q41B25, Q41B26, Q41B27, Q41B28, Q41B29, Q41B30) # expiration period for backup volumes in days # default: 30 expir_period = 30 # recommended usages of backup volumes # default: 100 tape_use_count = 100 # backup utility parameter file # default: no parameter file util_par_file = D:\oracle\Q41\11202\database\initQ41.utl # util_par_file = D:\usr\sap\Q41\SYS\exe\uc\NTAMD64\biparam.ini # mount/dismount command parameter file # default: no parameter file # mount_par_file = initQ41.mnt # Oracle connection name to the primary database # [primary_db = | LOCAL] # no default # primary_db = # Oracle connection name to the standby database # [standby_db = | LOCAL] # no default # standby_db = # description of parallel instances for Oracle RAC # parallel_instances = | () # - [,...] # - :@ # - Oracle system id for parallel instance # - Oracle home for parallel instance # - Oracle connection name to parallel instance # Please include the local instance in the parameter definition! # default: no parallel instances # example for initRAC001.sap: # parallel_instances = (RAC001:/oracle/RAC/920_64@RAC001, # RAC002:/oracle/RAC/920_64@RAC002, RAC003:/oracle/RAC/920_64@RAC003) # handling of Oracle RAC database services [no | yes] # default: no # db_services = yes # database owner of objects to be checked # | () # default: all SAP owners # check_owner = sapr3 # database objects to be excluded from checks # all_part | non_sap | [.] | [.] # | [.][]*[] | | () # default: no exclusion, example: # check_exclude = (SDBAH, SAPR3.SDBAD) # special database check conditions # ("::::[]:[]:[]", ...) # check_cond = () # database owner of SDBAH, SDBAD and XDB tables for cleanup # | () # default: all SAP owners # cleanup_owner = sapr3 # retention period in days for brarchive log files # default: 30 # cleanup_brarchive_log = 30 # retention period in days for brbackup log files # default: 30 # cleanup_brbackup_log = 30 # retention period in days for brconnect log files # default: 30 # cleanup_brconnect_log = 30 # retention period in days for brrestore log files # default: 30 # cleanup_brrestore_log = 30 # retention period in days for brrecover log files # default: 30 # cleanup_brrecover_log = 30 # retention period in days for brspace log files # default: 30 # cleanup_brspace_log = 30 # retention period in days for archive log files saved on disk # default: 30 # cleanup_disk_archive = 2 # retention period in days for database files backed up on disk # default: 30 # cleanup_disk_backup = 2 # retention period in days for brspace export dumps and scripts # default: 30 # cleanup_exp_dump = 30 # retention period in days for Oracle trace and audit files # default: 30 # cleanup_ora_trace = 30 # retention period in days for records in SDBAH and SDBAD tables # default: 100 # cleanup_db_log = 100 # retention period in days for records in XDB tables # default: 100 # cleanup_xdb_log = 100 # retention period in days for database check messages # default: 100 # cleanup_check_msg = 100 # database owner of objects to adapt next extents # | () # default: all SAP owners # next_owner = sapr3 # database objects to adapt next extents # all | all_ind | special | [.]
| [.] # | [.][]*[] | | () # default: all abjects of selected owners, example: # next_table = (SDBAH, SAPR3.SDBAD) # database objects to be excluded from adapting next extents # all_part | [.]
| [.] # | [.][]*[] | | () # default: no exclusion, example: # next_exclude = (SDBAH, SAPR3.SDBAD) # database objects to get special next extent size # all_sel:[/] | [.]
:[/] # | [.]:[/] # | [.][]*[]:[/] # | () # default: according to table category, example: # next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200) # maximum next extent size # default: 2 GB - 5 * # next_max_size = 1G # maximum number of next extents # default: 0 - unlimited # next_limit_count = 300 # database owner of objects to update statistics # | () # default: all SAP owners # stats_owner = sapr3 # database objects to update statistics # all | all_ind | all_part | missing | info_cubes | dbstatc_tab # | dbstatc_mon | dbstatc_mona | [.]
| [.] # | [.][]*[] | | () # | harmful | locked | system_stats | oradict_stats | oradict_tab # default: all abjects of selected owners, example: # stats_table = (SDBAH, SAPR3.SDBAD) # database objects to be excluded from updating statistics # all_part | info_cubes | [.]
| [.] # | [.][]*[] | | () # default: no exclusion, example: # stats_exclude = (SDBAH, SAPR3.SDBAD) # method for updating statistics for tables not in DBSTATC # E | EH | EI | EX | C | CH | CI | CX | A | AH | AI | AX | E= | C= | =H # | =I | =X | +H | +I # default: according to internal rules # stats_method = E # sample size for updating statistics for tables not in DBSTATC # P | R # default: according to internal rules # stats_sample_size = P10 # number of buckets for updating statistics with histograms # default: 75 # stats_bucket_count = 75 # threshold for collecting statistics after checking # default: 50% # stats_change_threshold = 50 # number of parallel threads for updating statistics # default: 1 # stats_parallel_degree = 1 # processing time limit in minutes for updating statistics # default: 0 - no limit # stats_limit_time = 0 # parameters for calling DBMS_STATS supplied package # all:R|B[|A|S|R]:0|A|D # | all_part:R|B[|A|S|R]:0|A|D # | info_cubes:R|B:A|D|0| # | [.]
:R|B[|A|S|R]:0|A|D # | [.][]*[]:R|B[|A|S|R]:0|A|D # | () | NO # R|B[|A|S|R]: # 'R' - row sampling, 'B' - block sampling, # - histogram buckets count, 'A' - auto buckets count, # 'S' - skew only, 'R' - repeat # A|D: # - dbms_stats parallel degree, '0' - table degree, # 'A' - auto degree, 'D' - default degree # default: ALL:R:0 # stats_dbms_stats = ([ALL:R:1,][.]
:R:,...) # definition of info cube tables # default | rsnspace_tab | [.]
# | [.][]*[] | () | null # default: rsnspace_tab # stats_info_cubes = (/BIC/D*, /BI0/D*, ...) # special statistics settings # (
:[]::[]:[], ...) # stats_special = () # recovery type [complete | dbpit | tspit | reset | restore | apply # | disaster] # default: complete # recov_type = complete # directory for brrecover file copies # default: $SAPDATA_HOME/sapbackup # recov_copy_dir = E:\oracle\Q41\sapbackup # time period for searching for backups # 0 - all available backups, >0 - backups from n last days # default: 30 # recov_interval = 30 # degree of paralelism for applying archive log files # 0 - use Oracle default parallelism, 1 - serial, >1 - parallel # default: Oracle default # recov_degree = 0 # number of lines for scrolling in list menus # 0 - no scrolling, >0 - scroll n lines # default: 20 # scroll_lines = 20 # time period for displaying profiles and logs # 0 - all available logs, >0 - logs from n last days # default: 30 # show_period = 30 # directory for brspace file copies # default: $SAPDATA_HOME/sapreorg # space_copy_dir = E:\oracle\Q41\sapreorg # directory for table export dump files # default: $SAPDATA_HOME/sapreorg # exp_dump_dir = E:\oracle\Q41\sapreorg # database tables for reorganization # [.]
| [.][]*[] # | [.][]%[] | () # no default # reorg_table = (SDBAH, SAPR3.SDBAD) # database indexes for rebuild # [.] | [.][]*[] # | [.][]%[] | () # no default # rebuild_index = (SDBAH~0, SAPR3.SDBAD~0) # database tables for export # [.]
| [.][]*[] # | [.][]%[] | () # no default # exp_table = (SDBAH, SAPR3.SDBAD) # database tables for import #
| () # no default # do not specify table owner in the list - use -o|-owner option for this # imp_table = (SDBAH, SDBAD)