万字总结，达梦数据库守护集群部署！

1.达梦守护集群安装前准备；
2.达梦守护集群安装；
3.配置主备；
4.注册服务；
5.启动集群；
6.参数优化；
7.主从同步测试；
8.配置服务名；
9.主备手动切换测试；
10.主备自动切换测试；
11.配置定时备份；
12.常用命令。

https://eco.dameng.com/document/dm/zh-cn/ops/DW-installation-cluster.html

https://www.dameng.com/list_103.html

ls -lrth
total 1.5G
-rw-r--r-- 1 root root 1.5G Sep 18 17:54 dm8_20230xxx_x86_kylin10_64_include_symbols.iso
root@EBGCJC-002:/soft#md5sum dm8_20230xxx_x86_kylin10_64_include_symbols.iso
3d48530c44fc68eb6525011a3751e4c9 dm8_20230xxx_x86_kylin10_64_include_symbols.iso

free -h

df -h

dmidecode -t 1

1.磁盘写入数据时会产生较少的资源占用和冲突，有利于提高数据库的性能。
2.可以很容易的监测各类的使用和剩余空间。
5.减少磁盘误删或毁坏造成的损失。
4.不会抢占数据库的磁盘使用空间。

lsblk

vgdisplay

fdisk /dev/sdb
n
p
1
+99G
w

pvcreate /dev/sdb1

vgcreate vg_data /dev/sdb1

lvcreate -L +99G -n lv_dmdata vg_data

mkfs -t xfs /dev/mapper/vg_data-lv_dmdata

mkdir /dm8

vi /etc/fstab
/dev/mapper/vg_data-lv_dmdata /dm8     xfs     defaults     0   0

mount -a

df -h

mkdir -p /dm8/{dbms,ctl,data,redo,bak,arch,soft,check,scripts,core}
mkdir -p /dm8/bak/{dmp,arch,full,incr}

（1）数据库运行依赖该用户。
（2）普通用户不能修改系统关键配置文件，若要查看其他用户的文件则需要相应的权限。
（3）防止使用 root 权限过大导致误操作及一些纠纷。

groupadd -g ***** dinstall

useradd -u ***** -g dinstall -m -d /home/dmdba -s /bin/bash dmdba

passwd dmdba

su - dmdba
vi .bash_profile
export DM_HOME="/dm8/dbms"
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm8/dbms/bin"
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
alias cp='cp -i'
alias mv='mv -i'
alias rm='rm -i'

source /home/dmdba/.bash_profile

(1) LD_LIBRARY_PATH 主要用于指定查找共享库（动态链接库）时除了默认路径之外的其他路径。
(2) PATH 环境变量定义了用于进行命令和程序查找的目录， PATH 中的目录使用冒号分隔。
(3) DM_HOME 定义达梦数据库的软件目录。

chown dmdba.dinstall /dm8 -R

1.试用授权产品，会导致试用授权过期，无法使用；
2.集群自动切换场景，可能会导致集群检测节点服务异常，引发误切换；
3.数据库运行日志、数据库服务日志、归档日志、备份集等时间记录错误，会导致相关分析和排查工作难度增大。

date

systemctl status ntpd

ntpq -p

[root@~]# systemctl status firewalld

[root@~]# systemctl stop firewalld

systemctl list-unit-files|grep firewalld

[root@~]# systemctl disable firewalld

Enforcing：强制模式。代表 SELinux 在运行中，且已经开始限制 domain/type 之间的验证关系；
Permissive：宽容模式。代表 SELinux 在运行中，不会限制 domain/type 之间的验证关系，即使验证不正确，进程仍可以对文件进行操作。如果验证不正确会发出警告。
Disabled：关闭模式。SELinux 并没有实际运行。

[root@localhost ~]# getenforce

[root@localhost ~]# setenforce 0

[root@localhost ~]# setenforce 1

cat /etc/selinux/config

vi /etc/selinux/config

1.CFQ (完全公平排队 I/O 调度程序)；
2.NOOP (电梯式调度程序)；
3.Deadline (截止时间调度程序)；
4.AS (预料 I/O 调度程序)。

lsblk

cat /sys/block/sdb/queue/scheduler

[root@~]# echo deadline > /sys/block/sdb/queue/scheduler

[root@~]# vi /boot/grub/menu.lst

