error in DB13 backup

[Former Member]

Dear All,

I am getting error in my complte online backup through DB13. Error is

-

---

BR0204I Percentage done: 31.60%, estimated end time: 20:38

BR0001I ****************__________________________________

BR0202I Saving /oracle/PRD/sapdata3/prd_18/prd.data18

BR0203I to /dev/rmt/1mn ...

BR0278E Command output of 'LANG=C dd obs=64k bs=64k if=/oracle/PRD/sapdata3/prd_18/prd.data18 of=/dev/rmt/1mn':

20057+0 records in

20056+1 records out

I/O error

BR0280I BRBACKUP time stamp: 2008-10-03 19.54.04

BR0279E Return code from 'LANG=C dd obs=64k bs=64k if=/oracle/PRD/sapdata3/prd_18/prd.data18 of=/dev/rmt/1mn': 2

BR0222E Copying /oracle/PRD/sapdata3/prd_18/prd.data18 to/from /dev/rmt/1mn failed due to previous errors

BR0280I BRBACKUP time stamp: 2008-10-03 19.54.06

BR0317I 'Alter tablespace PSAPPRD end backup' successful

BR0056I End of database backup: bdyyjykn.ant 2008-10-03 19.54.04

BR0280I BRBACKUP time stamp: 2008-10-03 19.54.06

-

---

After that, i try to use new tape. It initialize successfully. But when i am taking backup, it start to give another error ie.

-

---

BR0105E 0 free backup volumes found, 1 required

BR0056I End of database backup: bdyykinm.ant 2008-10-03 21.24.57

BR0280I BRBACKUP time stamp: 2008-10-03 21.24.57

BR0054I BRBACKUP terminated with errors

-

---

I also try another tape drive which is working with another server.

Plz sugeest me as soon as possible..

Regards,

Ankit

[Former Member · Accepted solution]

Hi Ankit,

If you have already tried initializing tape with volume scratch and failed as suggested above then

this might be caused due to missing microsoft dlls.

Pl refer to SAP Note 954960 - BRARCHIVE/BRBACKUP backups on Windows terminate

SAP Note 684106 - Microsoft runtime DLLs.

Pl lets us know the O/S.

Regards

[Former Member · Accepted solution]

My OS is Hp-UX 11.23

[former_member204746 · Accepted solution]

check tape_size value in initSID.sap

[Former Member · Accepted solution]

It is ok with tape size. It is 200GB & my database size is 100 gb.

Now only previous error is there. ie red in read out i/o error.

Regards,

Ankit

[former_member204746 · Accepted solution]

clean your tape drive and try with a new tape.

[Former Member · Accepted solution]

Dear Brunelle,

I have already tried it previously but the error was same. But now when i again try with another tape it is working fine now.

I don't know how this problem is resolved.

can any one telll me the possible reasons for that ?

Regards,

Ankit

[former_member204746 · Accepted solution]

sounds simple. your previous tape was bad. the new one was good.

[Former Member · Accepted solution]

No. actually i has already tried this with new tape previously.

[former_member213869 · Accepted solution]

Solution for this problem is settings of two parameters init<SID>.sap

Cross check parameters :

expir_period

For my system i have set to 2.

tape_size

For my system i have set to 400G

Many Thanks

Shailendra Lavangade

[former_member204746]

check your connection to your tape drive. maybe you cable is not fully inserted or is faulty.

[debasissahoo]

Ankit,

Error indicates that you don't have free volume for taking backup. Initialize some free volumes and take the backup.

Thanks.

[Former Member]

Dear Sahoo,

I have put there new initialized tape but the error is same.

Regards,

Ankit

[Former Member]

Hi,

As per Note 17163 - BRARCHIVE/BRBACKUP messages and codes

Either add the required number of valid volumes to the list in the profile, or use the Command Option -v SCRATCH when you start the program. Repeat the processing.

regards,

kaushal