Unanswered: Please Help: Recover from a corrupted device
Hi, I'm desparately seeking for someone who could point me to some useful information regarding a disaster recovery problem. Any help is appreciated.
We are running ASE 11.9.3 (64 bit) on Sun Solaris 7, approx. 20GB of data, 10 raw devices, 2 GB each.
- one raw device (HD) crashed
- no working backup exists (due to a completely other disaster, unfortunately)
- HD was restored in a laboratory (copied) and mounted successfully again
- master, sybsystemprocs and tempdb are fine
Problem: The user database causes the recovery process to fail on startup, throwing an "infected by 11" exception (see backtrace below).
I started ASE in single-user mode, bypassing the recovery and made a dump of the database. It worked fine. Now at least a complete (but still corrupt) backup exists. Maybe it's a small sign of hope.
Attempts to extract individual tables via bcp failed ("soft" page allocation errors occured, bcp exited). Attempts to run dbcc checkalloc lead to the same exception (below). After studying the Sybase documentation again and again, I have no more ideas.
Question: Is there any way to get the restored raw device running again? Perhaps some kind of "reformat" without total data loss? Partial data loss would be no problem.
Any advice is highly appreciated. Thanks in advance for your help.
This is the error thrown: