backup through PIPE fails

[Former Member]

I am following backint for oracle backup for sapdb database and I have the following error while performing the backup of content server database on maxdb 7.6

===============================================================

dbmcli on SPB>param_directget MAXBACKUPDEVS

OK

MAXBACKUPDEVS 5

---

dbmcli on SPB>medium_getall

OK

BackupRestore /sapdb/SPB/backup/cs_data FILE DATA 0 8 NO NO 20080225142445 20080225142445 NONE

LOGBACKUP /sapdb/SPB/saplog/onlinelog FILE LOG 0 8 NO NO 20080225145749 20080225145749 NONE

BACKORA /sapdb/SPB/backup/medium PIPE DATA 0 8 NO NO 20080309214712 20080309214712 NONE

---

dbmcli on SPB>util_connect

OK

---

dbmcli on SPB>backup_start BACKORA

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

3,Data backup failed

1,Backupmedium #1 (/sapdb/SPB/backup/medium) 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) [executing] WaitingT347 Result=3700

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

---

dbmcli on SPB>!ls -ld /sapdb/SPB/backup/medium

-rw-rw---- 1 sdb sdba 65536 Mar 10 00:27 /sapdb/SPB/backup/medium

'ls -ld /sapdb/SPB/backup/medium' returned with 0

---

===============================================================

knldiag:

======

2008-03-10 00:27:31 29 ERR 52012 SAVE error occured, basis_err 3700

2008-03-10 00:27:31 29 ERR 3 Backup Data backup failed

2008-03-10 00:27:31 29 ERR 1 Backup + Backupmedium #1 (/sapdb/SPB/backup/medium) Wrong file type

2008-03-10 00:27:31 29 ERR 6 KernelCo + Backup error occured, Errorcode 3700 "hostfile_error"

2008-03-10 00:27:31 29 ERR 17 SrvTasks + Servertask Info: because Error in backup task occured

2008-03-10 00:27:31 29 ERR 10 SrvTasks + Job 1 (Backup / Restore Medium Task) [executing] WaitingT347

Result=3700

2008-03-10 00:27:31 29 ERR 6 KernelCo + Error in backup task occured, Errorcode 3700 "hostfile_error"

2008-03-10 00:27:33 12 11561 COMMUNIC Connecting T351 de08u1641 4649002

2008-03-10 00:27:33 30 12929 TASKING Task T351 started

2008-03-10 00:27:33 30 11007 COMMUNIC wait for connection T351

2008-03-10 00:27:33 30 11561 COMMUNIC Connected T351 de08u1641 4649002

2008-03-10 00:27:33 12 11561 COMMUNIC Connecting T348 de08u1641 4624628

2008-03-10 00:27:33 29 12929 TASKING Task T348 started

2008-03-10 00:27:33 29 11007 COMMUNIC wait for connection T348

2008-03-10 00:27:33 29 11561 COMMUNIC Connected T348 de08u1641 4624628

-

---

current write position -

---

Can some body suggest on this?

[lbreddemann]

Hi Anantha,

looks like you've not chosen a pipe-device for the backup medium:

BACKORA /sapdb/SPB/backup/medium PIPE DATA 0 8 NO NO 20080309214712 20080309214712 NONE

/sapdb/SPB/backup/medium does not seem to be a pipe.

Make sure you're the external backup tool "on the other side of the pipe" has created the pipe by exactly this name.

KR Lars

[Former Member]

Yes it is created as PIPE (as kept in subject).

Also if I delete medium file, it just created to that size and doesn't backup to netbackup. Do you have any suggestion...

Regards,

Giridhara

[Former Member]

This is the whole situation and I found the problem with file not getting created as pipe. Just a wrap up again.

We are using Maxdb 7.6.00.35 and I created backup medium as pipe and did a backup for netbackup through backint interface.

dbmcli on SPB>medium_put BACKORA /sapdb/SPB/backup/medium PIPE DATA 0 8 NO NO

OK

---

When I run the backup, it creates the file "/sapdb/SPB/backup/medium" as normal file (and not as pipe).

-rw-rw---- 1 sdb sdba 65536 Mar 13 00:24 /sapdb/SPB/backup/medium

When I trigger backup, I get this error message:

==================================================

dbmcli on SPB>UTIL_CONNECT

OK

---

dbmcli on SPB>backup_start BACKORA DATA

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

3,Data backup failed

1,Backupmedium #1 (/sapdb/SPB/backup/medium) 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) [executing] WaitingT351 Result=3700

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

---

dbmcli on SPB>util_release

