Backup error in DEV and QA Server

[Former Member]

Dear all ,

I got the error when i am trying to take backup ,

pls check the log .

BR0280I BRBACKUP time stamp: 2010-07-15 11.29.52

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

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

/dev/rmt0: No such device or address

BR0280I BRBACKUP time stamp: 2010-07-15 11.29.52

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

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

BR0056I End of database backup: bedrfoqg.ant 2010-07-15 11.29.52

BR0280I BRBACKUP time stamp: 2010-07-15 11.29.52

BR0054I BRBACKUP terminated with errors

Kindly suggest

Regards

[Former Member · Accepted solution]

As said check the parameter in initSID.sap then before taking backup first initialize / lable the tape in brtools then proceed for taking backup.

Regards;

[Former Member · Accepted solution]

dear all ,

I have checked the below thinks in my Dev server and i have logged in root user .

i have mentioned this command (lsdev -Cc tape) . i got below output .

rmt0 Defined 04-00-01 IBM 3580 Ultrium Tape Drive (FCP)

rmt1 Defined 04-01-01 IBM 3580 Ultrium Tape Drive (FCP)

rmt2 Available 04-00-01 IBM 3580 Ultrium Tape Drive (FCP)

rmt3 Available 04-01-01 IBM 3580 Ultrium Tape Drive (FCP)

smc0 Defined 04-00-01 IBM 3573 Tape Medium Changer (FCP)

smc1 Available 04-01-01 IBM 3573 Tape Medium Changer (FCP)

and i have checked initIRDsap.

tape_address = /dev/rmt0.1 and tape_address_rew = /dev/rmt0

Kindly suggest .

[Former Member · Accepted solution]

Hi,

rmt0 Defined 04-00-01 IBM 3580 Ultrium Tape Drive (FCP)
rmt1 Defined 04-01-01 IBM 3580 Ultrium Tape Drive (FCP)
rmt2 Available 04-00-01 IBM 3580 Ultrium Tape Drive (FCP)
rmt3 Available 04-01-01 IBM 3580 Ultrium Tape Drive (FCP)
smc0 Defined 04-00-01 IBM 3573 Tape Medium Changer (FCP)
smc1 Available 04-01-01 IBM 3573 Tape Medium Changer (FCP)

If I am not wrong you can use the devices which has status "Available"....

So try to configure and use rmt2, rmt3 or smc1 tape device in init<SID>.sap file.

Hope, it will help you...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Try to find the tape which is really available,before changing the parameter initSID.sap

You can test by the commond "tar -cxf /dev/rmtx"

Edited by: bring_you_dollar on Jul 19, 2010 10:16 AM

[Former Member · Accepted solution]

Hi Rajesh,

let me know which parameter i have to update . kindly provdide step .

we are using AIX servers.

Regards

[Former Member · Accepted solution]

Hi,

You need to change the below parameters in init<SID>.sap

(use "rmt2" instead of "rmt0")

(make backup of your existing init<SID>.sap file before modifications...)

tape_address_rewind

tape_address

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi rajesh ,

I have changed the below mwntion parameter .

tape_address = /dev/rmt2

tape_address_rew = /dev/rmt2

i have followed the below steps for archive log backup through Brtools .

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 program status

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

-

---

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2010-07-19 16.43.11

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-07-19 16.43.11

BR0657I Input menu 17 - please enter/check input values

-

---

BRARCHIVE main options for archivelog backup and verification

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

2 - BRARCHIVE function (function) .... [save]

3 - Backup device type (device) ...... [tape]

4 ~ Tape volumes for backup (volume) . []

5 # BACKINT/Mount profile (parfile) .. []

6 - Database user/password (user) .... [/]

7 ~ Maximum number of files (number) . []

8 - Back up disk backup (archive) .... [no]

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

-

---

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2010-07-19 16.43.36

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2010-07-19 16.43.36

BR0681I Enter string value for "volume" (scratch|<tape_vol>|<tape_vol_list>) []:

000031L3

BR0280I BRTOOLS time stamp: 2010-07-19 16.43.58

BR0683I New value for "volume": '000031L3'

BR0280I BRTOOLS time stamp: 2010-07-19 16.43.58

BR0657I Input menu 17 - please enter/check input values

