Skip to Content
avatar image
Former Member

Backup problem with Sapr/3-HP-UX-Oracle on autoloaders

hello there!!!

1. we are trying to take backup from SAP on tape DEVICE HP Ultrium 2-SCSI 8 Slots autoloader. attached to HP-UX which is our production server.RDBMS is Oracle

2.we are using BRTOOLS for backing up.

3. we are attaching the error message with this message.

kindly reply back ASAP.

we are also attaching details of files

mount_cmd

dismount_cmd

initSP1.sap

erro log from DB12 at prodcution server.

please help

thanks

saurabh

<b>details of initSP1.sap</b>

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

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

#

SAP backup 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. #

#

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

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

| <tablespace_name> | <file_id> | <file_id1>-<file_id2>

| <generic_path> | (<object_list>)]

default: all

ckup_mode = all

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

| <tablespace_name> | <file_id> | <file_id1>-<file_id2>

| <generic_path> | (<object_list>)]

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

default: all

store_mode = all

backup type [offline | offline_force | offline_standby | offline_split

| offline_mirror | offline_stop | online | online_cons | online_split

| online_mirror

default: offline

ckup_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

ckup_dev_type = tape_auto

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

default: $SAPDATA_HOME/sapbackup

ckup_root_dir = /oracle/SP1/sapbackup

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

default: value of the backup_root_dir parameter

age_root_dir = /oracle/SP1/sapbackup

compression flag [yes | no | hardware | only]

default: no

mpress = 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:

"compress -b 12 -c $ > $"

no default

mpress_cmd = "compress -c $ > $"

uncompress command

first $-character is replaced by the source file name

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

  2. <source_file_name> = <target_file_name>.Z

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

  4. no default

uncompress_cmd = "uncompress -c $ > $"

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

  2. default: value of the backup_root_dir parameter

compress_dir = /oracle/SP1/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 = /oracle/SP1/sapbackup

  1. directory for archive log copies to stage

  2. default: first value of the stage_root_dir parameter

archive_stage_dir = /oracle/SP1/sapbackup

  1. new sapdata home directory for disk_copy | disk_standby

  2. no default

  3. new_db_home = /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. recommended setting:

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

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

dd_flags = "obs=64k bs=64k"

  1. flags for dd input command

  2. default: "ibs=16k"

  3. recommended setting:

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

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

dd_in_flags = "ibs=64k 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 $ rew"

  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 $ offl"

  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

mount_cmd = "<mount_tape.csh $ $ $"

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

  2. used if backup_dev_type = tape_box | pipe_box

  3. no default

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

  5. split mirror disks command

  6. used if backup_type = offline_split | online_split | offline_mirror

  7. | online_mirror

  8. no default

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

  10. resynchronize mirror disks command

  11. used if backup_type = offline_split | online_split | offline_mirror

  12. | online_mirror

  13. no default

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

  15. additional options for SPLITINT interface program

  16. no default

  17. split_options = "<split_options>"

  18. resynchronize after backup flag [no | yes]

  19. default: no

  20. split_resync = no

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

  22. default: 1200M

  23. recommended values for tape devices without hardware compression:

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

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

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

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

  28. 112 m 8 mm Video tape: 2000M

  29. 112 m 8 mm high density: 4500M

  30. DLT 2000 10/20 GB: 10000M

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

  32. DLT 4000 20/40 GB: 20000M

  33. DLT 7000 35/70 GB: 35000M

  34. recommended values for tape devices with hardware compression:

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

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

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

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

  39. 112 m 8 mm Video tape: 1800M

  40. 112 m 8 mm high density: 4300M

  41. DLT 2000 10/20 GB: 9000M

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

  43. DLT 4000 20/40 GB: 18000M

  44. 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

  10. Linux: /dev/nst0

tape_address = /dev/rmt/0mn

  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/rmt/0mn

  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

  14. Linux: /dev/st0

tape_address_rew = /dev/rmt/0m

  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/rmt/0m

  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

tape_address_ctl = /dev/scsi/3

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

  2. used by brarchive

  3. default: value of the tape_address_rew_arch parameter

  4. operating system dependent

  5. tape_address_ctl_arch = /dev/...

  6. volumes for brarchive

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

  8. no default

volume_archive = (SP1A01, SP1A02, SP1A03, SP1A04, SP1A05,

SP1A06, SP1A07, SP1A08, SP1A09, SP1A10,

SP1A11, SP1A12, SP1A13, SP1A14, SP1A15,

SP1A16, SP1A17, SP1A18, SP1A19, SP1A20,

SP1A21, SP1A22, SP1A23, SP1A24, SP1A25,

SP1A26, SP1A27, SP1A28, SP1A29, SP1A30)

  1. volumes for brbackup

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

  3. no default

volume_backup = (SP1B01, SP1B02, SP1B03, SP1B04, SP1B05,

SP1B06, SP1B07, SP1B08, SP1B09, SP1B10,

SP1B11, SP1B12, SP1B13, SP1B14, SP1B15,

SP1B16, SP1B17, SP1B18, SP1B19, SP1B20,

SP1B21, SP1B22, SP1B23, SP1B24, SP1B25,

SP1B26, SP1B27, SP1B28, SP1B29, SP1B30)

  1. expiration period for backup volumes in days

  2. default:

expir_period = 4

  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 = initSP1.utl

  4. mount/dismount command parameter file

  5. default: no parameter file

  6. mount_par_file = initSP1.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. default: 75

  103. stats_bucket_count = 75

  104. threshold for collecting statistics after checking

  105. default: 50%

  106. stats_change_threshold = 50

  107. number of parallel threads for updating statistics

  108. default: 1

  109. stats_parallel_degree = 1

  110. processing time limit in minutes for updating statistics

  111. default: 0 - no limit

  112. stats_limit_time = 0

  113. parameters for calling DBMS_STATS supplied package

  114. all:R|B:<degree> | all_part:R|B:<degree> | info_cubes:R|B:<degree>

  115. | [<owner>.]<table>:R|B:<degree> | (<object_list>)

  116. default: NULL - use ANALYZE statement

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

  118. definition of info cube tables

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

  120. | (<object_list>) | null

  121. default: from RSNSPACE control table

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

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

  124. | disaster]

  125. default: complete

  126. recov_type = complete

  127. directory for brrecover file copies

  128. default: $SAPDATA_HOME/sapbackup

  129. recov_copy_dir = /oracle/SP1/sapbackup

  130. time period for searching for backups

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

  132. default: 30

  133. recov_interval = 30

  134. degree of paralelism for applying archive log files

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

  136. default: Oracle default

  137. recov_degree = 0

  138. number of lines for scrolling in list menus

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

  140. default: 20

  141. scroll_lines = 20

  142. time period for displaying profiles and logs

  143. 0 - all available logs, >0 - logs from n last days

  144. default: 30

  145. show_period = 30

  146. directory for brspace file copies

  147. default: $SAPDATA_HOME/sapreorg

  148. space_copy_dir = /oracle/SP1/sapreorg

  149. directory for table export dump files

  150. default: $SAPDATA_HOME/sapreorg

  151. exp_dump_dir = /oracle/SP1/sapreorg

  152. database tables for reorganization

  153. [<owner>.]<table> | (<table_list>)

  154. no default

  155. reorg_table = (SDBAH, SAPR3.SDBAD)

  156. database indexes for rebuild

  157. [<owner>.]<index> | (<index_list>)

  158. no default

  159. rebuild_index = (SDBAH0, SAPR3.SDBAD0)

  160. database tables for export

  161. [<owner>.]<table> | (<table_list>)

  162. no default

  163. exp_table = (SDBAH, SAPR3.SDBAD)

  164. database tables for import

  165. [<owner>.]<table> | (<table_list>)

  166. no default

  167. imp_table = (SDBAH, SAPR3.SDBAD)