OK

---

==================================================

Also I notice that the file

(/sapdb/SPB/backup/medium) is created with size 65536 and fails evertime at this size.

==================================================

DBM.PRT

==================================================

2008-03-13 01:47:21 0x0042f12c INF 283 DBMSrv command backup_start BACKORA DATA

2008-03-13 01:47:21 0x0042f12c ERR -24991 DBMSrv ERR_NODBSESSION: no database session available

2008-03-13 01:47:33 0x0042f12c INF 283 DBMSrv command backup_start BACKORA DATA

2008-03-13 01:47:49 0x0042f12c ERR -24988 DBMSrv ERR_SQL: SQL error

0x0042f12c ERR -24778 DBMSrv -903,Host file I/O error

0x0042f12c ERR -24778 DBMSrv 3,Data backup failed

0x0042f12c ERR -24778 DBMSrv 1,Backupmedium #1 (/sapdb/SPB/backup/medium) Wrong file type

0x0042f12c ERR -24778 DBMSrv 6,Backup error occured, Errorcode 3700 "hostfile_error"

0x0042f12c ERR -24778 DBMSrv 17,Servertask Info: because Error in backup task occured

0x0042f12c ERR -24778 DBMSrv 10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT351 Result=3700

0x0042f12c ERR -24778 DBMSrv 6,Error in backup task occured, Errorcode 3700 "hostfile_error"

==================================================

The following is the error from dbm.utl for this session:

==================================================

dbm.utl

==================================================

2008-03-13 01:47:33 47D8EA250005 0000 SDB SAVE DATA QUICK TO '/sapdb/SPB/backup/medium' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'BACKORA'

2008-03-13 01:47:49 47D8EA250005 0000 SDB SAVE DATA QUICK TO '/sapdb/SPB/backup/medium' PIPE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME: RETURNCODE - 903

2008-03-13 01:48:18 0000 SDB SAVE DATA CANCEL

2008-03-13 01:48:18 0000 SDB SAVE DATA CANCEL: RETURNCODE -104

==================================================

I have done this on another system (live cache 7.5.00.39) and this file is getting created as pipe when the backup is running.

prw-rw---- 1 sdb sdba 32768 Mar 13 00:44 /sapdb/TLP/backup/medium

I think there is some problem in maxdb 7.6.00.35 that is creating this medium as file instead of pipe. Can you suggest?

Regards,

Giridhara Tadikonda

[Former Member]

I got the problem resolved after going through dbmgui. The syntax seems to have changed for creating backup medium in maxdb 7.6.

[former_member229109]

Hello,

1) for MaxDB Versions 7.5 and below you use the reserved character strings

at the start of a media name to establish which backup tools from other suppliers are used for backups/recoveries. :

To integrate the various backup tools, naming conventions for the media definition must be adhered to depending on the backup tool.

The backup media must start with the relevant key word:

- TSM -> TSM (IBM/Tivoli)

- NSR -> NetWorker (Legato)

- BACK -> Netbackup (VERITAS)

- BACK -> all backup tools that support Backint for MaxDB or BACKINT

for ORACLE.

2) Yes, as of 7.6 version the medium definition is changed.

You could run dbm command 'explain medium_put ' & review the results

Syntax of the medium_put command:

medium_put <name> <location> <type> <backup_type> <size> <block_size>

<overwrite> <autoloader> <os_command> <tool_type>

…

<tool_type>

The backup tool that should be used. If another value as NONE is

specified, use PIPE only as the <type> and 0 as <size>. Whenever such a

medium is used, the pipe must not already exist. Possible values for

<tool_type> are:

NONE No external backup tool is used with the backup medium.

BACK The Backint for MaxDB interface of an external backup tool is

used with the backup medium.

NSR Legato's NetWorker is used with the backup medium.

TSM IBM's adint2 client for Tivoli Storage Manager is used with

the backup medium.

3)

In your case ::

"dbmcli on SPB>medium_getall

OK

BackupRestore /sapdb/SPB/backup/cs_data FILE DATA 0 8 NO NO 20080225142445 20080225142445 NONE

LOGBACKUP /sapdb/SPB/saplog/onlinelog FILE LOG 0 8 NO NO 20080225145749 20080225145749 NONE

BACKORA /sapdb/SPB/backup/medium PIPE DATA 0 8 NO NO 20080309214712 20080309214712 NONE

"

As you are running the 7.6 database you need to set the tool_type to BACK to be able to use the external backup tool

with the backup medium BACKORA.

Thank you and best regards, Natalia Khlopina