error while taking online SAP MaxDB database backup through Data Protector

[Former Member]

Hi,

I am getting error while taking online SAP MaxDB database backup through Data Protector 5.5 as below,

[Critical] From: OB2BAR_SAPDBBAR@sapmaxdb "MAX" Time: 06/04/10 03:43:56

Error: SAPDB responded with:

-24988,ERR_SQL: SQL error

-903,Host file I/O error

3,Data backup failed

1,Backupmedium #1 (/var/opt/omni/tmp/MAX.BACKDP-Data[1].1) Wrong file type

6,Backup error occured, Error code 3700 "hostfile_error"

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT171 Result=3700

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

I also tried to see the content of the file (/var/opt/omni/tmp/MAX.BACKDP-Data[1].1) is as below,

sapmaxdb:[/var/opt/omni/tmp]# cat MAX.BACKDP-Data[1].1

RTE HEADER Joerg,Franki,Raymond________________________________________________

__________________________________________________________________

____________

Please let me know how to resolve this error.

Thanks & Regards,

Arun

[lbreddemann]

> 1,Backupmedium #1 (/var/opt/omni/tmp/MAX.BACKDP-Data[1].1) Wrong file type

external backup media are fed through PIPES! not through regular files.

> I also tried to see the content of the file (/var/opt/omni/tmp/MAX.BACKDP-Data[1].1) is as below,

> sapmaxdb:[/var/opt/omni/tmp]# cat MAX.BACKDP-Data[1].1

> RTE HEADER Joerg,Franki,Raymond_

As you can view the file in the file system it's obvious that this is a regular file and not a pipe.

Change the medium definition for the backup medium to pipe.

regards,

Lars

[Former Member]

I have changed the medium definition for the backup medium to pipe. But still i am getting the error as below,

Normal] From: BSM@ttcsap10 "MAX_Online" Time: 6/7/10 0:29:52 AM

OB2BAR application on "ttcmaxdr" successfully started.

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:53

Executing the dbmcli command: `user_logon'.

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:53

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

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:53

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

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:53

Executing the dbmcli command: `dbm_configset -raw set_variable_3 OB2BARHOSTNAME=ttcmaxdr'.

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:53

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

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:54

Executing the dbmcli command: `dbm_configset -raw BSI_ENV /var/opt/omni/tmp/MAX.bsi_env'.

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:54

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

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:54

Executing the dbmcli command: `util_connect'.

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:54

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

[Critical] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:30:47

Error: SAPDB responded with:

-24988,ERR_SQL: SQL error

-903,Host file I/O error

3,Data backup failed

1,Backupmedium #1 (/var/opt/omni/tmp/MAX.BACKDP-Data[1].1) Wrong file type

6,Backup error occured, Error code 3700 "hostfile_error"

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT125 Result=3700

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

.

[Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:30:47

Executing the dbmcli command: `exit'.

[Normal] From: BSM@ttcsap10 "MAX_Online" Time: 6/7/10 0:30:49 AM

OB2BAR application on "ttcmaxdr" disconnected.

[Critical] From: BSM@ttcsap10 "MAX_Online" Time: 6/7/10 0:30:49 AM

None of the Disk Agents completed successfully.

Session has failed.

[Normal] From: BSM@ttcsap10 "MAX_Online" Time: 6/7/10 0:30:49 AM

Backup Statistics:

Session Queuing Time (hours) 0.00

-

---

Completed Disk Agents ........ 0

Failed Disk Agents ........... 0

Aborted Disk Agents .......... 0

-

---

Disk Agents Total ........... 0

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

Completed Media Agents ....... 0

Failed Media Agents .......... 0

Aborted Media Agents ......... 0

-

---

Media Agents Total .......... 0

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

Mbytes Total ................. 0 MB

Used Media Total ............. 0

Disk Agent Errors Total ...... 0

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

Session failed!

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

Thanks & Regards,

Arun

[lbreddemann]

would you mind to provide the complete medium definition?

medium_get               <name>

regards,

Lars

[markus_doehr2]

> [Normal] From: OB2BAR_SAPDBBAR@ttcmaxdr "MAX" Time: 06/07/10 00:29:54

> Executing the dbmcli command: `medium_put BACKDP-Data[1]/1 /var/opt/omni/tmp/MAX.BACKDP-Data[1].1 PIPE DATA 0 8'.

Delete that file and try again.

Markus

[Former Member]

Hi,

Please find the output as below,

BACKDP-Data[1]\1 /var/opt/omni/tmp/MAX.BACKDP-Data[1].1 PIPE DATA 0 8 NO NO 20100603032738 20100610225740 NONE

[Former Member]

Hi Markus,

I have deleted the file and tried again, But same problem.

While taking backup through data protector the medium definition is created automatically. I tried creating the medium definiton through command line CLI. But still same problem?

Thanks,

Subba