Unable to start specified database: Log file error

book

Article ID: 100025706

calendar_today

Updated On:

Description

Error Message

# /etc/init.d/vxdbms3 start
BSPAWN ERROR:  -935
Unable to start specified database: Log file error
Symantec DBMS 3.0.84.0 vxdbms_start_server utility
ASA failed. ASA error code: [1].


ASA Error text: {{{Adaptive Server Anywhere Start Server In Background Utility Version 9.0.2.3300
}}}
 

Cause

Corrupted log file.

Resolution

Remove the corrupted logfile.

#rm /vxdbed/dbed_db.log

Start the database without the transaction log.

# /opt/VRTSdbms3/bin32/dbeng9 -f dbed_db.db

Adaptive Server Anywhere Database Engine Version 9.0.2.3300
Copyright (c) 1989-2004 Sybase, Inc.
Portions Copyright (c) 2002-2004, iAnywhere Solutions, Inc.
All rights reserved. All unpublished rights reserved.

(truncated)

Database recovery in progress
   Last checkpoint at Wed Aug 10 2011 13:06
   Checkpoint log...
   Transaction log: dbed_db.log...
   Forcing recovery without transaction log
   Rollback log...
   Checkpointing...


Starting checkpoint of "dbed_db" (dbed_db.db) at Thu Aug 11 2011 20:21
Finished checkpoint of "dbed_db" (dbed_db.db) at Thu Aug 11 2011 20:21
Recovery complete
The database server stopped at Thu Aug 11 2011 20:21

  Start the database using the startup scripts.

#/etc/init.d/vxdbms3 start
#/etc/init.d/vxdbdctrl start

 

 

 

Issue/Introduction

Unable to start vxdbm3 after corruption of the log file.