cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB 7.7.02.17 backup check failes

Former Member
0 Kudos

Hi all,

some times ago I did an upgrade from MaxDB 7.6. to 7.7, I configured a cifs volume as backup location and every was fine. Now I want to check the backup with recover_check but I get the following output:


*** DBA Action starts:
Timestamp: 20080915103154   Function: cda   Object: DATA
*** SAVE/RESTORE request:
RESTORE DATA FROM '/backup/data/DB_FULL' FILE  BLOCKSIZE 8 MEDIANAME 'DB_FULL'
*** 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] WaitingT55 Result=3700
Error in backup task occured, Error code 3700 "hostfile_error"
Backupmedium #1 (/backup/data/DB_FULL) Could not open volume
Backup error occured, Error code 3700 "hostfile_error"

*** 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

*** DBA Action ends:
Timestamp: 20080915103154   State:    Failure

The user sdb can write to the directory and open the backup file (Who are Joerg,Franki,Raymond? Say hello to them for me )

So is there any other directory the user sdb needs to execute this special task?

Many thanks for your help.

Christian

g_awater
Explorer
0 Kudos

Yup, always wondered who those three guys are, glad someone else noticed as well 🙂
Apologies for resuscitating this ancient topic.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member229109
Active Contributor
0 Kudos

Hello Christian,

-> Are you SAP customer?

-> Please update with additional information. Post the output of the following commands:

ls -l /backup/data/DB_FULL

ls -l /backup

uname -a

-> Please check that the user in the group sdba have the access < could open > the

file /backup/data/DB_FULL.

Thank you & best regards, Natalia Khlopina

Former Member
0 Kudos

Hello Natalia,

um, yes, I am SAP customer ...

Here the output for your requests:


ls -l /backup/data/DB_FULL
-rwxrw-rw- 1 root 10004 24434966528 Sep 14 21:05 /backup/data/DB_FULL

ls -l /backup/data
drwxrwxrwx 3 root 10004          0 Sep 15 10:19 data

uname -a
Linux lxdeteg0032 2.6.16.60-0.23-smp #1 SMP Thu May 15 06:38:31 UTC 2008 x86_64 x86_64 x86_64 GNU/Linux

The users sqd<sid> and <sid>adm are in group sdba, both can write to the directory. A "more" to the DB_FULL file gives me a


RTE HEADER Joerg,Franki,Raymond_________________________________________________
________________________________________________________________________________
___

So for me everything should be fine.... but ist does not work ....

Thank you for your help.

Best regards

Christian

Former Member
0 Kudos

Hi all,

maybe somebody is interested, I got a solution.

After strace(ing) the process and finding any problem, I tried to unmount the backup directory, because sometimes there are errors because of the network between the server and the storage.

But: Unmounting the device did not work, there was still something active, even after logging of all my sessions and reconnecting...

A

 ps -ef | grep backup 

did not show any open connections ... but:

a

 lsof | grep backup 

showed an open process connected to process no. 1 which seems to be a relict from a sql script I used to backup the database.


db_admin
db_connect
backup_start DB_FULL
exit

Stopping the database (upgrading to 7.7.04.21 because the DB was just offline) restarting the database and testing the backup did the trick.

So keep in mind, if there are "running" backup processes you cannot check a database backup, you will get a "Could not open volume" error.

This is not the expected error message, but one that seems to be ok, if you know that there is an unfinished backup.

CU

Christian