on 06-07-2006 3:02 PM
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
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 = "uncompress -c $ > $"
directory for compression [<path_name> | (<path_name_list>)]
default: value of the backup_root_dir parameter
compress_dir = /oracle/SP1/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 = /oracle/SP1/sapbackup
directory for archive log copies to stage
default: first value of the stage_root_dir parameter
archive_stage_dir = /oracle/SP1/sapbackup
new sapdata home directory for disk_copy | disk_standby
no default
new_db_home = /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_dd]
default: cpio
tape_copy_cmd = cpio
disk copy command [copy | dd | dd_gnu | rman]
default: copy
disk_copy_cmd = copy
stage copy command [rcp | scp | ftp]
default: rcp
stage_copy_cmd = rcp
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
cpio_disk_flags = -pdcu
flags for dd output command
default: "obs=16k"
recommended setting:
Unix: "obs=nk bs=nk", example: "obs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_flags = "obs=64k bs=64k"
flags for dd input command
default: "ibs=16k"
recommended setting:
Unix: "ibs=nk bs=nk", example: "ibs=64k bs=64k"
Windows: "bs=nk", example: "bs=64k"
dd_in_flags = "ibs=64k 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_kbytes = 0
rman_readrate = 0
rman_maxopenfiles = 0
rman_setsize = 0
additional parameters for RMAN version 8.1
the parameters have the same meaning as for native RMAN
rman_diskratio = 0
rman_pool = 0
rman_duplex = 0 | 1 | 2 | 3 | 4
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>'")
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 $ rew"
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 $ offl"
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_tape.csh $ $ $"
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
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 = 1200M
volume size in KB = K, MB = M or GB = G used by brarchive
default: value of the tape_size parameter
tape_size_arch = 1200M
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
Linux: /dev/nst0
tape_address = /dev/rmt/0mn
address of backup device without rewind used by brarchive
default: value of the tape_address parameter
operating system dependent
tape_address_arch = /dev/rmt/0mn
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
Linux: /dev/st0
tape_address_rew = /dev/rmt/0m
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/rmt/0m
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/scsi/3
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 = (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)
volumes for brbackup
[<volume_name> | (<volume_name_list>) | SCRATCH]
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)
expiration period for backup volumes in days
default:
expir_period = 4
recommended usages of backup volumes
default: 100
tape_use_count = 100
backup utility parameter file
default: no parameter file
util_par_file = initSP1.utl
mount/dismount command parameter file
default: no parameter file
mount_par_file = initSP1.mnt
Oracle instance string to the primary database
[primary_db = <conn_id> | LOCAL]
no default
primary_db = <conn_id>
description of parallel instances for Oracle RAC
parallel_instances = <instance_desc> | (<instance_desc_list>)
<instance_desc_list> -> <instance_desc>[,<instance_desc>...]
<instance_desc> -> <Oracle_sid>:<Oracle_home>@<conn_id>
<Oracle_sid> -> Oracle system id for parallel instance
<Oracle_home> -> Oracle home for parallel instance
<conn_id> -> Oracle instance string to parallel instance
Do not include the local instance in the parameter definition!
default: no parallel instances
#
example for initRAC001.sap:
parallel_instances = (RAC002:/oracle/RAC@RAC002,
RAC003:/oracle/RAC@RAC003)
#
example for initRAC002.sap:
parallel_instances = (RAC001:/oracle/RAC@RAC001,
RAC003:/oracle/RAC@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>
| <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 brspace log files
default: 30
cleanup_brspace_log = 30
retention period in days for offline redo log files saved on disk
default: 30
cleanup_disk_archive = 30
retention period in days for database file saved 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>
| <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> | <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>] | (<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>
| <tablespace> | (<object_list>)
default: all abjects of selected owners, example:
stats_table = (SDBAH, SAPR3.SDBAD)
database objects to be excluded from updating statistics
all_part | info_cubes | non_sap | [<owner>.]<table>
| [<owner>.]<index> | <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 | CX | 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:<degree> | all_part:R|B:<degree> | info_cubes:R|B:<degree>
| [<owner>.]<table>:R|B:<degree> | (<object_list>)
default: NULL - use ANALYZE statement
stats_dbms_stats = ([ALL:R:1,][<owner>.]<table>:R|B:<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 = /oracle/SP1/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 = /oracle/SP1/sapreorg
directory for table export dump files
default: $SAPDATA_HOME/sapreorg
exp_dump_dir = /oracle/SP1/sapreorg
database tables for reorganization
[<owner>.]<table> | (<table_list>)
no default
reorg_table = (SDBAH, SAPR3.SDBAD)
database indexes for rebuild
[<owner>.]<index> | (<index_list>)
no default
rebuild_index = (SDBAH0, SAPR3.SDBAD0)
database tables for export
[<owner>.]<table> | (<table_list>)
no default
exp_table = (SDBAH, SAPR3.SDBAD)
database tables for import
[<owner>.]<table> | (<table_list>)
no default
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.