MAXDB recovery

[Former Member]

Hi All,

Our SAP DMS Dev server SDB DISKD001 file deleted by mistake .(Please Don't ask how)But have a copy of that file. We copy it original location and set file permission .DB_start command give this error .

Error! Connection failed to node (local) for database SDB:

-24950,ERR_USRFAIL: User authorization failed

bobjdms2:sqdsdb 3> dbmcli -d SDB -u control,control

Error! Connection failed to node (local) for database SDB:

-24950,ERR_USRFAIL: User authorization failed

This is a AIX server .

Please help to recover this .. We are very new to MAX DB...

[Former Member · Accepted solution]

Hi Prabhat,

Check for the Control user password.

And the file which you have restored the single DISK001 wont work you need to then restore whole bunch of files from backup in order to get the Consistent DB state.

Regards,

Ram

[Former Member · Accepted solution]

Thanks for the reply...

Managed to online the db using control user , now need some advice to proceed as superuser still cant access the db..

[Former Member · Accepted solution]

what error you are getting while accessing the DB using superuser?

[Former Member · Accepted solution]

Hi Sunil,

When I try to loging as superuser

dbmcli -d SDB -u superuser,******

Error! Connection failed to node (local) for database SDB:

-24950,ERR_USRFAIL: User authorization failed

[Former Member · Accepted solution]

the password you are using to connect to DB is wrong.

There is a KBA on how to change the password follow 1761308 - Unkown password for DBM or SYSDBA user

[Former Member · Accepted solution]

It's ok thanks, db is is online now

finally found the issue  user is :superdba not superuser

thanks lot for the time..

is there  a command to list all the backup templates and their configuration details ..

[Former Member · Accepted solution]

I would suggest to install DBM GUI which will be easy for you to manage the database including backup/restore.

There are lots of docs available on max db under SAP MaxDB - MaxDB - SCN Wiki