<b>details for BRBACKUP</b>

8

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.33

BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.33

BR0656I Choice menu 10 - please make a selection

-


Additional functions for backup and copy

1 = Update of compression rates

2 - Preparation of RMAN backups

3 - Deletion of database disk backups

4 - Deletion of archivelog disk backups

5 - Controlling of BRARCHIVE run

6 - Initialization of BRBACKUP tape volumes

7 - Initialization of BRARCHIVE tape volumes

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

7

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.41

BR0663I Your choice: '7'

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.41

BR0657I Input menu 33 - please check/enter input values

-


Options for initialization of BRARCHIVE tape volumes

1 - BRARCHIVE profile (profile) ...... [initSP1.sap]

2 - Initialization type (initialize) . [rename]

3 ~ Number of volumes (number) ....... []

4 - Confirmation mode (confirm) ...... [yes]

5 - Message language (language) ...... [E]

6 ~ Tape volume names (volume) ....... [SP1A01]

7 - BRARCHIVE command line (command) . [-p initSP1.sap -i -l E -v SP1A01]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.42

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRARCHIVE will be started with options '-p initSP1.sap -i -l E -v SP1A01

'

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.42

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2006-06-07 17.31.44

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0002I BRARCHIVE 6.40 (15)

BR0006I Start of offline redo log processing: adstwapc.tia 2006-06-07 17.31.44

