db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag Wanvik <dag.wan...@oracle.com>
Subject Re: Rollforward recovery problem
Date Fri, 07 Sep 2012 14:10:37 GMT


On 06.09.2012 16:46, Katherine Marsden wrote:
> On 9/6/2012 11:25 AM, Dag Wanvik wrote:
>> Hi istanbullu,
>>
>> Derby is not designed to recover from deleting the database files 
>> under seg0.
>> If these files get deleted/damaged you need a full backup as produced 
>> from
>> calling SYSCS_UTIL.SYSCS_BACKUP_DATABASE and then restoring it up to 
>> the last transaction committed in the log files.
>> Trying to recover from the log files alone is not guaranteed to work.
>>
>> Cf.
>> http://db.apache.org/derby/docs/10.9/ref/rrefbackupdbproc.html (backup)
>> http://db.apache.org/derby/docs/10.9/ref/rrefrestorefrom.html (restore)
>> http://db.apache.org/derby/docs/10.9/adminguide/cadminrollforward.html (roll 
>> forward recover)
>>
> Dag, I responded before seeing your post. Shouldn't the roll forward 
> recovery automatically first restore the backup created with 
> SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE?
>
Yes I believe that's true. I'm not sure whether one needs to removed the 
old image first, but it sounds prudent to me.

Dag


> http://db.apache.org/derby/docs/10.9/adminguide/cadminrollforward.html
>

Mime
View raw message