Backup

[Former Member]

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

[Former Member]

what kind of error message are you getting?