Online & offline backup problem

[Former Member]

Dear All.

Please help me..

Now I am working at client side on the combination of Unix, SAP 3.1h & Oracle 7.1 version. Using SAPDBA I am trying to take the online & offline backup but every time getting following problem

This is the very old system, clinet has only one tape drive which support upto 24 gb only the size of the backup is around 54gb..

So I am taking the backup in software compression option .

upto last week it was working fine with comression rate 6.7675:1

but in last week got error with compression rate 10.0845:1

the error is as follows

BR201I Compressing /oracle/IFP/sapdata7/btabd_15/btabd.data15

BR203I to /oracle/IFP/sapreorg/btabd.data15.Z ...

BR202I Saving /oracle/IFP/sapreorg/btabd.data15.Z

BR203I to /dev/nrmt0h ...

#FILE..... /oracle/IFP/sapdata7/btabd_15/btabd.data15

#SAVED.... btabd.data15.Z IFPB08/23 7.7540:1 121708947

BR280I Time stamp 2007-05-14 21.57.46

BR063I 20 of 101 files processed - 17330.469 MB of 52985.126 MB done.

BR204I Percentage done: 32.71%, estimated end time: 01:38

BR001I ****************__________________________________

BR201I Compressing /oracle/IFP/sapdata7/btabd_16/btabd.data16

BR203I to /oracle/IFP/sapreorg/btabd.data16.Z ...

BR202I Saving /oracle/IFP/sapreorg/btabd.data16.Z

BR203I to /dev/nrmt0h ...

BR278E Command output of 'LANG=C cd /oracle/IFP/sapreorg && echo btabd.data16.Z LANG=C cpio -ovB > /dev/nrmt0h':

cpio: btabd.data16.Z : Early EOF

btabd.data16.Z

499685 Blocks

BR279E Return code from 'LANG=C cd /oracle/IFP/sapreorg && echo btabd.data16.Z LANG=C cpio -ovB > /dev/nrmt0h': 0

BR222E Copying /oracle/IFP/sapreorg/btabd.data16.Z to/from /dev/nrmt0h failed due to previous errors.

BR317I Alter tablespace PSAPBTABD end backup successful.

BR115I Compression rate for all files 10.0845:1

BR056I End of database backup: bdvgiytp ant 2007-05-14 22.11.39

BR054I BRBACKUP terminated with errors.

so I thought this error was related to copmression rate...then I determine the compression rate of the tablespace.

its shows Compression rate for all files 4.8353:1

Then once agiain I tried the online backup.

but backup was terminated with same error but the compression rate is 5.7873:1

Please anybody can help me..

My Mail id is ddkande@hotmail.com

[Former Member]

1) Have you made BRBACKUP to calculate the compression rate before the backup? if so, How?

2) which is the the tape_size value?

3) what is the size to be backed up reported by BRBACKUP?

4) are you sure the tape is OK?, you mentioned it is 24 Gb ( compressed or uncompressed? but it is failing at only 17Gb

[Former Member]

Thanks for the reply

1.

yes i have calculate the compression rate using sapdba

in sapdba there is one option in backup function

'Determine compression rates'

using this option i have calculate the compression rate

see the esult as follws

#FILE..... /oracle/IFP/sapdata1/btabd_21/btabd.data21 8.5497:1 250197653

BR280I Time stamp 2007-05-16 16.53.41

BR063I 99 of 101 files processed - 49821.110 MB of 52985.126 MB done.

BR204I Percentage done: 94.03%, estimated end time: 17:08

BR001I ***********************************************___

#FILE..... /oracle/IFP/sapdata4/stabd_4/stabd.data4 43.3433:1 36288728

BR280I Time stamp 2007-05-16 16.55.04

BR063I 100 of 101 files processed - 51321.118 MB of 52985.126 MB done.

BR204I Percentage done: 96.86%, estimated end time: 17:02

BR001I ************************************************__

#FILE..... /oracle/IFP/sapdata5/btabi_3/btabi.data3 4.7951:1 363876192

BR280I Time stamp 2007-05-16 16.56.08

BR063I 101 of 101 files processed - 52985.126 MB of 52985.126 MB done.

BR204I Percentage done: 100.00%, estimated end time: 16:56

BR001I **************************************************

BR115I Compression rate for all files 4.8353:1

BR056I End of database backup: bdvgrilr cmb 2007-05-16 16.56.09

BR052I BRBACKUP terminated successfully.

SAPDBA: BRBACKUP terminated successfully.

2. tape_size = 24000M

3. BR063I 101 of 101 files processed - 52985.126 MB of 52985.126 MB done.

4. I have tried with atleast 5 to 6 new tapes . size of the tape is 24gb

if you any solution , please help me

[Former Member]

I think the problem is on the tape_size parameter.

You have set:

tape_size = 24000M

and you are using compression.

Now my question is the type of tape you are using.

Is it a DLT? what is the uncompressed capacity of the tape.

For example, for a DLT2000 with a compressed capacity of 20 GB ( uncompressed capacity of 10GB the value to be set if you are using compression is 8000M

Please, check note 8707

[Former Member]

thanks for relpy

I am using HP 3 Digital Data Storage Drive.

& tape is HP DDS-3 data cartridge 125m with compressed capacity 24gb, compress transfer rate is 3 mb/s

I am using the software compression.

[Former Member]

Hi,

If compressed capacity is 24 Gb, then you cannot indicate to BRBACKUP that teh size of your tape is 24Gb. You have to indicate a little less than your <b>uncompressed </b>capacity. I'd say:

tape_size = 9000M

BRBACKUP will be able to identify that he will need more than 1 tape to perform the backup and stop to request a new one ( or two ) during the backup procedure.

[former_member204746]

brbackup -k only

this command will calculate software compression rates.

[Former Member]

thank you so much.

As per your suggested note, I changed the tape_size= 10000M parameter & taken online backup with hardware compression. It would ask for 2 tapes so I have given the two different volume name for two different tapes after that backup is completed successfully on two tapes.

But my question is

Can it possible to restore the backup from two tapes?

[Former Member]

There is no problem performing a restore from two tapes.

BRRECOVER will check the BRBACKUP log file and request the required tapes.

[Former Member]

Thank you very much ...

My online & offline backup problem was solved..

One more issue is ..

I want to do Database reorgainsation ...80% of database is filled.

can u help me out for this...

How to do it?

What preventive measures we have to take during database reorganisation?

Please tell me in details...because I dont know very much in oracle

[former_member204746]

read SAP note 646681, it will explain the whole process. I did multiple reorgs using recommendations from that note.