Replication Server 1

[spanton]

My rep server is showing a 100% usage in the stable queues. Should I be consern?

 

[pakya123]

Yes you should be Concerned about it. Check the Network connection to the Standby server.
What probably is happening is that Database is getting stored on the Replication server Stable queue, but not being copied to the Standby Server, hence you Stable Queue is getting filled up.
Check the following things on The Replication Monitor:
Are the Database connections to the Active and Standby Server Up?
Are there any Stopped Replication Server Threads?
Are the Replication services running?

 

[spanton]

I am not see any errors. the replication service is started on the standby server. the database connection is active. Not sure how to answer your question "Are there any Stopped Replication Server Threads?"

 

[spanton]

I only have one patch on the server. Are there any other patches available?

 

[teekow]

Your connection to the servers can be active, but that doesn't mean the transactions are being sent to the standby servers. I would remove the standby configuration and re-run the replication utility which will prompt you to re-initialize the standby server databse. That just means a fresh backup on the active and a fresh restore on the standby, then begin replication. Only do the backup and restore when prompted by the rep server utility. My best guess would be that at some point your standby server was offline for a period of time and the stable queue filled up and stopped accepting more transactions. The only way to start replicating after that is what I described above.

Good luck
Rob

 

[spanton]

Thanks, I was in the process of doing that and it was successful...

 

[spanton]

It started to grow again and both servers has been up and running.