SyBASE Replication Agent System Database (RASD) got corrupted

Every now and again problems crop up leaving us with few possibilities to figure it out, this can happen also at work, where you have to come up with a solution immediately.

Let me explain how, shall we ?

Due to system hung we had to reboot a production database server, which was made up of an Oracle Database and what’s more a Sybase Replication Agent (RAO) which replicates  Oracle data rows through a Real-Time loading Server to a Sybase IQ database.

The Oracle database started up without any problems instead when I was trying to start the RAO Agent which is made up of a java process and also Replication Agent System Database (RASD)  process I got the following error :

 E. 09/11 20:58:17. *** ERROR *** Assertion failed: 201129 (11.0.1.2044)
File is shorter than expected

The Replication Agent system Database  got corrupted !!

This was a fairly serious issue !!

It was necessary to contact the Sybase support  and following you’ll find the procedure to figure out the corruption and restart the RAO agent :
export  LD_LIBRARY_PATH=/directorty/RAX-XX/RAO/lib

cd $RAO_HOME/repository

Make sure the RAO.log is not there

Make sure the RAO.db file is there.

Execute the following command : dbeng12 –f RAO.db
NB : this command tells the database to come up wihout a log file. 

Execute the following command :dblog –t RAO.log  RAO.db
NB: this command tells the database to assign a new log file to the database.


Restart the RAO using normal procedures.
 

The procedure ended up bringing the RAO again online and what’s more in ready to replicate data.

See you in my next blog.

Byeeeee