Backup MaxDB 7.6 mit HP Data Protector; Wrong file type

[gkrauss]

Hallo.

Wir versuchen, eine MaxDB-Datenbank (Rel. 7.6) auf SUSE-LINUX unter Verwendung von HP Data Protector zu sichern. Der Versuch, das Backup durchzuführen, schlägt fehl, da auf dem MaxDB-Server anscheinend die Pipe nicht angelegt werden kann. Folgende Meldung wird ausgegeben:

From: BSM-hph3000.thebis.de "Content_sdb_sdba" Time: 26.04.2008 10:19:16

OB2BAR application on "dell2950.thebis.de" successfully started.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `user_logon'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `dbm_configset -raw set_variable_1 OB2OPTS="(null)"'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `dbm_configset -raw set_variable_2 OB2APPNAME=SDB'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `dbm_configset -raw set_variable_3 OB2BARHOSTNAME=dell2950.thebis.de'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `dbm_configset -raw set_variable_4 TimeoutWaitFiles=30'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `dbm_configset -raw BSI_ENV /usr/omni/tmp/SDB.bsi_env'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `medium_put BACKDP-Data[1]/1 /usr/omni/tmp/SDB.BACKDP-Data[1].1 PIPE DATA 0 8'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `util_connect'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:22

Executing the dbmcli command: `backup_start BACKDP-Data[1] DATA'.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:23

Error: SAPDB responded with:

-24988,ERR_SQL: SQL error

-903,Host file I/O error

3,Data backup failed

1,Backupmedium #1 (/usr/omni/tmp/SDB.BACKDP-Data[1].1) Wrong file type

6,Backup error occured, Errorcode 3700 "hostfile_error"

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) WaitingT131 Result=3700

6,Error in backup task occured, Errorcode 3700 "hostfile_error"

.

From: OB2BAR_SAPDBBAR-dell2950.thebis.de "SDB" Time: 04/26/08 10:16:23

Executing the dbmcli command: `exit'.

From: BSM-hph3000.thebis.de "Content_sdb_sdba" Time: 26.04.2008 10:19:18

OB2BAR application on "dell2950.thebis.de" disconnected.

From: BSM-hph3000.thebis.de "Content_sdb_sdba" Time: 26.04.2008 10:19:18

None of the Disk Agents completed successfully.

Session has failed.

Ein Versuch, die Pipe /usr/omni/tmp/SDB.BACKDP-Data[1].1 manuell auf dem MaxDB-Server anzulegen, schlug ebenso fehl. Eine Pipe /usr/omni/tmp/SDB.BACKDP-Data kann angelegt werden.

Frage 1) Hat jemand ein ähnliches Problem und dazu eine Lösung?

Frage 2) Wo ist hinterlegt, welchen Medium-Name der Data Protector beim command "medium_put" verwenden soll?

Danke für Eure Hilfe!

Gruß

Gerhard Krauß

Heidelberg

[markus_doehr2]

Hi Gerhard,

this is an ENGLISH forum!

Has the user sdb (and sqd<SID>) write permission in the directory?

Markus

[gkrauss]

Hi Markus,

sorry for creating the message in German.

Yes, the sdb-user has write-permissions. Creating a medium of type file is working and with this medium we can perform a backup to file.

Thanks.

Gerhard

[markus_doehr2]

I wonder about the strange pipe name (containing [1]) - is there maybe an old pipe existing? We are using that method too to backup some of our instances.

What version of Data Protector are you using? We had some (other) trouble with 6.0, after upgrading to 6.1 (both cell server and client) it was working.

Markus

[gkrauss]

Hi Marcus,

we use the version 5.5.

The pipe name is generated by the Data Protector. When I want to create manually a pipe with this name I got the message "No hit found".

Do you know a possibilty where we can configure (at Data Protector or MaxDB) which medium name should be used for creating the pipe?

Thanks a lot!

Gerhard

[markus_doehr2]

I'm not sure if that is possible with 5.5....

What does HP say to that?

Markus