on 09-15-2008 9:34 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.