cancel
Showing results for 
Search instead for 
Did you mean: 

The database recover has failed - Error code 3700 "hostfile_error"

Former Member
0 Kudos

Hello,

Initially I have tried to recover the MaxDB liveCache database from the backup done in another computer thru a pipe. So it didin't work and I have canceled it and changed the recover medium from PIPE to FILE and later I executed again the recover from a file but it failed with the below error. The liveCache is of 7.6.04.09 on AIX 5.3.0

Below is the console output

>db_offline

OK

---

>db_cold

OK

---

>util_connect

OK

---

>db_activate RECOVER FULL_SHADOW DATA

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

6,Data recovery failed

1,Backupmedium #1 (/sapdb/data/yanbalAP1/SAVE.DAT) Could not open volume

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] WaitingT109 Result=3700

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

The present medium for the recover is below:

FULL_SHADOW /sapdb/data/yanbalAP1/SAVE.DAT FILE DATA 0 8 NO NO 20090305182555 20090306175825 NONE

I look forward on how to get rid of any buffer cache info from the aborted backup/recover from pipe and close it so that I can work the recover with FILE.

Regards,

Rodolfo Neuhaus

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member229109
Active Contributor
0 Kudos

Hello Rodolfo,

According the knldiag file the Owner of your database is 'sdb', Group: 'sdba'.

Please review the documentation at http://maxdb.sap.com/doc/7_6/default.htm

-> Basic Information -> Concepts of the Database System -> Administration

-> Special Operating System Users and Groups (UNIX/Linux)

To solve your problem please change the ownership of the backup file SAVE.DAT to sdb:sdba.

Thank you and best reagards, Natalia Khlopina

former_member229109
Active Contributor
0 Kudos

Hello Rodolfo,

->As SAP customer you have the option to create the OSS ticket on this issue,

we could login to the system to review the problem & discuss the issue in

more details.

-> Please review the notes::

457425 Homogenous liveCache copy using backup/restore

489615 SAP DB or liveCache system copies via remote pipe

For SAP liveCache documentation see the SAP note 767598.

-> Please logon to the target liveCache server & update with the output of the following commands:

ls -l /sapdb/data/yanbalAP1

ls -l /sapdb/data

more /etc/opt/sdb

-> Please post the knldiag file entries concerning this error.

Thank you and best regards, Natalia Khlopina

Former Member
0 Kudos

Hello Natalia:

Thank you for your reply. I have already opened a OSS message: (0000248011 2009).

Regards,

Rodolfo Neuhaus