Error During Offline backup on tape

[Former Member]

Hi All,

We are trying to configure DB backup on Tape from BRTOOLS.

While taking offline backup of the system, we are getting below error:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

BR0202I Saving F:\oracle\SID\11203\database\initSID.sap

BR0203I to /dev/nmt0 ...

BR0280I BRBACKUP time stamp: 2013-01-11 22.01.29

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2013-01-11 22.01.29

BR0307I Shutting down database instance SID ...

BR0280I BRBACKUP time stamp: 2013-01-11 22.02.28

BR0308I Shutdown of database instance SID successful

BR0202I Saving F:\ORACLE\SID\SAPDATA2\SR3_4\SR3.DATA4

BR0203I to /dev/nmt0 ...

BR0278E Command output of 'F: && cd F:\ORACLE\SID\SAPDATA2\SR3_4 && D:\usr\sap\SID\SYS\exe\uc\NTAMD64\brtools.exe -f mtcfo /dev/nmt0 64 SR3.DATA4':

BR0252E Function WriteFile() failed for '/dev/nmt0' at location BrTapeCopy-16

BR0253E errno 1111: The I/O bus was reset.

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.03

BR0279E Return code from 'F: && cd F:\ORACLE\SID\SAPDATA2\SR3_4 && D:\usr\sap\SID\SYS\exe\uc\NTAMD64\brtools.exe -f mtcfo /dev/nmt0 64 SR3.DATA4': 5

BR0222E Copying F:\ORACLE\SID\SAPDATA2\SR3_4\SR3.DATA4 to/from /dev/nmt0 failed due to previous errors

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.07

BR0304I Starting and opening database instance SID ...

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.34

BR0305I Start and open of database instance SID successful

BR0056I End of database backup: bekhoadu.aft 2013-01-11 23.33.03

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.34

BR0054I BRBACKUP terminated with errors

BR0202I Saving F:\oracle\SID\11203\database\initSID.sap

BR0203I to /dev/nmt0 ...

BR0280I BRBACKUP time stamp: 2013-01-11 22.01.29

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2013-01-11 22.01.29

BR0307I Shutting down database instance SID ...

BR0280I BRBACKUP time stamp: 2013-01-11 22.02.28

BR0308I Shutdown of database instance SID successful

BR0202I Saving F:\ORACLE\SID\SAPDATA2\SR3_4\SR3.DATA4

BR0203I to /dev/nmt0 ...

BR0278E Command output of 'F: && cd F:\ORACLE\SID\SAPDATA2\SR3_4 && D:\usr\sap\SID\SYS\exe\uc\NTAMD64\brtools.exe -f mtcfo /dev/nmt0 64 SR3.DATA4':

BR0252E Function WriteFile() failed for '/dev/nmt0' at location BrTapeCopy-16

BR0253E errno 1111: The I/O bus was reset.

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.03

BR0279E Return code from 'F: && cd F:\ORACLE\SID\SAPDATA2\SR3_4 && D:\usr\sap\SID\SYS\exe\uc\NTAMD64\brtools.exe -f mtcfo /dev/nmt0 64 SR3.DATA4': 5

BR0222E Copying F:\ORACLE\SID\SAPDATA2\SR3_4\SR3.DATA4 to/from /dev/nmt0 failed due to previous errors

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.07

BR0304I Starting and opening database instance SID ...

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.34

BR0305I Start and open of database instance SID successful

BR0056I End of database backup: bekhoadu.aft 2013-01-11 23.33.03

BR0280I BRBACKUP time stamp: 2013-01-11 23.33.34

BR0054I BRBACKUP terminated with errors

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Please let us know on how to proceed. I have tried finding this error in SMP also, but didnt get any help over there.

We are running SAP Server on Oracle 11.2.0.3 DB and Windows Server 2008 R2 OS.

Thanks,

Rableen

[Former Member · Accepted solution]

Hi,

Problem resolved after re-initialize the tape but with the force option.

Rableen

[former_member610738]

Hi,

According to "Function WriteFile() failed for '/dev/nmt0' at location BrTapeCopy-16"

This error cud be becoz of write function in the tape as said by Joseph and re-initialize the tape.

Also what is the hardware tool you are using for backups.Please check if the drives into which tape moved (nmt0) is online or not.

WR

Swati

[Former Member]

Hi,

   It seems that some problem which could be due to tape read/write failure. Please see the lines from your log that states that.

Function WriteFile() failed for '/dev/nmt0' at location BrTapeCopy-16

BR0253E errno 1111: The I/O bus was reset.

Solution : Please try to run once again the BR Backup and check whether it works.  If you are still facing the issue, you can confirm this by taking a offline backup to a local disk.

If you are facing the issue with the TAPE, please try to re-initialize the TAPE and try again

I hope it helps.

Thanks and Regards,

Vimal