[root@~]# kernel /boot/vmlinuz-2.6.32-504.el6 ro root=LABEL=/ elevator=deadline rhgb quiet

[root@~]# cat /sys/block/vdc/queue/scheduler

free -h

[root@~]# swapoff -a

[root@~]# sed -ri 's/.*swap.*/#&/' /etc/fstab

[root@~]# reboot

[root@~]# free -m

[root@~]# dmesg | grep -i numa

[root@~]# vi /etc/default/grub

[root@~]# grub2-mkconfig -o /etc/grub2.cfg

[root@~]# reboot

[root@~]# dmesg | grep -i numa

[root@~]# cat /proc/cmdline

[root@]# grep -i huge /proc/meminfo
[root@]# cat /sys/kernel/mm/transparent_hugepage/enabled

grep -i huge /proc/meminfo

[root@~]# vim /etc/default/grub

[root@~] # grub2-mkconfig -o /boot/grub2/grub.cfg

[root@~]# grub2-mkconfig -o /boot/efi/EFI/kylin/grub.cfg

if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi

echo never > /sys/kernel/mm/transparent_hugepage/defrag

0：表示内核将检查是否有足够的可用内存供应用进程使用；如果有足够的可用内存，内存申请允许；否则，内存申请失败，并把错误返回给应用进程。
1：表示内核允许分配所有的物理内存，不管当前的内存状态如何。
2：表示内核允许分配超过所有物理内存和交换空间总和的内存。

[root@dm~]# cat /proc/sys/vm/overcommit_memory

[root@dm~]# echo 0 > /proc/sys/vm/overcommit_memory

[root@dm~]# cat /proc/sys/vm/overcommit_memory

[root@cjc~]# vim /etc/sysctl.conf

cat /etc/sysctl.conf|grep -i swap

vi /etc/sysctl.conf
vm.swappiness = 0

cat /etc/sysctl.conf|grep ore_pattern
echo "kernel.core_pattern = /dm8/core/core-%e-%p-%s" >> /etc/sysctl.conf

1.core file size

2.data seg size

3.file size

4.open files

5.virtual memory

6.max user processes

ulimit -a

[dmdba@]# ulimit -n 65535

[dmdba@]# ulimit -u 10240

[dmdba@~]# ulimit -a

cp /etc/security/limits.conf /etc/security/limits.conf_20240524bak
vi /etc/security/limits.conf

dmdba soft nproc 10240
dmdba hard nproc 10240
dmdba soft nofile 65536
dmdba hard nofile 65536
dmdba hard data unlimited
dmdba soft data unlimited
dmdba hard fsize unlimited
dmdba soft fsize unlimited
dmdba soft core unlimited
dmdba hard core unlimited

[root@]# reboot

[dmdba@]# ulimit -a

(1) DefaultLimitNOFILE：用户默认最大打开文件数。
(2) DefaultLimitNPROC：用户默认最大进程数。

vi /etc/systemd/system.conf
##添加配置：
DefaultLimitNOFILE=65536
DefaultLimitNPROC=10240

麒麟 10 中是 nproc.conf；
centos6 中是 90-nproccentos，
centos7 中是 20-nproc.conf。

/etc/security/limits.conf

root@cjc:/root#cd /etc/security/limits.d
root@cjc:/etc/security/1imits.d#1s
nproc.conf
root@cjc:/etc/security/1imits.d#cat nproc.conf
dmdba soft nproc 65536
dmdba hard nproc 65536

[root@dm~]# vi /etc/security/limits.d/nproc.conf
##添加配置：
dmdba soft nproc 65536
dmdba hard nproc 65536
##确定是否生效：
[dmdba@~]# ulimit -u
65536

cat /proc/cpuinfo | grep "processor" | wc -l

cat /proc/cpuinfo | grep "physical id" | sort|uniq | wc -l

cat /proc/cpuinfo |grep "core id"|sort -u|wc -l

systemctl show systemd-logind | grep -i removeipc

systemctl daemon-relCJCd
systemctl restart systemd-logind

[root@~]# vi /etc/pam.d/login
session required  /lib64/security/pam_limits.so
session required  pam_limits.so
[root@~]# vi /etc/pam.d/login
session required  /lib64/security/pam_limits.so
session required  pam_limits.so

[root@~]# scp -r xxx dmdba@ip:/opt/

