Solved: RME 4.05 Database Corrupt. Recreate?

rd9689 · ‎06-07-2007

LMS 2.6/RME 4.05 Solaris 8

When trying to attach to RME I get an error message "Cannot getDB connection, Make sure RME DB server is running" check RMEHome.log for details. There is no RMEHome.log file. However, I do see "Cannot open transaction log file -- rmeng.log is an invalid transaction log" in /var/adm/messages

All RME processes stopped Tuesday Afternoon, apparently after I ran the logrot utility (rme.log was in it!) I am assuming that the logrot utility corrupted the rme.log file.

How can I either restore or recreate my RME database?

thanks

Bob

Joe Clarke · ‎06-07-2007

You cannot EVER touch the rmeng.log in NMSROOT/databases/rmeng. This is the binary transaction log for the database. This is recoverable, though. Shutdown dmgtd, and do:

# csh

# setenv LD_LIBRARY_PATH /opt/CSCOpx/objects/db/lib

# rm -f /opt/CSCOpx/databases/rmeng/rmeng.log

# /opt/CSCOpx/objects/db/bin/dbsrv9 -f /opt/CSCOpx/databases/rmeng/rmeng.db

Then restart dmgtd. Make sure you remove this log file from logrot.conf.

View solution in original post

Joe Clarke · ‎06-07-2007