cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Check complete data backup Error code 3700 "hostfile_error"

Former Member

on ‎08-17-2012 2:49 PM

0 Kudos

Hello

SAP Solution Manager 7.1

OS: Linux x86_64

DB: Maxdb : 7.8.02.26

My system return the following error message during data backup check

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

Thanks for your support

Eric

---------------------------------------------------------------------------------------------------------------------------------------------------------

Check complete data backup (Aug 17, 2012 6:00:35 AM)

*** DBA Action starts:

Timestamp: 20120817060035 Function: cda Object: DATA

*** SAVE/RESTORE request:

RESTORE DATA FROM '/mnt/backup/SMP_COM' FILE BLOCKSIZE 8 MEDIANAME 'COM'

*** SAVE/RESTORE request accepted:

OK

*** SAVE/RESTORE result:

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

6,Data recovery failed

115,Cannot close medium /mnt/backup/SMP_COM with number 3, I/O job state failed

Servertask Info: because Error in backup task occured

Job 1 (Backup / Restore Medium Task) [executing] WaitingT15 Result=3700

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

Backupmedium #1 (/mnt/backup/SMP_COM) ;

Backup error occured, Error code 3700 "hostfile_error"

89,close of medium /mnt/backup/SMP_COM failed:5

*** SAVE/RESTORE request:

RESTORE DATA CANCEL

*** SAVE/RESTORE request accepted:

OK

*** SAVE/RESTORE result:

ERR

-24988,ERR_SQL: SQL error

-104,DBM command impossible at this time

6,Data recovery failed

115,Cannot close medium /mnt/backup/SMP_COM with number 3, I/O job state failed

Servertask Info: because Error in backup task occured

Job 1 (Backup / Restore Medium Task) [executing] WaitingT15 Result=3700

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

Backupmedium #1 (/mnt/backup/SMP_COM) ;

Backup error occured, Error code 3700 "hostfile_error"

89,close of medium /mnt/backup/SMP_COM failed:5

*** DBA Action ends:

Timestamp: 20120817060038 State: Failure

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎08-20-2012 9:32 AM
0 Kudos

Hello

All backup task has been scheduled via DBACOCKPIT

SAP system Solution manager 7.1 is OK

Database is OK, Complete Data backup successed

Only Check backup failed

Same status via Database Studio ( user CONTROL)

show active

SERVERDB: SMP

ID   UKT UNIX   TASK       APPL Current        Timeout/ Region     Wait

          tid   type        pid state          Priority cnt try    item

medium_getall

AUTOLOG    /mnt/backup/SMP_AUTOLOG    FILE    AUTO    0    8    YES    NO        20120704104803    20120704104803        NONE    0

LOG    /mnt/backup/SMP_LOG    FILE    LOG    0    8    YES    NO        20120720180044    20120720180044        NONE    0

COM    /mnt/backup/SMP_COM    FILE    DATA    0    8    YES    NO        20120816114444    20120816114444        NONE    0

ls -l /mnt/backup/SMP_COM

-rwxrwxrwx 1 root root 27908374528 Aug 17 19:41 /mnt/backup/SMP_COM

Check complete data backup (Aug 18, 2012 6:00:39 AM)

*** DBA Action starts:

Timestamp: 20120820100229   Function: cda   Object: DATA

*** SAVE/RESTORE request:

RESTORE DATA FROM '/mnt/backup/SMP_COM' FILE  BLOCKSIZE 8 MEDIANAME 'COM'

*** SAVE/RESTORE request accepted:

OK

*** SAVE/RESTORE result:

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

6,Data recovery failed

Servertask Info: because Error in backup task occured

Job 1 (Backup / Restore Medium Task) [executing] WaitingT15 Result=3700

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

*** DBA Action ends:

Timestamp: 20120820100650   State:    Failure

dbm.prt