[root@~]# scp -r -P端口 xxx dmdba@ip:/opt/

ethtool eth1

sar -n DEV 1 100

#IFACE 本地网卡接口的名称
#rxpck/s 每秒钟接受的数据包
#txpck/s 每秒钟发送的数据库
#rxKB/S 每秒钟接受的数据包大小，单位为 KB
#txKB/S 每秒钟发送的数据包大小，单位为 KB
#rxcmp/s 每秒钟接受的压缩数据包
#txcmp/s 每秒钟发送的压缩包
#rxmcst/s 每秒钟接收的多播数据包

https://eco.dameng.com/document/dm/zh-cn/ops/before-installation.html

dd bs=32k count=20k if=/dev/zero of=test oflag=dsync

https://eco.dameng.com/document/dm/zh-cn/ops/before-installation.html

cd /dm8/soft
ls -lrth

ll -rth /mnt
mount -o loop dm8_20230713_x86_kylin10_64_include_symbols.iso /mnt

ll -rth /mnt

cd /mnt
./DMInstall.bin -i

chown dmdba.dinstall /dm8 -R

[root@CJC-app-001 ~]# /dm8/dbms/script/root/root_installer.sh

https://eco.dameng.com/docs/zh-cn/pm/dminit-function-introduction.html

dminit help|grep CHARSET

[dmdba@CJC-app-001 dmdbms]$ dminit help
...
CHARSET/UNICODE_FLAG CHARSET(0), optional value:0[GB18030],1[UTF-8],2[EUC-KR]

##dminit path=/dm8/data CTL_PATH=/dm8/ctl/dm01.ctl LOG_PATH=/dm8/redo/dm_redo01.log LOG_PATH=/dm8/redo/dm_redo02.log LOG_SIZE=1024 CASE_SENSITIVE=N CHARSET=1 DB_NAME=CJC INSTANCE_NAME=CJC01 SYSDBA_PWD=****** SYSAUDITOR_PWD=****** BUFFER=1024 PORT_NUM=35231 AUTO_OVERWRITE=0 EXTENT_SIZE=32 PAGE_SIZE=16 LENGTH_IN_CHAR=1

##dminit path=/dm8/data CTL_PATH=/dm8/ctl/dm01.ctl LOG_PATH=/dm8/redo/dm_redo01.log LOG_PATH=/dm8/redo/dm_redo02.log LOG_SIZE=1024 CASE_SENSITIVE=N CHARSET=1 DB_NAME=CJC INSTANCE_NAME=CJC02 SYSDBA_PWD=****** SYSAUDITOR_PWD=****** BUFFER=1024 PORT_NUM=35231 AUTO_OVERWRITE=0 EXTENT_SIZE=32 PAGE_SIZE=16 LENGTH_IN_CHAR=1

Path: 初始数据库存放路径
CTL_PATH：控制文件路径
LOG_PATH：日志文件路径
CASE_SENSENSITIVE：大小写敏感，可选择值，Y/N 1/0
CHARSET：字符集：0（GB18030）、1（UTF-8）、2（EUC-KR）
DB_NAME：数据库名
INSTANCE_NAME：实例名
SYSDBA_PWD：设置SYSDBA密码
SYSAUDITOR_PWD：设置SYSAUDITOR 密码
BUFFER：系统缓存大小
PORT_NUM：数据库服务器监听端口号

dmserver /dm8/data/CJC/dm.ini  

exit;

cd /dm8/data/CJC
cp dm.ini dm.ini_20230920bak
vi dm.ini

DW_INACTIVE_INTERVAL=60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
MAX_SESSIONS = 5000

cd /dm8/data/CJC

vi dmarch.ini
ARCH_WAIT_APPLY =0
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 10240
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME
ARCH_DEST = CJC02

ARCH_WAIT_APPLY =0
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 1024
ARCH_SPACE_LIMIT = 10240
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME
ARCH_DEST = CJC01