BR0205I Backup volume initialization

BR0009I BRARCHIVE action ID: adstwapc

BR0010I BRARCHIVE function ID: tia

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0144I Following backup volume name will be used: SP1A01

BR0108I Automatic volume changing is active

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.44

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:

c

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.45

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0207I Volume in device: /dev/rmt/0mn will be initialized with name: SP1A01

BR0210I Please mount BRARCHIVE volume, if you have not already done so

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.45

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:

c

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.53

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.53

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0278W Command output of 'LANG=C mt -f /dev/rmt/0m rew':

/dev/rmt/0m: No such device or address

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.53

BR0279W Return code from 'LANG=C mt -f /dev/rmt/0m rew': 1

BR0213W Winding tape volume in device /dev/rmt/0mn failed

BR0212I Please check the volume or the device

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.53

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:

c

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.56

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.56

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0278W Command output of 'LANG=C mt -f /dev/rmt/0m rew':

/dev/rmt/0m: No such device or address

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.57

BR0279W Return code from 'LANG=C mt -f /dev/rmt/0m rew': 1

BR0213W Winding tape volume in device /dev/rmt/0mn failed

BR0212I Please check the volume or the device

BR0280I BRARCHIVE time stamp: 2006-06-07 17.31.57

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:

c

BR0280I BRARCHIVE time stamp: 2006-06-07 17.32.03

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRARCHIVE time stamp: 2006-06-07 17.32.03

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0278W Command output of 'LANG=C mt -f /dev/rmt/0m rew':

/dev/rmt/0m: No such device or address

BR0280I BRARCHIVE time stamp: 2006-06-07 17.32.03

BR0279W Return code from 'LANG=C mt -f /dev/rmt/0m rew': 1

BR0213W Winding tape volume in device /dev/rmt/0mn failed

BR0212I Please check the volume or the device

BR0280I BRARCHIVE time stamp: 2006-06-07 17.32.03

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRARCHIVE:

s

BR0280I BRARCHIVE time stamp: 2006-06-07 17.32.06

BR0257I Your reply: 's'

BR0260E BRARCHIVE canceled by user

BR0206I End of backup volume initialization

BR0280I BRARCHIVE time stamp: 2006-06-07 17.32.06

BR0005I BRARCHIVE terminated with errors

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

BR0292I Execution of BRARCHIVE finished with return code 2

BR0668I Warnings or errors occured - you can continue to ignore them or go back

to repeat the last action

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.06

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

b

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.09

BR0257I Your reply: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.09

BR0657I Input menu 33 - please check/enter input values

-


Options for initialization of BRARCHIVE tape volumes

1 - BRARCHIVE profile (profile) ...... [initSP1.sap]

2 - Initialization type (initialize) . [rename]

3 ~ Number of volumes (number) ....... []

4 - Confirmation mode (confirm) ...... [yes]

5 - Message language (language) ...... [E]

6 ~ Tape volume names (volume) ....... [SP1A01]

7 - BRARCHIVE command line (command) . [-p initSP1.sap -i -l E -v SP1A01]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

b

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.10

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.10

BR0656I Choice menu 10 - please make a selection

-


Additional functions for backup and copy

1 = Update of compression rates

2 - Preparation of RMAN backups

