Skip to Content
0

Unable bring up the coordinator node in multiplex.

Apr 13, 2017 at 02:44 PM

84

avatar image
Former Member

Hi All,

Kindly help us,

We have a Multiplex environment (1- Coordinator node and 5-writer nodes)

Today our Coordinator node is down, Due to the dbname.log was missing.we don't know how it happend. When coordinator node down SCC is down in both coordinator and failover nodes. Failover node is not take role as coordinator. and we are unable to OFF the ENABLE_AUTOMATIC_FAILOVER option from any of the writer nodes.

And we tried below on failover node. but no use it though error.

start_iq @/IQ_CATALOG/DB/params.cfg /IQ_CATALOG/DB/dbname.db -iqmpx_failover 1

Now our environment(now 5-writer nodes) runs in read only mode.

Kindly suggest how to bring up coordinator node and write enabled. restore from clean backup is not possible, because almost one week data we lost if we restore it from clean backup.

Regards,

Krishnam Raju

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
Apr 14, 2017 at 03:54 AM
0

Hi,

A dbmane.log is missing means there are no transaction log file?

[Starting a Server in Forced Recovery Mode]
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01759.1604/doc/html/san1288043114158.html

I recommend to open a incident for detail help from engineer.

Best Regards,
Gi-Sung Jang

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks for the reply Gi-sung,

We have already raised an incident with SAP, They are saying ENABLE_AUTOMATIC_FAILOVER option should be off before manually up the failover node as coodinator. But we are unable to OFF the ENABLE_AUTOMATIC_FAILOVER option from any of the writer nodes. So SAP suggestion is restore it from last clean backup.

I have one small question can we able to take incremental backup from these writer nodes..?. because if we are going for restore we lost one week data.

Regards,

Krishnam Raju

0
Former Member
Former Member

Hi,

Here is a link for incremental backup.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01759.1604/doc/html/wil1369833287354.html

In a multiplex environment, execute allBACKUPDATABASE and RESTORE DATABASE commands on thecoordinator.

Best Regards,
Gi-Sung Jang

0