RME 4.05 Database Corrupt. Recreate?

Answered Question

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


Correct Answer by Joe Clarke about 9 years 9 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Joe Clarke Thu, 06/07/2007 - 06:18
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

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.

Actions

This Discussion