3 - Deletion of database disk backups

4 - Deletion of archivelog disk backups

5 - Controlling of BRARCHIVE run

6 - Initialization of BRBACKUP tape volumes

7 - Initialization of BRARCHIVE tape volumes

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

b

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.11

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.11

BR0656I Choice menu 9 - please make a selection

-


Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

8

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.18

BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.18

BR0656I Choice menu 10 - please make a selection

-


Additional functions for backup and copy

1 = Update of compression rates

2 - Preparation of RMAN backups

3 - Deletion of database disk backups

4 - Deletion of archivelog disk backups

5 - Controlling of BRARCHIVE run

6 - Initialization of BRBACKUP tape volumes

7 - Initialization of BRARCHIVE tape volumes

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

6

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.24

BR0663I Your choice: '6'

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.24

BR0657I Input menu 32 - please check/enter input values

-


Options for initialization of BRBACKUP tape volumes

1 - BRBACKUP profile (profile) ....... [initSP1.sap]

2 - Initialization type (initialize) . [rename]

3 ~ Number of volumes (number) ....... []

4 - Confirmation mode (confirm) ...... [yes]

5 - Message language (language) ...... [E]

6 ~ Tape volume names (volume) ....... [SP1B01]

7 - BRBACKUP command line (command) .. [-p initSP1.sap -i -l E -v SP1B01]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.29

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRBACKUP will be started with options '-p initSP1.sap -i -l E -v SP1B01'

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.29

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2006-06-07 17.32.30

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0051I BRBACKUP 6.40 (15)

BR0055I Start of database backup: bdstwaqw.tib 2006-06-07 17.32.30

BR0205I Backup volume initialization

BR0058I BRBACKUP action ID: bdstwaqw

BR0059I BRBACKUP function ID: tib

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0144I Following backup volume name will be used: SP1B01

BR0108I Automatic volume changing is active

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.30

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.39

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0207I Volume in device: /dev/rmt/0mn will be initialized with name: SP1B01

BR0210I Please mount BRBACKUP volume, if you have not already done so

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.39

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.42

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.42

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0278W Command output of 'LANG=C mt -f /dev/rmt/0m rew':

/dev/rmt/0m: No such device or address

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.43

BR0279W Return code from 'LANG=C mt -f /dev/rmt/0m rew': 1

BR0213W Winding tape volume in device /dev/rmt/0mn failed

BR0212I Please check the volume or the device

BR0280I BRBACKUP time stamp: 2006-06-07 17.32.43

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel

<b>

error log from DB12</b>

Job log

Job started

Step 001 started (program RSDBAJOB, variant &0000000000001, user ID SAP*)

Execute logical command BRBACKUP On host nraprd

Parameters:-u / -c force -t online -m all -p initSP1.sap -w use_dbv

BR0051I BRBACKUP 6.40 (15)

BR0055I Start of database backup: bdstwaus.ant 2006-06-07 17.34.10

BR0477I Oracle pfile /oracle/SP1/920_64/dbs/initSP1.ora created from spfile /oracle/SP1/920_64/dbs/spfileSP1.ora

BR0319I Control file copy created: /oracle/SP1/sapbackup/cntrlSP1.dbf 6791168

BR0070W File /oracle/SP1/sapdata3/sp1_1/sp1.data1greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata3/sp1_2/sp1.data2greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata3/sp1_3/sp1.data3greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata3/sp1_4/sp1.data4greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata4/sp1_6/sp1.data6greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata4/sp1_8/sp1.data8greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata4/sp1_10/sp1.data10 greater than volume size - trying to back it upanyway

BR0070W File /oracle/SP1/sapdata4/sp1_9/sp1.data9greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata4/sp1_7/sp1.data7greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata4/sp1_11/sp1.data11 greater than volume size - trying to back it upanyway

BR0070W File /oracle/SP1/sapdata3/sp1_5/sp1.data5greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata1/sp1640_1/sp1640.data1 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata1/sp1640_2/sp1640.data2 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata1/sp1640_4/sp1640.data4 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata2/sp1640_6/sp1640.data6 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata2/sp1640_8/sp1640.data8 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata2/sp1640_10/sp1640.data10 greater than volume size - trying to backit up anyway

