cancel
Showing results for 
Search instead for 
Did you mean: 

back up using brtools

Former Member
0 Kudos

Hi,

We are taking back up through transaction code DB13. Now we want to take up back up of this month through BRTOOLS.

we have to take off line back up. the back up has to be stored in tape.Kindly advice .

Regards,

Asif

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

--> Backup and Recovery

Markus

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Asif,

If you are planning to take a backup using BRTools, you don't want to change anything in the profile.

Before starting the backup, you need to initialize the tape (follow the menu driven brtools options).

Regards,

Varadhu

Former Member
0 Kudos

hi,

Do u initialize tape before taking backup. use option scratch to initialization of tape. chage the device type at .sap file. path is in log file. also change the backup directory on that file.

Thanks

Presu

Former Member
0 Kudos

Hi Persu,

Please fine below log file and please let me know the changes to be done.

  1. @(#) $Id: //bas/700_REL/src/ccm/rsbr/initNT.sap#9 $ SAP

########################################################################

  1. #

  2. SAP BR*Tools sample profile. #

  3. The parameter syntax is the same as for init.ora parameters. #

  4. Enclose parameter values which consist of more than one symbol in #

  5. double quotes. #

  6. After any symbol, parameter definition can be continued on the next #

  7. line. #

  8. A parameter value list should be enclosed in parentheses, the list #

  9. items should be delimited by commas. #

  10. There can be any number of white spaces (blanks, tabs and new lines) #

  11. between symbols in parameter definition. #

  12. Comment lines must start with a hash character. #

  13. #

########################################################################

  1. backup mode [all | all_data | full | incr | sap_dir | ora_dir

  2. | all_dir | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

  3. | <generic_path> | (<object_list>)]

  4. default: all

backup_mode = all

  1. restore mode [all | all_data | full | incr | incr_only | incr_full

  2. | incr_all | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

  3. | <generic_path> | (<object_list>) | partial | non_db

  4. redirection with '=' is not supported here - use option '-m' instead

  5. default: all

restore_mode = all

  1. backup type [offline | offline_force | offline_standby | offline_split

  2. | offline_mirror | offline_stop | online | online_cons | online_split

  3. | online_mirror | online_standby | offstby_split | offstby_mirror

  4. default: offline

backup_type = online

  1. backup device type

  2. [tape | tape_auto | tape_box | pipe | pipe_auto | pipe_box | disk

  3. | disk_copy | disk_standby | stage | stage_copy | stage_standby

  4. | util_file | util_file_online | rman_util | rman_disk | rman_stage

  5. | rman_prep]

  6. default: tape

backup_dev_type = disk

  1. backup root directory [<path_name> | (<path_name_list>)]

  2. default: %SAPDATA_HOME%\sapbackup

backup_root_dir = F:\SAPDEVBACKUP\DATA\

  1. stage root directory [<path_name> | (<path_name_list>)]

  2. default: value of the backup_root_dir parameter

stage_root_dir = F:\SAPDEVBACKUP\DATA\

  1. compression flag [no | yes | hardware | only]

  2. default: no

compress = no

  1. compress command

  2. first $-character is replaced by the source file name

  3. second $-character is replaced by the target file name

  4. <target_file_name> = <source_file_name>.Z

  5. for compress command the -c option must be set

  6. recommended setting for brbackup -k only run:

  7. "%SAPEXE%\mkszip -l 0 -c $ > $"

  8. no default

compress_cmd = "E:\usr\sap\VMD\SYS\exe\uc\NTI386\mkszip -c $ > $"

  1. uncompress command

    1. number of members in RMAN save sets [ 1 | 2 | 3 | 4 | tsp | all ]

  2. default: 1

saveset_members = 1

  1. additional parameters for RMAN

  2. rman_channels and rman_filesperset are only used when rman_util,

  3. rman_disk or rman_stage

  4. rman_channels defines the number of parallel sbt channel allocations

  5. rman_filesperset = 0 means:

  6. one file per save set - for non-incremental backups

  7. all files in one save set - for incremental backups

  8. the others have the same meaning as for native RMAN

  9. rman_channels = 1

  10. rman_filesperset = 0

  11. rman_maxpiecesize = 0 # in KB - former name rman_kbytes

  12. rman_rate = 0 # in KB - former name rman_readrate

  13. rman_maxopenfiles = 0

  14. rman_maxsetsize = 0 # in KB - former name rman_setsize

  15. additional parameters for RMAN version 8.1

  16. the parameters have the same meaning as for native RMAN

  17. rman_diskratio = 0 # deprecated in Oracle 10g

  18. no default

  19. dismount backup volume command in auto loader / juke box

  20. used if backup_dev_type = tape_box | pipe_box

  21. no default

  22. dismount_cmd = "<dismount_cmd> $ $ [$]"

  23. split mirror disks command

  24. used if backup_type = offline_split | online_split | offline_mirror

  25. | online_mirror

  26. no default

  27. split_cmd = "<split_cmd> [$]"

  28. resynchronize mirror disks command

  29. used if backup_type = offline_split | online_split | offline_mirror

  30. | online_mirror

  31. no default

  32. resync_cmd = "<resync_cmd> [$]"

  33. additional options for SPLITINT interface program

  34. no default

  35. split_options = "<split_options>"

  36. resynchronize after backup flag [no | yes]

  37. default: no

  38. split_resync = no

  39. pre-split command

  40. no default

  41. pre_split_cmd = "<pre_split_cmd>"

  42. post-split command

  43. no default

  44. post_split_cmd = "<post_split_cmd>"

  45. volume size in KB = K, MB = M or GB = G (backup device dependent)

  46. default: 1200M

  47. recommended values for tape devices without hardware compression:

  48. 60 m 4 mm DAT DDS-1 tape: 1200M

  49. 90 m 4 mm DAT DDS-1 tape: 1800M

  50. 120 m 4 mm DAT DDS-2 tape: 3800M

  51. 125 m 4 mm DAT DDS-3 tape: 11000M

  52. 112 m 8 mm Video tape: 2000M

  53. 112 m 8 mm high density: 4500M

  54. DLT 2000 10/20 GB: 10000M

  55. DLT 2000XT 15/30 GB: 15000M

  56. DLT 4000 20/40 GB: 20000M

  57. DLT 7000 35/70 GB: 35000M

  58. recommended values for tape devices with hardware compression:

  59. 60 m 4 mm DAT DDS-1 tape: 1000M

  60. 90 m 4 mm DAT DDS-1 tape: 1600M

  61. 120 m 4 mm DAT DDS-2 tape: 3600M

  62. 125 m 4 mm DAT DDS-3 tape: 10000M

  63. 112 m 8 mm Video tape: 1800M

  64. 112 m 8 mm high density: 4300M

  65. DLT 2000 10/20 GB: 9000M

  66. DLT 2000XT 15/30 GB: 14000M

  67. DLT 4000 20/40 GB: 18000M

  68. DLT 7000 35/70 GB: 30000M

tape_size = 100G

  1. volume size in KB = K, MB = M or GB = G used by brarchive

  2. default: value of the tape_size parameter

  3. tape_size_arch = 100G

  4. level of parallel execution

  5. default: 0 - set to number of backup devices

exec_parallel = 0

  1. address of backup device without rewind

  2. [<dev_address> | (<dev_address_list>)]

  3. no default

  4. operating system dependent, examples:

  5. HP-UX: /dev/rmt/0mn

  6. TRU64: /dev/nrmt0h

  7. AIX: /dev/rmt0.1

  8. Solaris: /dev/rmt/0mn

  9. Windows: /dev/nmt0 | /dev/nst0

  10. Linux: /dev/nst0

#tape_address = /dev/nmt0

  1. address of backup device without rewind used by brarchive

  2. default: value of the tape_address parameter

  3. operating system dependent

  4. tape_address_arch = /dev/nmt0

  5. address of backup device with rewind

  6. [<dev_address> | (<dev_address_list>)]

  7. no default

  8. operating system dependent, examples:

  9. HP-UX: /dev/rmt/0m

  10. TRU64: /dev/rmt0h

  11. AIX: /dev/rmt0

  12. Solaris: /dev/rmt/0m

  13. Windows: /dev/mt0 | /dev/st0

  14. Linux: /dev/st0

#tape_address_rew = /dev/mt0

  1. address of backup device with rewind used by brarchive

  2. default: value of the tape_address_rew parameter

  3. operating system dependent

  4. tape_address_rew_arch = /dev/mt0

  5. address of backup device with control for mount/dismount command

  6. [<dev_address> | (<dev_address_list>)]

  7. default: value of the tape_address_rew parameter

  8. operating system dependent

  9. tape_address_ctl = /dev/...

  10. address of backup device with control for mount/dismount command

  11. used by brarchive

  12. default: value of the tape_address_rew_arch parameter

  13. operating system dependent

  14. tape_address_ctl_arch = /dev/...

  15. volumes for brarchive

  16. [<volume_name> | (<volume_name_list>) | SCRATCH]

  17. no default

  1. volumes for brbackup

  2. [<volume_name> | (<volume_name_list>) | SCRATCH]

  3. expiration period for backup volumes in days

  4. default: 30

expir_period = 30

  1. recommended usages of backup volumes

  2. default: 100

tape_use_count = 100

  1. backup utility parameter file

  2. default: no parameter file

  3. util_par_file = initVMD.utl

  4. mount/dismount command parameter file

  5. default: no parameter file

  6. mount_par_file = initVMD.mnt

  7. Oracle connection name to the primary database

  8. [primary_db = <conn_name> | LOCAL]

  9. no default

  10. primary_db = <conn_name>

  11. Oracle connection name to the standby database

  12. [standby_db = <conn_name> | LOCAL]

  13. no default

  14. standby_db = <conn_name>

  15. description of parallel instances for Oracle RAC

  16. parallel_instances = <inst_desc> | (<inst_desc_list>)

  17. <inst_desc_list> - <inst_desc>[,<inst_desc>...]

  18. <inst_desc> - <Oracle_sid>:<Oracle_home>@<conn_name>

  19. <Oracle_sid> - Oracle system id for parallel instance

  20. <Oracle_home> - Oracle home for parallel instance

  21. <conn_name> - Oracle connection name to parallel instance

  22. Please include the local instance in the parameter definition!

  23. default: no parallel instances

  24. example for initRAC001.sap:

  25. parallel_instances = (RAC001:/oracle/RAC/920_64@RAC001,

  26. RAC002:/oracle/RAC/920_64@RAC002, RAC003:/oracle/RAC/920_64@RAC003)

  27. database owner of objects to be checked

  28. <owner> | (<owner_list>)

  29. default: all SAP owners

  30. check_owner = sapr3

  31. database objects to be excluded from checks

  32. all_part | non_sap | [<owner>.]<table> | [<owner>.]<index>

  33. | [<owner>.]<prefix>* | <tablespace> | (<object_list>)

  34. default: no exclusion, example:

  35. check_exclude = (SDBAH, SAPR3.SDBAD)

  36. database owner of SDBAH, SDBAD and XDB tables for cleanup

  37. <owner> | (<owner_list>)

  38. default: all SAP owners

  39. cleanup_owner = sapr3

  40. retention period in days for brarchive log files

  41. default: 30

  42. cleanup_brarchive_log = 30

  43. retention period in days for brbackup log files

  44. default: 30

  45. cleanup_brbackup_log = 30

  46. retention period in days for brconnect log files

  47. default: 30

  48. cleanup_brconnect_log = 30

  49. retention period in days for brrestore log files

  50. default: 30

  51. cleanup_brrestore_log = 30

  52. retention period in days for brrecover log files

  53. default: 30

  54. cleanup_brrecover_log = 30

  55. retention period in days for brspace log files

  56. default: 30

  57. cleanup_brspace_log = 30

  58. retention period in days for archive log files saved on disk

  59. default: 30

  60. cleanup_disk_archive = 30

  61. retention period in days for database files backed up on disk

  62. default: 30

  63. cleanup_disk_backup = 30

  64. retention period in days for brspace export dumps and scripts

  65. default: 30

  66. cleanup_exp_dump = 30

  67. retention period in days for Oracle trace and audit files

  68. default: 30

  69. cleanup_ora_trace = 30

  70. retention period in days for records in SDBAH and SDBAD tables

  71. default: 100

  72. cleanup_db_log = 100

  73. retention period in days for records in XDB tables

  74. default: 100

  75. cleanup_xdb_log = 100

  76. retention period in days for database check messages

  77. default: 100

  78. cleanup_check_msg = 100

  79. database owner of objects to adapt next extents

  80. <owner> | (<owner_list>)

  81. default: all SAP owners

  82. next_owner = sapr3

  83. database objects to adapt next extents

  84. all | all_ind | special | [<owner>.]<table> | [<owner>.]<index>

  85. | [<owner>.]<prefix>* | <tablespace> | (<object_list>)

  86. default: all abjects of selected owners, example:

  87. next_table = (SDBAH, SAPR3.SDBAD)

  88. database objects to be excluded from adapting next extents

  89. all_part | [<owner>.]<table> | [<owner>.]<index> | [<owner>.]<prefix>*

  90. | <tablespace> | (<object_list>)

  91. default: no exclusion, example:

  92. next_exclude = (SDBAH, SAPR3.SDBAD)

  93. database objects to get special next extent size

  94. all_sel:<size>[/<limit>] | [<owner>.]<table>:<size>[/<limit>]

  95. | [<owner>.]<index>:<size>[/<limit>]

  96. | [<owner>.]<prefix>*:<size>[/<limit>] | (<object_size_list>)

  97. default: according to table category, example:

  98. next_special = (SDBAH:100K, SAPR3.SDBAD:1M/200)

  99. maximum next extent size

  100. default: 2 GB - 5 * <database_block_size>

  101. next_max_size = 1G

  102. maximum number of next extents

  103. default: 0 - unlimited

  104. next_limit_count = 300

  105. database owner of objects to update statistics

  106. <owner> | (<owner_list>)

  107. default: all SAP owners

  108. stats_owner = sapr3

  109. database objects to update statistics

  110. all | all_ind | all_part | missing | info_cubes | dbstatc_tab

  111. | dbstatc_mon | dbstatc_mona | [<owner>.]<table> | [<owner>.]<index>

  112. | [<owner>.]<prefix>* | <tablespace> | (<object_list>) | harmful

  113. | locked | system_stats | oradict_stats

  114. default: all abjects of selected owners, example:

  115. stats_table = (SDBAH, SAPR3.SDBAD)

  116. database objects to be excluded from updating statistics

  117. all_part | info_cubes | [<owner>.]<table> | [<owner>.]<index>

  118. | [<owner>.]<prefix>* | <tablespace> | (<object_list>)

  119. default: no exclusion, example:

  120. stats_exclude = (SDBAH, SAPR3.SDBAD)

  121. method for updating statistics for tables not in DBSTATC

  122. E | EH | EI | EX | C | CH | CI | CX | A | AH | AI | AX | E= | C= | =H

  123. | =I | =X | +H | +I

  124. default: according to internal rules

  125. stats_method = E

  126. sample size for updating statistics for tables not in DBSTATC

  127. P<percentage_of_rows> | R<thousands_of_rows>

  128. default: according to internal rules

  129. stats_sample_size = P10

  130. number of buckets for updating statistics with histograms

  131. default: 75

  132. stats_bucket_count = 75

  133. threshold for collecting statistics after checking

  134. default: 50%

  135. stats_change_threshold = 50

  136. number of parallel threads for updating statistics

  137. default: 1

  138. stats_parallel_degree = 1

  139. processing time limit in minutes for updating statistics

  140. default: 0 - no limit

  141. stats_limit_time = 0

  142. parameters for calling DBMS_STATS supplied package

  143. all:R|B:A|D|0|<degree> | all_part:R|B:A|D|0|<degree>

  144. | info_cubes:R|B:A|D|0|<degree> | [<owner>.]<table>:R|B:A|D|0|<degree>

  145. | [<owner>.]<prefix>*:R|B:A|D|0|<degree> | (<object_list>) | NO

  146. 'R' - row sampling, 'B' - block sampling, 'A' - auto degree,

  147. 'D' - default degree, '0' - table degree

  148. default: ALL:R:0

  149. stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R:<degree>,...)

  150. definition of info cube tables

  151. default | rsnspace_tab | [<owner>.]<table> | [<owner>.]<prefix>*

  152. | (<object_list>) | null

  153. default: from RSNSPACE control table

  154. stats_info_cubes = (/BIC/D, /BI0/D, ...)

  155. recovery type [complete | dbpit | tspit | reset | restore | apply

  156. | disaster]

  157. default: complete

  158. recov_type = complete

  159. directory for brrecover file copies

  160. default: $SAPDATA_HOME/sapbackup

  161. recov_copy_dir = E:\oracle\VMD\sapbackup

  162. time period for searching for backups

  163. 0 - all available backups, >0 - backups from n last days

  164. default: 30

  165. recov_interval = 30

  166. degree of paralelism for applying archive log files

  167. 0 - use Oracle default parallelism, 1 - serial, >1 - parallel

  168. default: Oracle default

  169. recov_degree = 0

  170. number of lines for scrolling in list menus

  171. 0 - no scrolling, >0 - scroll n lines

markus_doehr2
Active Contributor
0 Kudos

Asif,

I suggest you read documentation. For something like backup/restore it's important that you understand what you are configuring.

On top, many of the entries are self explanatory.

Markus

Former Member
0 Kudos

Hi Asif,

Login to your system as sidadm and from the command promt execute BRTOOLS

Select option 4, Backup and database copy

Now select, 1 = Database backup

Choose option 2 Backup device type and enter it as TAPE

Chosse option 6 - Backup type and enter it as OFFLINE

Now, press c to continue

Again, press c to continue

Ensure that you have the tape connected to the machine and press c once again.

Revert for any clarifications.

Regards,

SBK

Former Member
0 Kudos

Hi,

the back up has been ended with error.

###############################################################################

BR0051I BRBACKUP 7.00 (22)

BR0165E Parameter 'tape_address' is not set in E:\oracle\VMD\102\database\initVM

D.sap

BR0165E Parameter 'tape_address_rew' is not set in E:\oracle\VMD\102\database\in

itVMD.sap

BR0056I End of database backup: bebbxtnc.log 2009-07-24 12.31.28

BR0280I BRBACKUP time stamp: 2009-07-24 12.31.29

BR0054I BRBACKUP terminated with errors

...............................................................................................................................................................

Please advise me how to set tape address.

Regards,

Asif

Former Member
0 Kudos

Set parameter 'tape_address' in profile initVMD.sap and restart backup . see note 8707

.

Thanks

Anish

Edited by: Anish John on Jul 24, 2009 1:30 PM