Database Backup error - small tape size vs big database size

[Former Member]

Dear Experts,

I am facing little bit issue in Backup, we having 220/440 GB Tape media, now our database size is grow up to 450 GB, so for some percantage of backup it is throwing me error.

So can i use mulitiple tape media for database backup. When we are scheduling through DB13.

******************8Backup log***********

BR0051I BRBACKUP 6.40 (42)

BR0055I Start of database backup: bdvpqhwr.ant 2007-07-02 23.00.01

BR0484I BRBACKUP log file: /oracle/GPD/sapbackup/bdvpqhwr.ant

BR0280I BRBACKUP time stamp: 2007-07-02 23.00.05

BR0319I Control file copy created: /oracle/GPD/sapbackup/cntrlGPD.dbf 9854976

BR0101I Parameters

Name Value

oracle_sid GPD

oracle_home /oracle/GPD/920_64

oracle_profile /oracle/GPD/920_64/dbs/initGPD.ora

sapdata_home /oracle/GPD

sap_profile /oracle/GPD/920_64/dbs/initGPD.sap

backup_mode ALL

backup_type online

backup_dev_type tape_auto

compress hardware

tape_copy_cmd dd

cpio_flags -ovB

cpio_in_flags -iuvB

dd_flags obs=64k bs=64k

dd_in_flags ibs=64k bs=64k

rewind mt -f $ rewind

rewind_offline mt -f $ offline

tape_size 225280.000 MB

tape_address /dev/rmt0

tape_address_rew /dev/rmt0

volume_backup GPDB01

expir_period 1

tape_use_count 100

exec_parallel 0

oracle_info GPD 9.2.0.5.0 8192 50719 1484241596

sap_info 620 SAPGD2 GPD S1675034106 R3_ORA 0020155000

make_info sun_64 OCI_920 Feb 3 2007

command_line brbackup -u / -jid ALLOG20060918230000 -c force -t online -m all -p initGPD.sap -v GPDB01 -a -c force -p initGPD.sap -sd

BR0280I BRBACKUP time stamp: 2007-07-03 05.46.28

BR0063I 201 of 206 files processed - 448117.039 MB of 452258.461 MB done

BR0204I Percentage done: 99.08%, estimated end time: 5:50

BR0001I **************************************************

BR0202I Saving /oracle/GPD/sapdata4/undo_6/undo.data6

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

BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/GPD/sapdata4/undo_6/undo.data6 of=/dev/rmt/0mn':

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

2605+0 records in

2605+0 records out

BR0280I BRBACKUP time stamp: 2007-07-03 05.46.42

BR0279E Return code from 'LANG=C dd obs=64k bs=64k if=/oracle/GPD/sapdata4/undo_6/undo.data6 of=/dev/rmt/0mn': 2

BR0222E Copying /oracle/GPD/sapdata4/undo_6/undo.data6 to/from /dev/rmt/0mn failed due to previous errors

BR0280I BRBACKUP time stamp: 2007-07-03 05.46.44

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0056I End of database backup: bdvpqhwr.ant 2007-07-03 05.46.42

BR0280I BRBACKUP time stamp: 2007-07-03 05.46.45

BR0054I BRBACKUP terminated with errors.

Waiting for your response.

Thanks & Regards

K R Singh

SAP BASIS Consultant.

IIL

[Former Member · Accepted solution]

Hi

As I can see you are using H/W compression for backups, and also the tape size mentioned in initSID.sap is 225GB.

You can try increasing the tape size values say to 250/275 GB and run

brbackup -k online option to re-caltculate the compression ratio.

Then can try taking the backup.

If it still does not work then the only way is to backup on to 2 tapes,Volumes can be menitoned when running through DB13, in case of single tape drive then brbackup stops at a point where someone needs to enter next tape for continutaion.

Also check SAP notes 19909,8707

Hope this helps

Ravinder