为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:CentOS7.9
【CPU】:x86_64
【问题描述】*:DM8主库启动dmwatcher失败
[dmdba@localhost bin]$ ./dmwatcher /dm8/data/DAMENG/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
The number of remote messages received by local dmwatcher is more than the number of archive destinations configured in dmarch.ini, please check local dmarch.ini configuration!
主库启动dmwatcher报错如上
备库启动正常
[dmdba@localhost bin]$ ./dmwatcher /dm8/data/STANDBY/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
主库dmarch.ini配置如下
[dmdba@localhost ~]$ cat /dm8/data/DAMENG/dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = STANDBY
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
[dmdba@localhost ~]$ cd /dm8/arch/
[dmdba@localhost arch]$
备库dmarch.ini配置如下
[dmdba@localhost ~]$ cat /dm8/data/STANDBY/dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/st/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
[dmdba@localhost ~]$ cd /dm8/st/arch/
主库数据库及实例名
SQL> select name from v$database;
行号 NAME
---------- ------
1 DAMENG
已用时间: 268.084(毫秒). 执行号:200.
SQL> select instance_name from v$instance;
行号 INSTANCE_NAME
---------- -------------
1 DMSERVER
已用时间: 23.535(毫秒). 执行号:201.
备库数据库及实例名
SQL> select name from v$database;
行号 NAME
---------- ------
1 DAMENG
已用时间: 174.601(毫秒). 执行号:101.
SQL> select instance_name from v$instance;
行号 INSTANCE_NAME
---------- -------------
1 STANDBY
已用时间: 27.443(毫秒). 执行号:102.
安装完成数据库之后,我曾手动开启过归档模式,操作记录如下
[dmdba@localhost ~]$ mkdir -p /dm8/arch
SQL> alter database mount;
SQL> alter database archivelog;
SQL> alter database add archivelog 'type=local,dest=/dm8/arch,file_size=64,space_limit=20480';
SQL> alter database open;
不知道是否与这一步有关系,请各位专家帮忙分析。
手动修改下主库归档信息,file_size主备都扩大到256吧。然后按S-S-W-W主备主备顺序重启数据库再启动watcher吧