Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database on disk, Logs in memory, requires LSN reset on app restart?

691752Mar 19 2009 — edited Apr 21 2011
When I configure logs to write to memory and the database to be backed on disk, I get the following error when I safely shutdown the application and restart it.

file unknown has LSN 1/13017, past end of log at 1/28
Commonly caused by moving a database from one database environment
to another without clearing the database LSNs, or by removing all of
the log files from a database environment

This seems logical, as the log files are no longer there as they were lost when user space memory was cleaned up on application shutdown. Is there a way to work around this? Resetting the LSNs on shutdown isn't an option as a 20 GB database can take a couple of hours to complete.

I do not require fatal recovery, I just want the performance of logging to memory while keeping a persistent store for when I reboot the system.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2011
Added on Mar 19 2009
7 comments
2,796 views