Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Backup

Hi

I am Unable to take backup on local disk with brtools

i have MYSAP ECC5.0.

Pls see below profile file and let me know the problem

initDEV.SAP::

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

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

  1. #

  2. SAP backup sample profile. #

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

  2. | <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. | <tablespace_name> | <file_id> | <file_id1>-<file_id2>

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

  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

  4. default: offline

  5. backup_type = 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

  7. backup_dev_type = tape

backup_dev_type = disk

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

  2. default: %SAPDATA_HOME%\sapbackup

#backup_root_dir = F:\oracle\DEV\sapbackup

backup_root_dir = I:\oracle\DEV\sapbackup

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

  2. default: value of the backup_root_dir parameter

#stage_root_dir = F:\oracle\DEV\sapbackup

stage_root_dir = I:\oracle\DEV\sapbackup

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

  2. default: no

compress = yes

  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\DEV\SYS\exe\run\mkszip -c $ > $"

  1. uncompress command

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

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

  4. <source_file_name> = <target_file_name>.Z

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

  6. no default

uncompress_cmd = "E:\usr\sap\DEV\SYS\exe\run\uncompress -c $ > $"

  1. directory for compression [<path_name> | (<path_name_list>)]

  2. default: value of the backup_root_dir parameter

compress_dir = F:\oracle\DEV\sapreorg

  1. brarchive function [save | second_copy | double_save | save_delete

  2. | second_copy_delete | double_save_delete | copy_save

  3. | copy_delete_save | delete_saved | delete_copied]

  4. default: save

archive_function = save

  1. directory for archive log copies to disk

  2. default: first value of the backup_root_dir parameter

archive_copy_dir = F:\oracle\DEV\sapbackup

  1. directory for archive log copies to stage

  2. default: first value of the stage_root_dir parameter

archive_stage_dir = F:\oracle\DEV\sapbackup

  1. new sapdata home directory for disk_copy | disk_standby

  2. no default

  3. new_db_home = X:\oracle\C11

  4. stage sapdata home directory for stage_copy | stage_standby

  5. default: value of the new_db_home parameter

  6. stage_db_home = /oracle/C11

  7. original sapdata home directory for split mirror disk backup

  8. no default

  9. orig_db_home = /oracle/C11

  10. remote host name

  11. no default

  12. remote_host = <host_name>

  13. remote user name

  14. default: current operating system user

  15. remote_user = <user_name>

  16. tape copy command [cpio | cpio_gnu | dd | dd_gnu | rman | rman_dd]

  17. default: cpio

tape_copy_cmd = cpio

  1. disk copy command [copy | dd | dd_gnu | rman]

  2. default: copy

disk_copy_cmd = copy

  1. stage copy command [rcp | scp | ftp]

  2. default: rcp

stage_copy_cmd = rcp

  1. flags for cpio output command

  2. default: -ovB

cpio_flags = -ovB

  1. flags for cpio input command

  2. default: -iuvB

cpio_in_flags = -iuvB

  1. flags for cpio command for copy of directories to disk

  2. default: -pdcu

cpio_disk_flags = -pdcu

  1. flags for dd output command

  2. default: "obs=16k"

  3. caution: option "obs=" not supported for Windows

  4. recommended setting:

  5. Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"

  6. Windows: "bs=nk", example: "bs=64k"

dd_flags = "bs=64k"

  1. flags for dd input command

  2. default: "ibs=16k"

  3. caution: option "ibs=" not supported for Windows

  4. recommended setting:

  5. Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"

  6. Windows: "bs=nk", example: "bs=64k"

dd_in_flags = "bs=64k"

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

  12. rman_readrate = 0

  13. rman_maxopenfiles = 0

  14. rman_setsize = 0

  15. additional parameters for RMAN version 8.1

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

  17. rman_diskratio = 0

  18. rman_pool = 0

  19. rman_duplex = 0 | 1 | 2 | 3 | 4

  20. rman_proxy = no | yes | only

  21. special parameters for an external backup library, example:

  22. rman_parms = "BLKSIZE=65536 ENV=(BACKUP_SERVER=HOSTNAME)"

  23. rman_send = "'<command>'"

  24. rman_send = ("channel sbt_1 '<command1>' parms='<parameters1>'",

  25. "channel sbt_2 '<command2>' parms='<parameters2>'")

  26. remote copy-out command (backup_dev_type = pipe)

  27. $-character is replaced by current device address

  28. no default

