cancel
Showing results for 
Search instead for 
Did you mean: 

Backup to a Tape drive fails when triggered from BR*tools

Former Member
0 Kudos

Hello All,

There is a requirement to backup the SAP system data onto a tape. Accordingly, a drive was sepgregated from netbackup utility and the relavant changes have been made in the initSID.sap file.

While starting backup from br*tools with options for Backup device type (device) ...... [tape] and Tape volumes for backup (volume) . [scratch] ; the brbackup has failed with the following error:

I am pasting the log since the brbackup got triggered. Request you to carefully go through the log. The error is at the end of the log. Please help me in resolving this issue.

======================================================================================================

BR0077I Database file for backup: /oracle/OBC/sapbackup/cntrlOBC.dbf

BR0061I 112 files found for backup, total size 2435095.727 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: tape

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

BR0104I 7 scratch volumes will be used

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.15

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.17

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0237I Scratch volume required in device /dev/rmt726.1

BR0210I Please mount BRBACKUP volume, if you have not already done so

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.17

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.19

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.19

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

BR0351I Restoring /oracle/OBC/sapbackup/.tape.hdr0

BR0355I from /dev/rmt726.1 ...

BR0241I Checking label on volume in device /dev/rmt726.1

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.19

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

BR0202I Saving /oracle/OBC/sapbackup/.tape.hdr0

BR0203I to /dev/rmt726.1 ...

BR0209I Volume in device /dev/rmt726.1 has name SCRATCH

BR0202I Saving init_ora

BR0203I to /dev/rmt726.1 ...

BR0202I Saving /oracle/OBC/102_64/dbs/initOBC.sap

BR0203I to /dev/rmt726.1 ...

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.25

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.26

BR0315I 'Alter tablespace PSAPOBX begin backup' successful

BR0202I Saving /oracle/OBC/sapdata1/obx_19/obx.data19

BR0203I to /dev/rmt726.1 ...

BR0278E Command output of 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1':

< obx.data19 > ?

BR0240E Size 512 of saved/restored data is different from the size 32212254720 of file/save set /oracle/OBC/sapdata1/obx_19/obx.data19

1 blocks

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.28

BR0279E Return code from 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1': 2

BR0222E Copying /oracle/OBC/sapdata1/obx_19/obx.data19 to/from /dev/rmt726.1 failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.30

BR0317I 'Alter tablespace PSAPOBX end backup' successful

BR0056I End of database backup: becbbkos.ant 2009-12-04 17.19.28

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.30

BR0054I BRBACKUP terminated with errors

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

BR0292I Execution of BRBACKUP finished with return code 5

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

=========================================================================================================

Sincere Regards,

Hari Kishan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello all,

Seems the error has again pasted wrongly.

Sorry for that. I am pasting the main error as follows:

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.26

BR0315I 'Alter tablespace PSAPOBX begin backup' successful

BR0202I Saving /oracle/OBC/sapdata1/obx_19/obx.data19

BR0203I to /dev/rmt726.1 ...

BR0278E Command output of 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1':

< obx.data19 > ?

BR0240E Size 512 of saved/restored data is different from the size 32212254720 of file/save set /oracle/OBC/sapdata1/obx_19/obx.data19

1 blocks

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.28

BR0279E Return code from 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1': 2

BR0222E Copying /oracle/OBC/sapdata1/obx_19/obx.data19 to/from /dev/rmt726.1 failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.30

BR0317I 'Alter tablespace PSAPOBX end backup' successful

BR0056I End of database backup: becbbkos.ant 2009-12-04 17.19.28

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.30

BR0054I BRBACKUP terminated with errors

Regards,

Hari Kishan

Former Member
0 Kudos

Hi,

BR0279E Return code from 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1': 2

I think you are on HP-UNIX...

Check the parameter tape_copy_cmd in init<SID>.sap profile, it is set to cpio change this value to dd & try again.

Thanks,

Sachin

Former Member
0 Kudos

Hi Sachin,

No the OS is IBM AIX 5.3.

Also, please clarify whether can DD support large data file size. The backup which i want to be run contains data file sizes upto 31 GB.

Thank you.

Hari Kishan

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi All,

Seems the below error is not readable. Therefore, i am again pasting the error.

======================================================================

BR0110I Backup mode: ALL

BR0077I Database file for backup: /oracle/OBC/sapbackup/cntrlOBC.dbf

BR0061I 112 files found for backup, total size 2435095.727 MB

BR0143I Backup type: online

BR0112I Files will not be compressed

BR0130I Backup device type: tape

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

BR0104I 7 scratch volumes will be used

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.15

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.17

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0237I Scratch volume required in device /dev/rmt726.1

BR0210I Please mount BRBACKUP volume, if you have not already done so

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.17

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

c

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.19

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.19

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

BR0351I Restoring /oracle/OBC/sapbackup/.tape.hdr0

BR0355I from /dev/rmt726.1 ...

BR0241I Checking label on volume in device /dev/rmt726.1

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.19

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

BR0202I Saving /oracle/OBC/sapbackup/.tape.hdr0

BR0203I to /dev/rmt726.1 ...

BR0209I Volume in device /dev/rmt726.1 has name SCRATCH

BR0202I Saving init_ora

BR0203I to /dev/rmt726.1 ...

BR0202I Saving /oracle/OBC/102_64/dbs/initOBC.sap

BR0203I to /dev/rmt726.1 ...

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.25

BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.26

BR0315I 'Alter tablespace PSAPOBX begin backup' successful

BR0202I Saving /oracle/OBC/sapdata1/obx_19/obx.data19

BR0203I to /dev/rmt726.1 ...

BR0278E Command output of 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1':

< obx.data19 > ?

BR0240E Size 512 of saved/restored data is different from the size 32212254720 of file/save set /oracle/OBC/sapdata1/obx_19/obx.data19

1 blocks

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.28

BR0279E Return code from 'LANG=C cd /oracle/OBC/sapdata1/obx_19 && echo obx.data19 | LANG=C cpio -ov > /dev/rmt726.1': 2

BR0222E Copying /oracle/OBC/sapdata1/obx_19/obx.data19 to/from /dev/rmt726.1 failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.30

BR0317I 'Alter tablespace PSAPOBX end backup' successful

BR0056I End of database backup: becbbkos.ant 2009-12-04 17.19.28

BR0280I BRBACKUP time stamp: 2009-12-04 17.19.30

BR0054I BRBACKUP terminated with errors

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

BR0292I Execution of BRBACKUP finished with return code 5

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action