maxdb backup error (-903)

[Former Member]

Hi,

I try to backup the database SAPDB on a Linux Suse Enterprise 9, but an error appear:

-24988,ERR_SQL: sql error

-903,Host file I/O error,Could not open volume

can anyone help me?

thanks in advance,

David

[former_member194755 · Accepted solution]

Hi David

I get same error message:
Backup failed - ERR -24920 (-903, Host file I/O error,access denied [5]).

I'm trying to change the back up directory which is currently P: to some external virutal shared directory.
In Database Manager -> Back up medium I created new medium for testing. This medium is for TEST_LOG for log back up and assigned shared directly path of other system.

When I run the script for backup log on contentserver I get error message -903.

If I change medium file path to system's own local directory like M:\Backup etc it does work but not \\HVTL0337\sap_temp\SDB_LOG.BAK

Can I not store the backup in expternal system director?
We are using SAPDB 7.3.00.35 version.

Thanks
Bharati Shinde

[roland_mallmann]

Hi David,

please take a look into the 'knldiag' file in your SAPDB's rundirectory (/sapdb/data/wrk/<SID>). YOu should find more information about what's wrong with the relevant volume.

Which SAPDB Version are you using?

What is the current status of your db instance? (dbmcli -d <SID> -u <dbm-user>,<password> db_state)

Kind regards,

Roland

[Former Member]

I'm also getting the same error but when I try to do a restore.

when using dbm gui:-903 Message not available,could not open volume.

when i check the log files knl.diag i get this error:

err 11000 read error (fd=39):Invalid argument

err 52012 restore basis_err 3700

plz anyone help

[former_member229109]

Hello Frank,

You got database error '-903: Hostfile I/O error '.

An error could occur while operating a command file or host file or a backup device.

I recommend you to post your own question next time, as the problem could be different to the DAVID JIMENEZ's problem.

But at the beginning the analysis will be the same:

-> What is the version of the database?

Run the following commands:

sdbregview -l

dbmcli -s db_enum

xinstinfo <SID>

-> What is the current status of your db instance?

dbmcli -d <SID> -u <dbm-user>,<password> db_state

-> What medium did you use to run the restore?

Check the dbm.prt -> search for 'recover_start' command prior the

last reported 'ERR -24988 DBM -903,Message not available,I/O error'

=> you will see the medium name.

-> Check the medium. ( See in dbm.mmm file, use DBMGUI ... Or run

dbmcli -d <SID> -u <dbm-user>,<password> medium_get <name> )

-> Check the error information in the knldiag file around the time

when the recover started => analyze the error information.

< The dbm* & knldiag* files located in the database Rundirectory. >

For example, if you will see the errors:

ERR 11000 d0_aopen Cannot open device, Permission denied

ERR 11000 d0_aopen Device name '...'

=> then you have permissions problems, which need to be checked & corrected.

• Please run the steps & update with your results.

Thank you & best regards, Natalia Khlopina