copy_out_cmd = "dd ibs=8k obs=64k of=$"

  1. remote copy-in command (backup_dev_type = pipe)

  2. $-character is replaced by current device address

  3. no default

copy_in_cmd = "dd ibs=64k obs=8k if=$"

  1. rewind command

  2. $-character is replaced by current device address

  3. no default

  4. operating system dependent, examples:

  5. HP-UX: "mt -f $ rew"

  6. TRU64: "mt -f $ rewind"

  7. AIX: "tctl -f $ rewind"

  8. Solaris: "mt -f $ rewind"

  9. Windows: "mt -f $ rewind"

  10. Linux: "mt -f $ rewind"

rewind = "mt -f $ rewind"

  1. rewind and set offline command

  2. $-character is replaced by current device address

  3. default: value of the rewind parameter

  4. operating system dependent, examples:

  5. HP-UX: "mt -f $ offl"

  6. TRU64: "mt -f $ offline"

  7. AIX: "tctl -f $ offline"

  8. Solaris: "mt -f $ offline"

  9. Windows: "mt -f $ offline"

  10. Linux: "mt -f $ offline"

rewind_offline = "mt -f $ offline"

  1. tape positioning command

  2. first $-character is replaced by current device address

  3. second $-character is replaced by number of files to be skipped

  4. no default

  5. operating system dependent, examples:

  6. HP-UX: "mt -f $ fsf $"

  7. TRU64: "mt -f $ fsf $"

  8. AIX: "tctl -f $ fsf $"

  9. Solaris: "mt -f $ fsf $"

  10. Windows: "mt -f $ fsf $"

  11. Linux: "mt -f $ fsf $"

tape_pos_cmd = "mt -f $ fsf $"

  1. mount backup volume command in auto loader / juke box

  2. used if backup_dev_type = tape_box | pipe_box

  3. no default

  4. mount_cmd = "<mount_cmd> $ $ $ [$]"

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

  6. used if backup_dev_type = tape_box | pipe_box

  7. no default

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

  9. split mirror disks command

  10. used if backup_type = offline_split | online_split | offline_mirror

  11. | online_mirror

  12. no default

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

  14. resynchronize mirror disks command

  15. used if backup_type = offline_split | online_split | offline_mirror

  16. | online_mirror

  17. no default

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

  19. additional options for SPLITINT interface program

  20. no default

  21. split_options = "<split_options>"

  22. resynchronize after backup flag [no | yes]

  23. default: no

  24. split_resync = no

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

  26. default: 1200M

  27. recommended values for tape devices without hardware compression:

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

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

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

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

  32. 112 m 8 mm Video tape: 2000M

  33. 112 m 8 mm high density: 4500M

  34. DLT 2000 10/20 GB: 10000M

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

  36. DLT 4000 20/40 GB: 20000M

  37. DLT 7000 35/70 GB: 35000M

  38. recommended values for tape devices with hardware compression:

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

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

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

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

  43. 112 m 8 mm Video tape: 1800M

  44. 112 m 8 mm high density: 4300M

  45. DLT 2000 10/20 GB: 9000M

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

  47. DLT 4000 20/40 GB: 18000M

  48. DLT 7000 35/70 GB: 30000M

tape_size = 1200M

  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 = 1200M

  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

volume_archive = (DEVA01, DEVA02, DEVA03, DEVA04, DEVA05,

DEVA06, DEVA07, DEVA08, DEVA09, DEVA10,

DEVA11, DEVA12, DEVA13, DEVA14, DEVA15,

DEVA16, DEVA17, DEVA18, DEVA19, DEVA20,

DEVA21, DEVA22, DEVA23, DEVA24, DEVA25,

DEVA26, DEVA27, DEVA28, DEVA29, DEVA30)

  1. volumes for brbackup

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

  3. no default

volume_backup = (DEVB01, DEVB02, DEVB03, DEVB04, DEVB05,

DEVB06, DEVB07, DEVB08, DEVB09, DEVB10,

DEVB11, DEVB12, DEVB13, DEVB14, DEVB15,

DEVB16, DEVB17, DEVB18, DEVB19, DEVB20,

DEVB21, DEVB22, DEVB23, DEVB24, DEVB25,

DEVB26, DEVB27, DEVB28, DEVB29, DEVB30)

  1. expiration period for backup volumes in days

  2. 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 = initDEV.utl

  4. mount/dismount command parameter file

  5. default: no parameter file

  6. mount_par_file = initDEV.mnt

  7. Oracle instance string to the primary database

  8. [primary_db = <conn_id> | LOCAL]

  9. no default

  10. primary_db = <conn_id>

  11. description of parallel instances for Oracle RAC

  12. parallel_instances = <instance_desc> | (<instance_desc_list>)

  13. <instance_desc_list> -> <instance_desc>[,<instance_desc>...]

  14. <instance_desc> -> <Oracle_sid>:<Oracle_home>@<conn_id>

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

  16. <Oracle_home> -> Oracle home for parallel instance

  17. <conn_id> -> Oracle instance string to parallel instance

  18. Do not include the local instance in the parameter definition!

  19. default: no parallel instances

