Tape backup through DB13

[Former Member]

Dear Experts,

I want to take offline and online backup into tape but when I initialing tape drive through DB13

which parameters require to take backup on tape

Job started

Step 001 started (program RSDBAJOB, variant &0000000000035, user ID BASIS)

Execute logical command BRBACKUP On host BWDEV

Parameters:-jid TAPIN20140805161238 -u / -i force -c force -n 1 -v SCRATCH

BR0051I BRBACKUP 7.40 (10)

BR0055I Start of database backup: beollvud.tib 2014-08-05 16:12:39

BR0484I BRBACKUP log file: /oracle/BWD/sapbackup/beollvud.tib

BR0477I Oracle pfile /oracle/BWD/112_64/dbs/initBWD.ora created from spfile /oracle/BWD/112_64/dbs/spfileBWD.ora

BR0205I Backup volume initialization

BR0058I BRBACKUP action ID: beollvud

BR0059I BRBACKUP function ID: tib

BR0102I Following backup device will be used: /dev/rmt0.1

BR0131I All volumes get the name SCRATCH

BR0129I Force option set - no label checking during initialization

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

BR0207I Volume in device: /dev/rmt0.1 will be initialized with name: SCRATCH

BR0280I BRBACKUP time stamp: 2014-08-05 16:12:39

BR0226I Rewinding tape volume in device /dev/rmt0...

BR0278E Command output of 'LANG=C tctl -f /dev/rmt0 rewind':

/dev/rmt0: I/O error

BR0280I BRBACKUP time stamp: 2014-08-05 16:12:58

BR0279E Return code from 'LANG=C tctl -f /dev/rmt0 rewind': 2

BR0213E Winding tape volume in device /dev/rmt0.1failed

BR0219E Initialization of volume SCRATCH in device /dev/rmt0.1 failed

BR0206I End of backup volume initialization

BR0280I BRBACKUP time stamp: 2014-08-05 16:12:58

BR0054I BRBACKUP terminated with errors

External program terminated with exit code 3

BRBACKUP returned error status E

Job finished

Regards

[Former Member]

Thanks Yogesh 

output of mt -f /dev/rmt0 status

# mt -f /dev/rmt0 status

rmt0 Available 71-T1-01 Other FC SCSI Tape Drive

attribute                  value                           description                               user       

block_size               512                                        BLOCK size (0=variable length)              True

delay                        45                                            Set delay after a FAILED command        True

density_set_1        0                                              DENSITY setting #1                                   True

density_set_2        0                                              DENSITY setting #2                                    True

extfm                       yes                                           Use EXTENDED file marks                        True

location                                                                    Location Label                                              True

lun_id                     0x0                                            Logical Unit Number ID                              False

mode                      yes                                            Use DEVICE BUFFERS during writes     True

node_name           0x2001000e11152b2a         FC Node Name                                            False

res_support           no                                             RESERVE/RELEASE support                   True

ret_error                  no                                             RETURN error on tape change or reset True

rwtimeout               144                Set timeout for the READ or WRITE command                 True

scsi_id                     0x11d00            SCSI ID                                                                               False

var_block_size 0                  BLOCK SIZE for variable length support                                   True

ww_name        0x2002000e11152b2a FC World Wide Name                                               False

#

parameters are set  of my AIX by defualt in  initSID.sap.

Regards

[Former Member]

Hi,

I think your issue has been resolved please close the thread.

Regards

Yogesh Parthe

[Former Member]

Hi,

Please check command

Use

#mt -f /dev/rmt0 status

Set the parameters of your OS as per initSID.sap provided as example.

Regards

Yogesh Parthe

[Former Member]

Dear All  thanks for reply

I am using AIX 7.1 operating system

I have parmaters set in initBWD.sap are

compress = no

backup_dev_type = tape

tape_address = /dev/rmt0.1

tape_address_rew = /dev/rmt0

and when i run the command

login with orasid

mt -f status /dev/rmt0

# mt -f status /dev/rmt0
mt: 0511-575 /dev/rmt0 is not a recognized subcommand.
Usage:  mt [-f Device] Subcommand [Count]
        Valid subcommands are:
        weof
        eof
        fsf
        bsf
        fsr
        bsr
        rewind
        offline
        rewoffl
        status
#

Regards

[Former Member]

HI,

Let me know what OS you are using.

As per below error it regarding setting of tape_address as per your OS

Set the values as below in respect to your OS

# 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

Thanks & Regards

Yogesh Parthe

[former_member188883]

Hi Shahid,

BR0278E Command output of 'LANG=C tctl -f /dev/rmt0 rewind':
/dev/rmt0: I/O error

please check whether TAPE device is available at address /dev/rmt0 using the command below

login with orasid

mt -f status /dev/rmt0

The output should display the block size of tape device.

Regards,

Deepak Kori

[divyanshu_srivastava3]

Hi,

these are the parameter that you have to set in initsid.sap profile of brtools.

compress = no/software/hardware

backup_dev_type = tape

tape_address = (tape1, tape2, tape3, tape4)

tape_address_rew = (tape1, tape2, tape3, tape4)

Refer: SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA)

Divyanshu