db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Katherine Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Rollforward recovery problem
Date Thu, 06 Sep 2012 20:46:25 GMT
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?

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


Mime
View raw message