cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

error log from DB12 at prodcution server.

please help

thanks

saurabh

error log from DB12

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

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

/dev/rmt/0m: No such device or address</b>BR0280I BRBACKUP time stamp: 2006-06-07 17.34.13

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

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

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

BR0280I BRBACKUP time stamp: 2006-06-07 17.34.13

<b>BR0054I BRBACKUP terminated with errors

External program terminated with exit code 5

BRBACKUP returned error status E</b>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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

The problem is "no such device or address".

The volume size can be tuned, but its' just a warning of the estimation. It can be forced to continue and may work.

try this at unix command:

mt -f /dev/rmt/0m rew

You should see the same error message.

do a "ls -l /dev/rmt/0m" and check if it's there.

some times the device name changes if it has been replaced. check "ls -l /dev/rmt" to see what device are listed there.

You may need to do a ioscan and insf if the device has not been recognized by the system (usually if you reboot your system, these are done for you automatically, it is only necessary if you add/replaced the tape device online).

Former Member
0 Kudos

Hi,

You have to check the following paramters on init<sid>.SAP

tape_size = 1200M ---> default value

You ave to check the size of you file systems, probably many of then are bigger that default value.

tape_address = /dev/rmt/0m

The device should be there, if it is not the system show a message like this:

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

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

Cheers

Former Member
0 Kudos

Hi,

From your backup log,it seems that your backup size is exceeding your backup pool size. Check whether your backup size is fit enough on your backup pool.

hope that can help you.

ardhian

Former Member
0 Kudos

Hi,

I do not think that the error is related to the backup size:

<quote>

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

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

<b>/dev/rmt/0m: No such device or address</b>

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

<quote>

The error is clear. You are trying to perform a backup on /dev/rmt/0m

This device does <b>not </b>exist on your server.

You have to get in touch with your system administrator and he must give you the correct address for the tape device.