Database Backup Online Error

[Former Member]

Hi,

While trying to take the Online database backup , i get the following error

BR0278E Command output of 'LANG=C cd /oracle/CPD/sapdata1/sr3_1 && echo sr3.data1 | LANG=C cpio -ovB > /dev/rmt0.1':

<sr3.data1> ?

BR0280I BRBACKUP time stamp: 2007-09-14 15.42.29

BR0279E Return code from 'LANG=C cd /oracle/CPD/sapdata1/sr3_1 && echo sr3.data1 | LANG=C cpio -ovB > /dev/rmt0.1': 255

BR0222E Copying /oracle/CPD/sapdata1/sr3_1/sr3.data1 to/from /dev/rmt0.1 failed due to previous errors

Is there anything related with the expiration period as i had made changes withthat too.

While I continued with it, we get the error

BR0241I Checking label on volume in device /dev/rmt0.1

BR0217E Lock period for volume CPDB01 in device /dev/rmt0.1 not expired

BR0218E Checking label on volume in device /dev/rmt0.1 failed

Kindly suggest what needs to be done?

Regards,

Radeesh V

[former_member204746]

I think you have 2 different problems.

for the expiration, you have 2 possibilities:

1. put the tape in the trash can... then mount a new tape and initialize it

2. re-initialize existing tape

to initialize tape:

brbackup -c -u / -i force

when this is completed, try backup again and provide output if it still fails.

[former_member204746]

I just noticed that I answered the same question from you 2 weeks ago:

https://www.sdn.sap.com/irj/sdn/profile?userid=3625885

please check answers provided earlier and try them and revert with feedback.

[Former Member]

Hi Eric,

While renaming it to CPDB05,The initialization has been successful. But while taking the Backup and Database Copy

we get

BR0241I Checking label on volume in device /dev/rmt0.1

BR0216W Wrong volume CPDB05 found in device /dev/rmt0.1, expected:

CPDB01|CPDB02

BR0218W Checking label on volume in device /dev/rmt0.1 failed

Now,can you please tell me is there any parameter to be chaged in the init<DBSID>profile.,

Kindly advise..

Regards,

Radeesh V

[former_member204746]

brbackup wants CPDB01 and CPDB02

put these tapes in the tape drives.

[Former Member]

But this is the first time the back up is being taken as of now.There is no tapes for CPDB01 and CPDB02 as such.

Can you kindly confirm with that.

If the back up is taken for the first time,please let me know whether the expiration period needs to be changed or so.

When ever the back up is taken as of now it goes on with the default CPDB01 and CPDB02.

[former_member204746]

adapt tape names of file init<DBSID>profile.sap to what you want, it will take the first entry and try to start from there.

[Former Member]

Hi,

In continuation to Eric's message.The following should be able to explain u better

The below is the line from initmp1.sap

1. no default

volume_backup = (MP1B01, MP1B02, MP1B03, MP1B04, MP1B05,

MP1B06, MP1B07, MP1B08, MP1B09, MP1B10,

MP1B11, MP1B12, MP1B13, MP1B14, MP1B15,

MP1B16, MP1B17, MP1B18, MP1B19, MP1B20)

So during the backup it will take the tape with the volumes from 01 to 20.Once full cycle of backup is completed,it will start all over again.