-

---

BRARCHIVE main options for archivelog backup and verification

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

2 - BRARCHIVE function (function) .... [save]

3 - Backup device type (device) ...... [tape]

4 ~ Tape volumes for backup (volume) . [000031L3]

5 # BACKINT/Mount profile (parfile) .. []

6 - Database user/password (user) .... [/]

7 ~ Maximum number of files (number) . []

8 - Back up disk backup (archive) .... [no]

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

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-07-19 16.44.03

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-07-19 16.44.03

BR0657I Input menu 18 - please enter/check input values

-

---

Additional BRARCHIVE options for archivelog backup

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

2 - Query mode (query) ................ [no]

3 - Compression mode (compress) ....... [no]

4 - Verification mode (verify) ........ [no]

5 - Fill mode, group size (fill) ...... [no]

6 - Modify mode, delay apply (modify) . [no]

7 - Additional output (output) ........ [no]

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

9 - BRARCHIVE command line (command) .. [-p initIRQ.sap -save -d tape -v 000031

L3 -k no -l E]

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

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-07-19 16.44.07

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRARCHIVE will be started with options '-p initIRQ.sap -save -d tape -v

000031L3 -k no -l E'

BR0280I BRTOOLS time stamp: 2010-07-19 16.44.07

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

c

BR0280I BRTOOLS time stamp: 2010-07-19 16.44.13

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0002I BRARCHIVE 7.00 (34)

BR0180E Backup devices with and without rewind have the same address

BR0189W Expiration period equal 0 - backup volumes could be immediately overwrit

ten

BR0007I End of offline redo log processing: aedsahub.log 2010-07-19 16.44.13

BR0280I BRARCHIVE time stamp: 2010-07-19 16.44.14

BR0005I BRARCHIVE terminated with errors

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

BR0292I Execution of BRARCHIVE finished with return code 3

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

to repeat the last action

BR0280I BRTOOLS time stamp: 2010-07-19 16.44.14

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

Kindly Advise

[Former Member · Accepted solution]

Hi,

BR0180E Backup devices with and without rewind have the same address BR0189W Expiration period equal 0 - backup volumes could be immediately overwrit ten

Set the below parameter as :

tape_address_rew =/dev/rmt2n

(Check commented option for example..)

then try...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi,

BR0180E Backup devices with and without rewind have the same address BR0189W Expiration period equal 0 - backup volumes could be immediately overwrit ten

Set the below parameter as :

tape_address_rew =/dev/rmt2n

(Check commented option for example..)

then try...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh ,

I have changed below parameter

tape_address_rew =/dev/rmt2n

after i have fired the backup , i got the below error .

BR0112I Files will not be compressed

BR0130I Backup device type: tape

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

BR0103I Following backup volume will be used: IRQA01

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

BR0208I Volume with name IRQA01 required in device /dev/rmt0.1

BR0280I BRARCHIVE time stamp: 2010-07-20 12.38.37

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

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

/dev/rmt2n: No such file or directory

BR0280I BRARCHIVE time stamp: 2010-07-20 12.38.37

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

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

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: aedsejuh.cds 2010-07-20 12.38.37

BR0280I BRARCHIVE time stamp: 2010-07-20 12.38.37

BR0005I BRARCHIVE terminated with errors

Kindly advise

Regards

[Former Member · Accepted solution]

Hi,

In your scenario, it should be like:

For AIX :

tape_address_rew = /dev/rmt2

and

tape_address = /dev/rmt2.1

(Apologies, Please ignore my previous post...)

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi Rajesh ,

Thanks for reply . now backup is running

once again thanks to Rajesh and all

Regards

[Former Member]

Hi

Is the Device name correct. Also is the device getting properly reached. It might be issue at the HW level...

Thanks

Rishi

[fjhernanz]

Hi,

During the tape operations brbackup needs to rewind the tape hence ther's a command for it in rewind_cmd in init<sid>.sap

It fails with error '//dev/rmt0: No such device or address' which could mean that either the tape drive has some problems or it's name is incorrect. Since Brbackup uses normal OS command for the operation, you can also reproduce it outside brbackup

In any case you should check with you HW team since its a problem with the tape drive itself and not from brtiools

Br,

Javier