BR0070W File /oracle/SP1/sapdata4/sp1640_12/sp1640.data12 greater than volume size - trying to backit up anyway

BR0070W File /oracle/SP1/sapdata4/sp1640_14/sp1640.data14 greater than volume size - trying to backit up anyway

BR0070W File /oracle/SP1/sapdata4/sp1640_13/sp1640.data13 greater than volume size - trying to backit up anyway

BR0070W File /oracle/SP1/sapdata3/sp1640_11/sp1640.data11 greater than volume size - trying to backit up anyway

BR0070W File /oracle/SP1/sapdata2/sp1640_9/sp1640.data9 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata2/sp1640_7/sp1640.data7 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata1/sp1640_5/sp1640.data5 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata1/sp1640_3/sp1640.data3 greater than volume size - trying to back it up anyway

BR0070W File /oracle/SP1/sapdata1/undo_1/undo.data1 greater than volume size - trying to back it upanyway

BR0280I BRBACKUP time stamp: 2006-06-07 17.34.12

BR0057I Backup of database: SP1

BR0058I BRBACKUP action ID: bdstwaus

BR0059I BRBACKUP function ID: ant

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/SP1/sapbackup/cntrlSP1.dbf

BR0061I 31 files found for backup, total size 59680.711 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: tape_auto

BR0102I Following backup device will be used: /dev/rmt/0mn

BR0103I Following backup volumes will be used:

SP1B01,SP1B02,SP1B03,SP1B04,SP1B05,SP1B06,SP1B07,SP1B08,SP1B09,SP1B10,

SP1B11,SP1B12,SP1B13,SP1B14,SP1B15,SP1B16,SP1B17,SP1B18,SP1B19,SP1B20,

SP1B21,SP1B22,SP1B23,SP1B24,SP1B25,SP1B26,SP1B27,SP1B28

BR0108I Automatic volume changing is active

BR0136I Verify option set - double the work to do

BR0148I DBVERIFY will be used for verification

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0208I Volume with name SP1B01 SP1B02 SP1B03 SP1B04 SP1B05 SP1B06 SP1B07 SP1B08 SP1B09 SP1B10

SP1B11 SP1B12 SP1B13 SP1B14 SP1B15 SP1B16 SP1B17 SP1B18 SP1B19 SP1B20

SP1B21 SP1B22 SP1B23 SP1B24 SP1B25 SP1B26 SP1B27 SP1B28 required in device /dev/rmt/0mn

BR0280I BRBACKUP time stamp: 2006-06-07 17.34.12

BR0226I Rewinding tape volume in device /dev/rmt/0m ...

BR0278E Command output of 'LANG=C mt -f /dev/rmt/0m rew':

/dev/rmt/0m: No such device or address

BR0280I BRBACKUP time stamp: 2006-06-07 17.34.13

BR0279E Return code from 'LANG=C mt -f /dev/rmt/0m rew': 1

BR0213E Winding tape volume in device /dev/rmt/0mn failed

BR0056I End of database backup: bdstwaus.ant 2006-06-07 17.34.13

BR0280I BRBACKUP time stamp: 2006-06-07 17.34.13

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 5

BRBACKUP returned error status E

Job finished

<b>shell script for mount and dismount

mount_tape_csh</b>

#!/bincsh -f

set_slot='echo $3 | cut -b 5-6'

mtx -d $2 -| $slot

echo $slot > $SAPDATA_HOME/sapbackup/.slot

<b>dismount_tape_csh</b>

#!bin/csh –f

Set_slot=`cat$SAPDATA_HOME/sapbackup/.slot

Mtx –d $2 –u$slot

Echo $slot>$SAPDATA_HOME.sapbackup/.slot

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 30, 2007 at 03:49 PM

    Hi Saurabh,

    Please check your available device for backup, I think device is not active,

    take help of OS support.

    you can issue this command to check

    #tctl -f /dev/rmt/0m status

    #tctl -f /dev/rmt/0mn status

    Please update this node, if your problem is solved.

    Regards

    Praveen Verma

    Add comment
    10|10000 characters needed characters exceeded