#

  1. example for initRAC001.sap:

  2. parallel_instances = (RAC002:/oracle/RAC@RAC002,

  3. RAC003:/oracle/RAC@RAC003)

#

  1. example for initRAC002.sap:

  2. parallel_instances = (RAC001:/oracle/RAC@RAC001,

  3. RAC003:/oracle/RAC@RAC003)

  4. database owner of objects to be checked

  5. <owner> | (<owner_list>)

  6. default: all SAP owners

  7. check_owner = sapr3

  8. database objects to be excluded from checks

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

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

  11. default: no exclusion, example:

  12. check_exclude = (SDBAH, SAPR3.SDBAD)

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

  14. <owner> | (<owner_list>)

  15. default: all SAP owners

  16. cleanup_owner = sapr3

  17. retention period in days for brarchive log files

  18. default: 30

  19. cleanup_brarchive_log = 30

  20. retention period in days for brbackup log files

  21. default: 30

  22. cleanup_brbackup_log = 30

  23. retention period in days for brconnect log files

  24. default: 30

  25. cleanup_brconnect_log = 30

  26. retention period in days for brrestore log files

  27. default: 30

  28. cleanup_brrestore_log = 30

  29. retention period in days for brspace log files

  30. default: 30

  31. cleanup_brspace_log = 30

  32. retention period in days for offline redo log files saved on disk

  33. default: 30

  34. cleanup_disk_archive = 30

  35. retention period in days for database file saved on disk

  36. default: 30

  37. cleanup_disk_backup = 30

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

  39. default: 30

  40. cleanup_exp_dump = 30

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

  42. default: 30

  43. cleanup_ora_trace = 30

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

  45. default: 100

  46. cleanup_db_log = 100

  47. retention period in days for records in XDB tables

  48. default: 100

  49. cleanup_xdb_log = 100

  50. retention period in days for database check messages

  51. default: 100

  52. cleanup_check_msg = 100

  53. database owner of objects to adapt next extents

  54. <owner> | (<owner_list>)

  55. default: all SAP owners

  56. next_owner = sapr3

  57. database objects to adapt next extents

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

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

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

  61. next_table = (SDBAH, SAPR3.SDBAD)

  62. database objects to be excluded from adapting next extents

  63. all_part | [<owner>.]<table> | [<owner>.]<index> | <tablespace>

  64. | (<object_list>)

  65. default: no exclusion, example:

  66. next_exclude = (SDBAH, SAPR3.SDBAD)

  67. database objects to get special next extent size

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

  69. | [<owner>.]<index>:<size>[/<limit>] | (<object_size_list>)

  70. default: according to table category, example:

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

  72. maximum next extent size

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

  74. next_max_size = 1G

  75. maximum number of next extents

  76. default: 0 - unlimited

  77. next_limit_count = 300

  78. database owner of objects to update statistics

  79. <owner> | (<owner_list>)

  80. default: all SAP owners

  81. stats_owner = sapr3

  82. database objects to update statistics

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

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

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

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

  87. stats_table = (SDBAH, SAPR3.SDBAD)

  88. database objects to be excluded from updating statistics

  89. all_part | info_cubes | non_sap | [<owner>.]<table>

  90. | [<owner>.]<index> | <tablespace> | (<object_list>)

  91. default: no exclusion, example:

  92. stats_exclude = (SDBAH, SAPR3.SDBAD)

  93. method for updating statistics for tables not in DBSTATC

  94. E | EH | EI | EX | C | CH | CX | E= | C= | =H | =I | =X | +H | +I

  95. default: according to internal rules

  96. stats_method = E

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

  98. P<percentage_of_rows> | R<thousands_of_rows>

  99. default: according to internal rules

  100. stats_sample_size = P10

  101. number of buckets for updating statistics with histograms

  102. definition of info cube tables

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

restore | apply

Tags:
Not what you were looking for? View more on this topic or Ask a question