cd /dm8/data/CJC
vi dmmal.ini
MAL_CHECK_INTERVAL = 30
MAL_CONN_FAIL_INTERVAL = 10
MAL_BUF_SIZE = 5000
MAL_VPOOL_SIZE = 6000
[MAL_INST1]
MAL_INST_NAME = CJC01
MAL_HOST = 192.168.1.101
MAL_PORT = 35331
MAL_INST_HOST = 192.168.1.101
MAL_INST_PORT = 35231
MAL_DW_PORT = 35431
MAL_INST_DW_PORT = 35531
[MAL_INST2]
MAL_INST_NAME = CJC02
MAL_HOST = 192.168.1.102
MAL_PORT = 35331
MAL_INST_HOST = 192.168.1.102
MAL_INST_PORT = 35231
MAL_DW_PORT = 35431
MAL_INST_DW_PORT = 35531

cd /dm8/data/CJC
vi dmwatcher.ini
[GRPCJC]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 101102
INST_INI = /dm8/data/CJC/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dbms/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

cd /dm8/data/CJC
vi dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/mal/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 512
MON_LOG_SPACE_LIMIT = 2048
[GRPCJC]
MON_INST_OGUID = 101102
MON_DW_IP = 192.168.1.101:35431
MON_DW_IP = 192.168.1.102:35431

MON_DW_CONFIRM = 0
MON_LOG_PATH = /dm8/mal/log_front
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 512
MON_LOG_SPACE_LIMIT = 2048
[GRPCJC]
MON_INST_OGUID = 101102
MON_DW_IP = 192.168.1.101:35431
MON_DW_IP = 192.168.1.102:35431

root@CJC-001:/dm8/scripts#cat start_dmap.sh
#!/bin/bash
[ $(whoami) != root ] && echo "user not is root , please use an ##root## user" && exit 2
/dm8/dbms/bin/service_template/DmAPService start
root@CJC-001:/dm8/scripts#sh start_dmap.sh

#systemctl stop DmServiceCJC.service

dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/CJC/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/bak/tmp/BACKUP_FILE_01'"

dmdba@EBGCJC-001:/home/dmdba$ls -lrth /dm8/bak/tmp/BACKUP_FILE_01/
total 23M
-rw-r--r-- 1 dmdba dinstall 23M Sep 20 09:58 BACKUP_FILE_01.bak
-rw-r--r-- 1 dmdba dinstall 106K Sep 20 09:58 BACKUP_FILE_01.meta

scp -P 333 -r /dm8/bak/tmp/BACKUP_FILE_01 192.168.1.102:/dm8/bak/tmp/

root@ECJC-001:/dm8/scripts#cat start_dmap.sh
#!/bin/bash
[ $(whoami) != root ] && echo "user not is root , please use an ##root## user" && exit 2
/dm8/dbms/bin/service_template/DmAPService start
root@EBGCJC-001:/dm8/scripts#sh start_dmap.sh

dmrman CTLSTMT="restore database '/dm8/data/CJC/dm.ini' from backupset '/dm8/bak/tmp/BACKUP_FILE_01'"
dmrman CTLSTMT="recover database '/dm8/data/CJC/dm.ini' from backupset '/dm8/bak/tmp/BACKUP_FILE_01'"
dmrman CTLSTMT="recover database '/dm8/data/CJC/dm.ini' update DB_MAGIC "

dmserver /dm8/data/CJC/dm.ini mount

disql SYSDBA/xxxxxx:35231
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(101102);
alter database primary;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

dmserver /dm8/data/CJC/dm.ini mount

disql SYSDBA/xxxxxx:35231

SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(101102);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

cd /dm8/dbms/script/root

./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/CJC/dm.ini -p CJC -m mount

systemctl disable DmServiceCJC.service

cd /dm8/dbms/script/root
./dm_service_installer.sh -t dmwatcher -p WATCHER -watcher_ini /dm8/data/CJC/dmwatcher.ini

systemctl list-unit-files |grep -i dmw
systemctl disable DmWatcherServiceWATCHER.service

cd /dm8/dbms/script/root
./dm_service_installer.sh -t dmmonitor -p MONITOR -monitor_ini /dm8/data/CJC/dmmonitor.ini

systemctl disable DmMonitorServiceMONITOR.service

cd /dm8/dbms/script/root
#./dm_service_uninstaller.sh -n 服务名称

shutdown immediate;

shutdown immediate;

ps -ef|grep -i dms|grep -v grep

systemctl start DmWatcherServiceWATCHER.service

ps -ef|grep -i dms|grep -v grep
ps -ef|grep -i dmw|grep -v grep

systemctl start DmWatcherServiceWATCHER.service

