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
