offline backup terminated

[Former Member]

Dear all

when i am taken a backup through brtools

terminated with following error

i am trying three time but terminated with same problem

BR0202I Saving D:\ORACLE\PRD\SAPDATA4\PRD_302\PRD.DATA302

BR0203I to /dev/nmt0 ...

BR0278E Command output of 'dd bs=64k conv=sync if=D:\ORACLE\PRD\SAPDATA4\PRD_302\PRD.DATA302 of=/dev/nmt0':

dd: unable to initialize ASPI manager

dd: using NT tape support

dd: The physical end of the tape has been reached.

dd: write error: The physical end of the tape has been reached.

4207+0 records in

4206+0 records out

1 write error

dd: The physical end of the tape has been reached.

BR0280I BRBACKUP time stamp: 2009-03-01 22.35.42

BR0279E Return code from 'dd bs=64k conv=sync if=D:\ORACLE\PRD\SAPDATA4\PRD_302\PRD.DATA302 of=/dev/nmt0': 1

BR0222E Copying D:\ORACLE\PRD\SAPDATA4\PRD_302\PRD.DATA302 to/from /dev/nmt0 failed due to previous errors

BR0280I BRBACKUP time stamp: 2009-03-01 22.35.46

BR0304I Starting and opening database instance PRD ...

BR0280I BRBACKUP time stamp: 2009-03-01 22.36.11

BR0305I Start and open of database instance PRD successful

BR0056I End of database backup: beaaocql.aft 2009-03-01 22.35.42

BR0280I BRBACKUP time stamp: 2009-03-01 22.36.13

BR0054I BRBACKUP terminated with errors

thanks

with best reagrds

venkat

[Former Member · Accepted solution]

Dear Venkat,

Where are you going to store the backup...

because it is giving the error that

unable to initialize ASPI manager

try to take the backup into tape and very first initilize that tape ....

ok

if it shows successfully completed then try that whole backup....

very sure you will got that

ok

Anuj

[Former Member]

Your tape is full and can't write data.You can use compress type to backup your DB.

What size is DB and your tape?

[former_member603052]

Hi Venkat,

> dd: The physical end of the tape has been reached.

> dd: write error: The physical end of the tape has been reached.

This means the size of backup you are taking is more than that of the available tape size.

Regards,

Kalyan

[Former Member]

Hi Venkat,

Note : dd: The physical end of the tape has been reached.

Cheers

Deepanshu

[Former Member]

Hi venkat,

Reintialize tape using brtools

to label

brbackup -i force -v <TAPE_LABEL>

to show label

brbackup -i show

[Former Member]

Hi Venkat,

dd: The physical end of the tape has been reached.

dd: write error: The physical end of the tape has been reached.

Is telling that tape size limit is exceeded, just check the same in initSID.sap file and change the same accordingly.

If you are using small size tape lesser tha your actual database size, change the same.

Regards

Nick Loy

[Former Member]

Hi,

Check out following SAP Note.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=540543]

Please check tape_size parameter as suggested by above SAP note.

Hope this helps.

Manoj

Edited by: Manoj Chintawar on Mar 2, 2009 2:08 PM