|
Home > Archive > ASE Database forum > April 2005 > recovery after the log crashed?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
recovery after the log crashed?
|
|
| Adam Leszczyński 2005-04-18, 8:24 pm |
| I have made some experiments on my ASE:
- create database
- create ramdisk
- create log device on ramdisk and assign it to the database
and the ramdisk crashed
Now the database can't be brought online,
what should I do to at least recover some of the data?
I tried to repair the database but I't won't go online because it uses
log device which doesn't exist. I can't also drop the log device and
recreate it
because the database still exists. Is there a standard recovery path when
the log device is completely damaged?
TIA,
Adam
| |
| Muralidharan 2005-04-19, 3:24 am |
| Please take a look at the thread titled
"errors 12315, 3403 - how to recover, when log devices are
corrupt ?"
in backup+recovery newsgroup.
Using dbcc rebuild_log, we were able to recover DBs.
HTH
> I have made some experiments on my ASE:
> - create database
> - create ramdisk
> - create log device on ramdisk and assign it to the
> database
>
> and the ramdisk crashed
>
> Now the database can't be brought online,
> what should I do to at least recover some of the data?
>
> I tried to repair the database but I't won't go online
> because it uses log device which doesn't exist. I can't
> also drop the log device and recreate it
> because the database still exists. Is there a standard
> recovery path when the log device is completely damaged?
>
> TIA,
>
> Adam
>
>
| |
|
| Adam Leszczyński wrote:
> I have made some experiments on my ASE:
> - create database
> - create ramdisk
> - create log device on ramdisk and assign it to the database
>
> and the ramdisk crashed
>
> Now the database can't be brought online,
> what should I do to at least recover some of the data?
>
> I tried to repair the database but I't won't go online because it uses
> log device which doesn't exist. I can't also drop the log device and
> recreate it
> because the database still exists. Is there a standard recovery path when
> the log device is completely damaged?
>
> TIA,
>
> Adam
Why the heck are you putting your logdevice on ramdisk ? The logdevice is
important during recovery of your database when u start it up. Thus, it
must be in non-volatile storage.
Probably better is to put your temp devices on ramdisk instead.
| |
| Adam Leszczyński 2005-04-25, 3:24 am |
| I was doing some intensive inserts on the database (mixed with some stored
procedures, so bcp was not an option) and I thought it might increase the
speed if the log was placed on a ramdisk. Actually, the crash of the log
and losing some data is not a problem (I can redo the inserts).
Adam
> Why the heck are you putting your logdevice on ramdisk ? The logdevice is
> important during recovery of your database when u start it up. Thus, it
> must be in non-volatile storage.
>
> Probably better is to put your temp devices on ramdisk instead.
>
|
|
|
|
|