Skip to Content
author's profile photo Former Member
Former Member

Backup failed due to tape size

Hello All,

The online or offline backup of the system is failing because of the tape size.

The tape size is currently 40Gigs and the tape device can hold only a single tape of maximun size 40GB.

I had used the following command hoping I would get a prompt for the insertion of the next tape:

brbackup -u / -jid ALLOG20081125212000 -c -t online -m all -p initXYZ.sap -a -c -p initXYZ.sap -cds

These are the logs from the SAPBACKUP folder:

BR0280I BRBACKUP time stamp: 2008-11-26 00.48.53

BR0063I 68 of 96 files processed - 132665.898 MB of 185266.664 MB done

BR0204I Percentage done: 71.61%, estimated end time: 2:12

BR0001I ************************************______________

BR0280I BRBACKUP time stamp: 2008-11-26 00.48.53

BR0317I 'Alter tablespace PSAPEL700I end backup' successful

BR0280I BRBACKUP time stamp: 2008-11-26 00.48.53

BR0315I 'Alter tablespace PSAPES700D begin backup' successful

BR0202I Saving /oracle/XYZ/sapdata8/es700d_1/es700d.data1

BR0203I to /dev/rmt/0mn ...

BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/PRD/sapdata8/es700d_1/es700d.data1 of=/dev/rmt/0mn':

dd: unexpected short write, wrote 0 bytes, expected 65536

49248+0 records in

49248+0 records out

BR0280I BRBACKUP time stamp: 2008-11-26 00.56.05

BR0279E Return code from 'LANG=C dd obs=64k bs=64k if=/oracle/PRD/sapdata8/es700d_1/es700d.data1 of=/dev/rmt/0mn': 2

BR0222E Copying /oracle/XYZ/sapdata8/es700d_1/es700d.data1 to/from /dev/rmt/0mn failed due to previous errors

BR0056I End of database backup: bdzinffh.ant 2008-11-26 00.56.05

BR0280I BRBACKUP time stamp: 2008-11-26 00.56.07

BR0054I BRBACKUP terminated with errors

Could you please suggest a work around for this,where we get a prompt for the next tape to be inserted and the backup can be continued.

Regards,

Prasanna

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Dec 02, 2008 at 12:58 AM

    does your initXYZ.sap contain the tape size?

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      That message is also valid for hardware compression.

      what has to be done is to recalculate the compression.

      Probably that is the problem. The compression rates are old, then BRBACKUP cannot calculate properly how much space is available on the tape.

      do as the message indicates:

      run BRBACKUP with option '-k only'

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2008 at 01:44 PM

    Hi,

    You may run the compressDB. after that schedule a online backup using

    brbackup -c -m all -t online -a -c -cds

    check whether if it is demanding for another media, so that we can connclude it is required to provied another media.

    -Gokul

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      I worked out another alternative as the tape backups were failing.

      I changed the following:

      device_type=disk.

      Changed the oracle root dir and archive bkup directory,

      The backup is now being moved to the disk.

      Thank you all for your support.

      Regards,

      Prasanna

      Edited by: Prasanna K on Dec 18, 2008 11:09 PM

      Edited by: Prasanna K on Dec 19, 2008 10:47 PM

  • author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2008 at 11:09 AM

    Dear Prasanna,

    Please run following command and send output to me

    brbackup -u / -q

    Regards

    Aditya

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Aditya,

      gemerp1:oraprd 1% brbackup -u / -q

      BR0051I BRBACKUP 7.00 (11)

      BR0055I Start of database backup: bdzkxaam.qub 2008-12-08 11.02.28

      BR0477I Oracle pfile /oracle/PRD/102_64/dbs/initPRD.ora created from spfile /oracle/PRD/102_64/dbs/spfilePRD.ora

      BR0280I BRBACKUP time stamp: 2008-12-08 11.02.38

      BR0057I Backup of database: PRD

      BR0058I BRBACKUP action ID: bdzkxaam

      BR0059I BRBACKUP function ID: qub

      BR0110I Backup mode: ALL

      BR0077I Database file for backup: /oracle/PRD/sapbackup/cntrlPRD.dbf

      BR0061I 96 files found for backup, total size 185266.664 MB

      BR0143I Backup type: online

      BR0113I Files will be compressed by hardware

      BR0130I Backup device type: tape

      BR0102I Following backup device will be used: /dev/rmt/0mn

      BR0103I Following backup volume will be used: PRDB03

      BR0124I Query option set - no processing

      BR0056I End of database backup: bdzkxaam.qub 2008-12-08 11.02.38

      BR0280I BRBACKUP time stamp: 2008-12-08 11.02.38

      BR0052I BRBACKUP completed successfully

      gemerp1:oraprd 2%

      It says it would use PRD03.When i start the backup with PRDB03 and the tape PRDB03 gets exhausted, it never prompts for the next tape volume.

      Regards.

      Prasanna

  • Posted on Dec 18, 2008 at 10:52 PM

    if problem is fixed, change the status of the topic to "ANSWERED".

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 09:48 PM

    Thanks all.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.