Backup failed due to tape size

[Former Member]

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

[markus_doehr2 · Accepted solution]

does your initXYZ.sap contain the tape size?

Markus

[Former Member · Accepted solution]

Hi,

As suggest by markus please check the tape_size.

And tape size (parameter tape_size) must be reduced.

Best luck,

Atil

[Former Member · Accepted solution]

Hello,

Yes, the tape_size is set to 40Gigs currently.

Should i reduce it to 35GB or something in the INITXYZ.SAP file.

Awaiting for help.

Regards,

Prasanna

[Former Member · Accepted solution]

Hello Prasanna,

Yes Please do that and let us know the result.

Regards,

Atil

[Former Member · Accepted solution]

Hi Atul,

I've made the changes in initsid file,will go for a backup tomorrow.

Wanted to know if all the options in the below command are correct:

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

Regards,

Prasanna

[former_member204746 · Accepted solution]

you should never put option -jid manually. This option is added by DB13 when it starts from DB13, never manually from OS level.

I would use:

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

This will start an online backup and then backup offline dredologs by calling BRARCHIVE in the same run.

if you also run BRARCHIVE many times a day, I would recommend using this instead:

brbackup -u / -c -t online_cons -m all -p initXYZ.sap

[Former Member · Accepted solution]

I changed the parameter tape_size from 40Gigs to 35Gigs and issues the backup with the following:

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

Environement:Solaris and oracle 10g

Backup again failed with the following error:

#FILE..... /oracle/PRD/sapdata8/el700i_1/el700i.data1

#SAVED.... el700i.data1 PRDB20/71

BR0280I BRBACKUP time stamp: 2008-12-03 20.27.59

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

BR0204I Percentage done: 71.61%, estimated end time: 21:51

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

BR0280I BRBACKUP time stamp: 2008-12-03 20.28.00

BR0317I 'Alter tablespace PSAPEL700I end backup' successful

BR0280I BRBACKUP time stamp: 2008-12-03 20.28.00

BR0315I 'Alter tablespace PSAPES700D begin backup' successful

BR0202I Saving /oracle/PRD/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/es70 0d_1/es700d.data1 of=/dev/rmt/0mn':

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

62879+0 records in

62879+0 records out

BR0280I BRBACKUP time stamp: 2008-12-03 20.37.23

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

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

BR0056I End of database backup: bdzjzqjz.ant 2008-12-03 20.37.23

BR0280I BRBACKUP time stamp: 2008-12-03 20.37.27

BR0054I BRBACKUP terminated with errors

Can someone please suggest .

Regards,

Prasanna

Edited by: Prasanna K on Dec 4, 2008 4:59 AM

[fidel_vales · Accepted solution]

Hi,

I'm a bit confuse. You mentioned:

> The tape size is currently 40Gigs

The tape capacity you mention is with or without compression?

What is your database size?

I do not think you can fit it in one tape:

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

I assume you are using compression and this could be "a bit" off.

Finally, could you check at the beginning of your log file if the size change is reflected?

[former_member204746 · Accepted solution]

provide the first 50 lines of your brbackup run.

you are storing 185GB of data on a 40GB tape. that's about a 4.5 to 1 compression rate which is expected.

so, reduce your DB size or use a new tape drive with more capacity.

[Former Member · Accepted solution]

Hi Experts,

The tape used is DLT IV:8000 series.(Size is 40/80 compressed:uncompressed)

compression mode=hardware.

The tape device does not read the tapes automatically,instead a tape has to be inserted manually each time.Ideally, i want to insert the second tape to be inserted after the first is exhausted.

But I'm not getting the prompt for doing so.

The option of having a new device are very bleak and hence want to get a serial backup running on these tapes.

the first few lines from .ant file are:

more bdzjzqjz.ant

BR0051I BRBACKUP 7.00 (11)

BR0055I Start of database backup: bdzjzqjz.ant 2008-12-03 16.56.27

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-03 16.56.30

BR0319I Control file copy created: /oracle/PRD/sapbackup/cntrlPRD.dbf 17473536

BR0083W Compression rates out of date - run BRBACKUP with option '-k only'

BR0101I Parameters

Name Value

oracle_sid PRD

oracle_home /oracle/PRD/102_64

oracle_profile /oracle/PRD/102_64/dbs/initPRD.ora

sapdata_home /oracle/PRD

sap_profile /oracle/PRD/102_64/dbs/initPRD.sap

backup_mode ALL

backup_type online

backup_dev_type tape

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 $ rew

rewind_offline mt -f $ offline

tape_size 35000.000 MB

tape_address /dev/rmt/0mn

tape_address_rew /dev/rmt/0m

volume_backup PRDB01,PRDB02,PRDB03,PRDB04,PRDB05,PRDB06,PRDB07,PRDB08,PRDB09,PRDB10,

PRDB11,PRDB12,PRDB13,PRDB14,PRDB15,PRDB16,PRDB17,PRDB18,PRDB19,PRDB20

expir_period 30

tape_use_count 1010

exec_parallel 0

system_info oraprd/oraprd gemerp1 SunOS 5.10 Generic_125100-04 sun4u

oracle_info PRD 10.2.0.2.0 8192 47359 489529953

sap_info 700 SAPR3 PRD F0680426544 R3_ORA 0020120811

make_info sun_64 OCI_101 Feb 28 2006

BR0116I ARCHIVE LOG LIST before backup for database instance PRD

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PRD/saparch/PRDarch

Archive format %t_%s_%r.dbf

Oldest online log sequence 47356

Next log sequence to archive 47359

Current log sequence 47359 SCN: 489529953

Database block size 8192 Thread: 1

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link

Type MaxSize IncrSize BlkSize

PSAPBTABD ONLINE% ONLINE /oracle/PRD/sapdata5/btabd_21/btabd.data21 2097152000 84 2097910 NOLINK

FILE 0 0 8192

PSAPBTABD ONLINE% ONLINE+ /oracle/PRD/sapdata5/btabd_23/btabd.data23 8313118720 17 2097910 NOLINK

FILE 8388608000 134217728 8192

PSAPBTABD ONLINE% ONLINE /oracle/PRD/sapdata5/btabd_2/btabd.data2 2097152000 30 2097910 NOLINK

FILE 0 0 8192

PSAPBTABD ONLINE% ONLINE+ /oracle/PRD/sapdata10/btabd_24/btabd.data24 8313118720 35 2097638 NOLINK

FILE 8388608000 134217728 8192

command_line brbackup -u / -c -t online -m all -p initPRD.sap -a -c -p initPRD.sap -cds

Please suggest .

Prasanna

[former_member204746 · Accepted solution]

I noticed this message:

BR0083W Compression rates out of date - run BRBACKUP with option '-k only'

This means that you are using software compression rate as well.

change initSID.ora to change compression off.

but you will still fail to backup your whole database on such a small drive, even with compression ON.

[Former Member · Accepted solution]

hi,

The Os team has mounted the following on the system.

/backup/prd

1.1T 199M 1.0T 1% /backup

Can we take the brbackup on this particular /backup NFS.

Is it just that i have to change the following:

backup_device_type=disk;

compression=no

backup root dir and the archive root dir.

Could someone please let me know any other settings tht have to be done incase if this is possible,

There is an arrangement to move the file from /bacup to a detachable harddrive.

Regards,

Prasanna

[fidel_vales · Accepted solution]

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'

[Former Member]

Thanks all.

[former_member204746]

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

[Former Member]

Dear Prasanna,

Please run following command and send output to me

brbackup -u / -q

Regards

Aditya

[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

[Former Member]

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

[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