Recovering MaxDB instance after file corruption

[Former Member]

Hello,

How can I recover MaxDB database from backup when one of datafiles was corrupted? I could drop this broken database, create new one and recover it. But is there any way to recover db without dropping it?

And one more thing I would like to understand.

AFAIK database instance consists of two major "parts". datafiles/logfiles and small set of files placed in sapdb/wrk directory (in case of standard SAP installation). What kind of information are kept in these files? What about definition of database users and DBM operators?

If I drop SAP database, create new one with the same name and users/DBM operators and recover data form backup, will this database be the same as "original" one? What are possible differences between these two databases?

Thank you for any help with solving my problems.

regards,

Konrad

[markus_doehr2 · Accepted solution]

What you can do is:

- bring the database is admin mode

- recover

No need to "drop".

--

Markus

[Former Member · Accepted solution]

Hi Markus,

Thanks for answer.

The problem is I cannot bring database in admin mode. I cannot even start problem service (server is Windows based):

Here's my knldiag:

2007-11-08 15:11:59                               --- Starting GMT 2007-11-08 15:11:59           7.5.0    Build 032-123-111-699
2007-11-08 15:12:12      0xB60 ERR 18159 VOLUMEIO Could not open volume 'd:sapdbTH4dataDISKD0001', rc = 2
2007-11-08 15:12:12      0xA24 ERR 20014 IOMan    Attach error on data volume 1: could not open volume
2007-11-08 15:12:12      0xA24 ERR 20017 Admin    RestartFilesystem failed with 'I/O error'
2007-11-08 15:12:12      0xA24 ERR 20010 Admin    ERROR 'disk_not_accessibl' CAUSED EMERGENCY SHUTDOWN
2007-11-08 15:12:13                               ___ Stopping GMT 2007-11-08 15:12:13           7.5.0    Build 032-123-111-699

[markus_doehr2 · Accepted solution]

The system can't access the file, is it there? The error is even before the database is trying to start, the database just tries to open the file, which doesn't succeed (for whatever reason).

--

Markus

[Former Member · Accepted solution]

Hi Markus,

Currently this file does not exist. My problem is, that this file was damages due to hardware failure. After system reboot its size was zero.

[markus_doehr2 · Accepted solution]

then you need to "initialize" the instance.

In DBMGUI - Instance --> Initialize

--

Markus

[Former Member · Accepted solution]

Hello,

> then you need to "initialize" the instance.

Thanks! This one solves my problem.

Everything is very easy when you know where to click