Consistent Offline Back up.Very urgent.

Former Member · ‎10-29-2007

If i want to take a Consistent offline Backup in to Disk what are the parameters needs to set.. Plz advice ..As i pasted my <initsid.sap> file.

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 | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>)]
default: all

backup_mode = all

restore mode [all | all_data | full | incr | incr_only | incr_full
| incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>
| <generic_path> | (<object_list>) | 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 = 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: tape

backup_dev_type = tape

backup root directory [<path_name> | (<path_name_list>)]
default: %SAPDATA_HOME%\sapbackup

backup_root_dir = F:\oracle\MBS\sapbackup

stage root directory [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter

stage_root_dir = F:\oracle\MBS\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
<target_file_name> = <source_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\MBS\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
<source_file_name> = <target_file_name>.Z
for uncompress command the -c option must be set
no default

uncompress_cmd = "D:\usr\sap\MBS\SYS\exe\uc\NTAMD64\uncompress -c $ > $"

directory for compression [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter

compress_dir = F:\oracle\MBS\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

directory for archive log copies to disk
default: first value of the backup_root_dir parameter

archive_copy_dir = F:\oracle\MBS\sapbackup

directory for archive log copies to stage
default: first value of the stage_root_dir parameter

archive_stage_dir = F:\oracle\MBS\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 = <host_name>
remote user name
default: current operating system user
remote_user = <user_name>
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]
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
special parameters for an external backup library, example:
rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"
rman_send = "'<command>'"
rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",
"channel sbt_2 '<command2>' parms='<parameters2>'")
rman_compress = no | yes
rman_maxcorrupt = (<dbf_name>|<dbf_id>:<corr_cnt>, ...)
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 = "<mount_cmd> $ $ $ [$]"
dismount backup volume command in auto loader / juke box
used if backup_dev_type = tape_box | pipe_box
no default
dismount_cmd = "<dismount_cmd> $ $ [$]"
split mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
split_cmd = "<split_cmd> [$]"
resynchronize mirror disks command
used if backup_type = offline_split | online_split | offline_mirror
| online_mirror
no default
resync_cmd = "<resync_cmd> [$]"
additional options for SPLITINT interface program
no default
split_options = "<split_options>"
resynchronize after backup flag [no | yes]
default: no
split_resync = no
pre-split command
no default
pre_split_cmd = "<pre_split_cmd>"
post-split command
no default
post_split_cmd = "<post_split_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 = 100G

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 = 0

address of backup device without rewind
[<dev_address> | (<dev_address_list>)]
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
[<dev_address> | (<dev_address_list>)]
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
[<dev_address> | (<dev_address_list>)]
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
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default

volume_archive = (MBSA01, MBSA02, MBSA03, MBSA04, MBSA05,

MBSA06, MBSA07, MBSA08, MBSA09, MBSA10,

MBSA11, MBSA12, MBSA13, MBSA14, MBSA15,

MBSA16, MBSA17, MBSA18, MBSA19, MBSA20,

MBSA21, MBSA22, MBSA23, MBSA24, MBSA25,

MBSA26, MBSA27, MBSA28, MBSA29, MBSA30)

volumes for brbackup
[<volume_name> | (<volume_name_list>) | SCRATCH]
no default

volume_backup = (MBSB01, MBSB02, MBSB03, MBSB04, MBSB05,

MBSB06, MBSB07, MBSB08, MBSB09, MBSB10,

MBSB11, MBSB12, MBSB13, MBSB14, MBSB15,

MBSB16, MBSB17, MBSB18, MBSB19, MBSB20,

MBSB21, MBSB22, MBSB23, MBSB24, MBSB25,

MBSB26, MBSB27, MBSB28, MBSB29, MBSB30)

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 = initMBS.utl
mount/dismount command parameter file
default: no parameter file
mount_par_file = initMBS.mnt
Oracle connection name to the primary database
[primary_db = <conn_name> | LOCAL]
no default
primary_db = <conn_name>
Oracle connection name to the standby database
[standby_db = <conn_name> | LOCAL]
no default
standby_db = <conn_name>
description of parallel instances for Oracle RAC
parallel_instances = <inst_desc> | (<inst_desc_list>)
<inst_desc_list> - <inst_desc>[,<inst_desc>...]
<inst_desc> - <Oracle_sid>:<Oracle_home>@<conn_name>
<Oracle_sid> - Oracle system id for parallel instance
<Oracle_home> - Oracle home for parallel instance
<conn_name> - 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)
database owner of objects to be checked
<owner> | (<owner_list>)
default: all SAP owners
check_owner = sapr3
database objects to be excluded from checks
all_part | non_sap | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: no exclusion, example:
check_exclude = (SDBAH, SAPR3.SDBAD)
database owner of SDBAH, SDBAD and XDB tables for cleanup
<owner> | (<owner_list>)
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 = 30
retention period in days for database files backed up on disk
default: 30
cleanup_disk_backup = 30
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
<owner> | (<owner_list>)
default: all SAP owners
next_owner = sapr3
database objects to adapt next extents
all | all_ind | special | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
default: all abjects of selected owners, example:
next_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from adapting next extents
all_part | [<owner>.]<table> | [<owner>.]<index> | [<owner>.]<prefix>*
| <tablespace> | (<object_list>)
default: no exclusion, example:
next_exclude = (SDBAH, SAPR3.SDBAD)
database objects to get special next extent size
all_sel:<size>[/<limit>] | [<owner>.]<table>:<size>[/<limit>]
| [<owner>.]<index>:<size>[/<limit>]
| [<owner>.]<prefix>*:<size>[/<limit>] | (<object_size_list>)
default: according to table category, example:
next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)
maximum next extent size
default: 2 GB - 5 * <database_block_size>
next_max_size = 1G
maximum number of next extents
default: 0 - unlimited
next_limit_count = 300
database owner of objects to update statistics
<owner> | (<owner_list>)
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 | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>) | harmful
| locked | system_stats | oradict_stats
default: all abjects of selected owners, example:
stats_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from updating statistics
all_part | info_cubes | [<owner>.]<table> | [<owner>.]<index>
| [<owner>.]<prefix>* | <tablespace> | (<object_list>)
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<percentage_of_rows> | R<thousands_of_rows>
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|D|0|<degree> | all_part:R|B:A|D|0|<degree>
| info_cubes:R|B:A|D|0|<degree> | [<owner>.]<table>:R|B:A|D|0|<degree>
| [<owner>.]<prefix>*:R|B:A|D|0|<degree> | (<object_list>) | NO
'R' - row sampling, 'B' - block sampling, 'A' - auto degree,
'D' - default degree, '0' - table degree
default: ALL:R:0
stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R:<degree>,...)
definition of info cube tables
default | rsnspace_tab | [<owner>.]<table> | [<owner>.]<prefix>*
| (<object_list>) | null
default: from RSNSPACE control table
stats_info_cubes = (/BIC/D, /BI0/D, ...)
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 = F:\oracle\MBS\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 = F:\oracle\MBS\sapreorg
directory for table export dump files
default: $SAPDATA_HOME/sapreorg
exp_dump_dir = F:\oracle\MBS\sapreorg
database tables for reorganization
[<owner>.]<table> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<table_list>)
no default
reorg_table = (SDBAH, SAPR3.SDBAD)
database indexes for rebuild
[<owner>.]<index> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<index_list>)
no default
rebuild_index = (SDBAH_{0, SAPR3.SDBAD}0)
database tables for export
[<owner>.]<table> | [<owner>.]<prefix>* | [<owner>.]<prefix>%
| (<table_list>)
no default
exp_table = (SDBAH, SAPR3.SDBAD)
database tables for import
<table> | (<table_list>)
no default
do not specify table owner in the list - use -o|-owner option for this
imp_table = (SDBAH, SDBAD)

Former Member · ‎11-05-2007

backup_dev_type = tape

change it to DISK

former_member204746 · ‎10-29-2007

you can also call your BRBACKP command with option:

brbackup -c -u / -t offline_force

former_member185954 · ‎10-29-2007

Checkout more options..

http://help.sap.com/saphelp_47x200/helpdata/en/0d/d309664a0c11d182b80000e829fbfe/frameset.htm

Regards,

Siddhesh

former_member185954 · ‎10-29-2007

found it in your profile itself:

backup_type = offline

Regards,

Siddhesh

Consistent Offline Back up.Very urgent.

Accepted Solutions (0)

Answers (4)

Answers (4)

catch/handle error upload() method in SAPUI5

Connect to ABAP environment using RFC

Re: SAP BUILD deployment to production

Re: systemVars in SAP BUILD apps

SAP Datasphere test tenant ?