[原创]求助复制服务器不同步问题
<font color="#444444"><font face="宋体"><font size="2">9月1日由于饮用存储过程中存在死循环，</font><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;"><font size="2">临时重启了主机<span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SYBASE</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">，发现数据不同步，而且host库由800M增加到1.5G</span></font></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SYBASE</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">，发现数据不同步，而且host库由800M增加到1.5G</span></font></font><font size="2"><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">，</span></font><div><font size="2"><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">我重新将主机与备份机都重启</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">还是没有同步，</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">GJSC_BK </span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">启动</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">SYBASE</span><span style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: 宋体; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: Simsun; mso-hansi-font-family: Simsun;">时最后提示信息是</span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">:</span></font></div><div><font size="2"><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;">RepAgent(4):the secondare truncation point is not valid.<br/><br/>please make sure that secondary truncation point is valid.,and then restart the repagent ...<br/></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #444444; FONT-FAMILY: Simsun; mso-bidi-font-family: 宋体; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;"><br/>谢谢！</span></font></div> <p>你没有说清除你的环境。</p><p>错误信息说的是你的数据库没有启用复制截断点。</p><p>use DB</p><p>go</p><p>dbcc settrunc('ltm',valid)</p><p>go</p><p>sp_start_rep_agent DB</p><p>go</p><p>试一试，如果不行，估计要重新建立一次连接。</p>
页:
[1]