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