2012-08-20 10:06:45  12130 ERR      3 DBMKnl   Received the result of an                                                                           administrative statement from the database
                     12130 ERR      9 DBMKnl   Statement:  RESTORE DATA                                                                           FROM '/mnt/backup/SMP_COM' FILE  BLOCKSIZE 8 MEDIANAME 'COM'
                     12130 ERR     10 DBMKnl   Returncode: -903
                     12130 ERR      5 DBMKnl   Errortext:  Host file I/O                                                                           error
2012-08-20 10:06:46  12130 ERR -24580 DBMSrv   ERR_COMMAND_FAILED: Comma                                                                          nd 'recover_check' has ended and failed with return code -24988.
                     12130 ERR -24988 DBMSrv   ERR_SQL: SQL error
                     12130 ERR -24778 DBMSrv   -903,Host file I/O error
                     12130 ERR -24778 DBMSrv   6,Data recovery failed
                     12130 ERR -24778 DBMSrv   Servertask Info: because                                                                           Error in backup task occured
                     12130 ERR -24778 DBMSrv   Job 1 (Backup / Restore M                                                                          edium Task) [executing] WaitingT15 Result=3700
                     12130 ERR -24778 DBMSrv   Error in backup task occu                                                                          red, Error code 3700 "hostfile_error"
2012-08-20 10:06:50  12130 INF      2 DBMSrvCo A DBM Server client conne                                                                          ction was released (client process has process ID 760 on computer WIN7PRO64.loca                                                                          ldomain).

 

Regards

Eric

Show replies
Show replies
former_member229109
Active Contributor
‎08-21-2012 2:47 AM
0 Kudos

Hello Eric,

it's not clear why root user is owner of  /mnt/backup/SMP_COM file.

Please run:

chown sdb:sdba  /mnt/backup/SMP_COM

After that run the following commands on the DB server:

dbmcli -d SMP -u control,<control>

<enter>

dbmcli on SMP>service_connect

OK

dbmcli on SMP>recover_check COM DATA

<enter>

dbmcli on SMP>service_release
OK

---
dbmcli on SMP>exit

and update with outputs.

Regards, Natalia khlopina

Former Member
‎08-21-2012 10:17 AM
0 Kudos

Hello Natalia

find below the outputs

[root@sapsmp mnt]# ll /mnt/backup/

total 27274419

-rwxrwxrwx 1 sdb sdba 27908374528 Aug 17 19:41 SMP_COM

sapsmp:smpadm 51> dbmcli -d SMP -u control,****

dbmcli on SMP>service_connect

OK

---

dbmcli on SMP>recover_check COM DATA

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

6,Data recovery failed

Servertask Info: because Error in backup task occured

Job 1 (Backup / Restore Medium Task) [executing] WaitingT14 Result=3700

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

Regards

Eric

former_member229109
Active Contributor
‎08-22-2012 3:38 AM
0 Kudos

Hello,

-> Please post the KnlMsg <converted>.

-> could you post the label of this databackup.

As the ownership of this backup file was wrong, I assumed that this file was copied from another server

or location. Correct?

Regards, Natalia Khlopina

Former Member
‎08-22-2012 9:52 AM
0 Kudos

Hello Natalia

Backup files are stored on another server (nfs file system).

Please find attached the KnlMsg file from Diagnostic Pack.

Thanks a lot for your support

Regards

Eric MOUREY

KnlMsg.txt.zip
former_member229109
Active Contributor
‎08-17-2012 11:03 PM
0 Kudos

Hello,

1.

Please update with the entries in the dbm.prt and KnlMsg < converted> at the time when the issue

occurred.

2.

What was the status of the database? Was the database crashed or offline?

Please post output of the commands:

x_cons <SID> show active

xinstinfo <SID>

Regards, Natalia Khlopina

Show replies
Show replies
yashwanthkumar_kethineed
Employee
Employee
‎08-17-2012 6:54 PM
0 Kudos

Hi Eric,

Please post output of the following commands:

dbmcli -d <db_name> -u control,<pwd> medium_getall

&

ls -l /mnt/backup/SMP_COM

Which user are you using to run the backup check ?

Let me know

Regards,

Yashwanth

Show replies
Show replies
Ask a Question