ps -ef|grep -i dms|grep -v grep
ps -ef|grep -i dmw|grep -v grep

systemctl start DmMonitorServiceMONITOR.service

ps -ef|grep -i dmm|grep -v grep

cp /dm8/data/CJC/dm.ini /dm8/bak/conf/dm.ini_20231030

disql SYSDBA/******：35231
start /dm8/scripts/Adj_******.sql

MEMORY_POOL：由500改成1000
MEMORY_TARGET：默认1000，不用修改
BUFFER：服务器总内存小于等于16GB，设置为1/3，服务器大于100GB，设置为20GB
MAX_SESSIONS：5000
MAX_OS_MEMORY：60

set pagesize 200
select para_name,para_value,file_value from V$DM_INI where PARA_NAME in ('WORKER_THREADS','TASK_THREADS','IO_THR_GROUPS',
'MAX_OS_MEMORY','MEMORY_POOL','MEMORY_N_POOLS','MEMORY_TARGET','BUFFER','BUFFER_POOLS','RECYCLE','RECYCLE_POOLS',
'FAST_POOL_PAGES','FAST_ROLL_PAGES','MEMORY_MAGIC_CHECK','ENABLE_FREQROOTS','HJ_BUF_GLOBAL_SIZE','HJ_BUF_SIZE',
'HAGR_BUF_GLOBAL_SIZE','HAGR_BUF_SIZE','SORT_FLAG','SORT_BLK_SIZE','SORT_BUF_SIZE','SORT_BUF_GLOBAL_SIZE','RLOG_POOL_SIZE',
'CACHE_POOL_SIZE','DICT_BUF_SIZE','VM_POOL_TARGET','SESS_POOL_TARGET','USE_PLN_POOL','ENABLE_MONITOR','SVR_LOG','TEMP_SIZE',
'TEMP_SPACE_LIMIT','MAX_SESSIONS','MAX_SESSION_STATEMENT','PK_WITH_CLUSTER','ENABLE_ENCRYPT','OLAP_FLAG','VIEW_PULLUP_FLAG',
'OPTIMIZER_MODE','ADAPTIVE_NPLN_FLAG','PARALLEL_PURGE_FLAG','PARALLEL_POLICY','UNDO_EXTENT_NUM','ENABLE_INJECT_HINT','DIRECT_IO',
'COMPATIBLE_MODE','ALTER_MODE_STATUS','ENABLE_OFFLINE_TS');

rpm -qa|grep glibc

cd /dm8/dbms/bin
cat /dm8/dbms/bin/DmServiceCJC|grep MALLOC_ARENA_MAX
[dmdba@]#vi DmServiceCJC
export MALLOC_ARENA_MAX=4

sed -i "s/### END INIT INFO/### END INIT INFO\n\nexport MALLOC_ARENA_MAX=1/" /dm8/dbms/bin/DmServiceCJC

disql CJC:35231
create table t0920(id int);
insert into t0920 values(1);
commit;

disql CJC:35231
SQL> select * from t0920;
LINEID id         
---------- -----------
1 1
used time: 0.303(ms). Execute id is 101.

SQL> insert into t0920 values(2);
insert into t0920 values(2);
[-710]:Try to modify user database at standby mode.
used time: 0.610(ms). Execute id is 0.

vi /etc/dm_svc.conf
##全局配置区
TIME_ZONE=(480)
LANGUAGE=(cn)
DMHACJC=(192.168.1.101:35231,192.168.1.102:35231)
##服务配置
[DMHACJC]
SWITCH_TIMES=(3)
SWITCH_INTERVAL=(100)
LOGIN_MODE=(1)

disql SYSDBA@DMHACJC
jdbc:dm://DMHACJC

###dmmonitor /dm8/data/CJC/dmmonitor_front.ini

dmdba@EBGCJC-002:/home/dmdba$disql SYSDBA@DMHA

密码:
服务器[192.168.1.101:35231]:处于主库打开状态
登录使用时间 : 5.397(ms)
disql V8
SQL> select name,instance_name,status$,mode$ from v$instance;
行号 name instance_name status$ mode$  
---------- ---- ------------- ------- -------
1 CJC01 CJC01          OPEN    PRIMARY

show global info

login
用户名:SYSDBA
密码:
[monitor] 2023-09-20 14:33:37: 登录监视器成功!

switchover GRPCJC.CJC02

show global info

SQL> select name,instance_name,status$,mode$ from v$instance;
服务器[192.168.1.102:35231]:处于主库打开状态
已连接
行号 name instance_name status$ mode$  
---------- ---- ------------- ------- -------
1 CJC02 CJC02          OPEN    PRIMARY
已用时间: 3.059(毫秒). 执行号:700.

SQL> insert into CJC.t0920 values(2);

影响行数 1
已用时间: 1.380(毫秒). 执行号:802.
SQL> commit;
操作已执行
已用时间: 3.062(毫秒). 执行号:803.
SQL> select * from CJC.t0920;
行号 id         
---------- -----------
1 100
2 2
已用时间: 0.292(毫秒). 执行号:804

dmdba@EBGCJC-001:/home/dmdba$!198
disql SYSDBA/xxxxxx:35231
服务器[LOCALHOST:35231]:处于备库打开状态
登录使用时间 : 3.023(ms)
disql V8
SQL> select * from CJC.t0920;
行号 id         
---------- -----------
1 100
2 2
已用时间: 1.895(毫秒). 执行号:800.
SQL> insert into CJC.t0920 values(3);
insert into CJC.t0920 values(3);
[-710]:试图在STANDBY模式下，修改用户库.
已用时间: 0.551(毫秒). 执行号:0.

login
用户名:SYSDBA
密码:
switchover GRPCJC.CJC01

systemctl status DmMonitorServiceMONITOR.service

tail -100f /dm8/mal/log/dmmonitor_20230920110403.log

systemctl stop DmWatcherServiceWATCHER.service

ps -ef|grep -i dms|grep -v grep
ps -ef|grep -i dmw|grep -v grep

[monitor] 2023-09-20 15:31:48: [!!! 实例CJC01[PRIMARY, OPEN, ISTAT_SAME:TRUE]故障，实例CJC02[STANDBY, OPEN, ISTAT_SAME:TRUE]符合自动接管条件 !!!]
[monitor] 2023-09-20 15:31:48: 检测到PRIMARY实例故障，开始对组(GRPCJC)执行自动接管

dmdba@EBGCJC-002:/home/dmdba$disql SYSDBA@DMHA
密码:
服务器[192.168.1.102:35231]:处于主库打开状态
登录使用时间 : 5.804(ms)
disql V8
SQL> select name,instance_name,status$,mode$ from v$instance;
行号 name instance_name status$ mode$  
---------- ---- ------------- ------- -------
1 CJC02 CJC02          OPEN    PRIMARY
已用时间: 3.658(毫秒). 执行号:600.

SQL> INSERT INTO CJC.T0920 VALUES(300);
SQL> COMMIT;

systemctl start DmWatcherServiceWATCHER.service

SQL> SELECT * FROM CJC.TEST0920;

dmmonitor /dm8/data/CJC/dmmonitor_front.ini

switchover GRPCJC.CJC01

select PARA_NAME,PARA_VALUE,DEFAULT_VALUE from v$dm_ini where para_name LIKE '%ARCH_INI%';

Select * from v$arch_status;

cd /dm8/data/CJC
cat dm.ini|grep -i ARCH_INI

alter database modify archivelog 'DEST=/dm8/arch, TYPE=LOCAL, FILE_SIZE=200, SPACE_LIMIT=10240';

/dm8/dbms/bin/service_template/DmAPService status

/dm8/dbms/bin/service_template/DmAPService start

SP_INIT_JOB_SYS(1);
SQL> call SP_CREATE_JOB('DM_BAK_FULL_CJC',1,0,'',0,0,'',0,'DM_BAK_FULL_CJC');
SQL> call SP_JOB_CONFIG_START('DM_BAK_FULL_CJC');
SQL> call SP_ADD_JOB_STEP('DM_BAK_FULL_CJC', 'DM_BAK_FULL_CJC', 6, '00000000/dm8/bak/full', 0, 0, 0, 0, NULL, 0);
SQL> call SP_ADD_JOB_SCHEDULE('DM_BAK_FULL_CJC', 'DM_BAK_FULL_CJC', 1, 1, 1, 0, 0, '23:00:00', NULL, '2023-11-02 21:30:30', NULL, '');
SQL> call SP_JOB_CONFIG_COMMIT('DM_BAK_FULL_CJC');