注意/dm8目录权限，可以适当修改

注意检查两台机器是否有相关裸设备
```
ll -l /dev/raw
```
注意所有节点时钟是否同步，不能超过5分钟
注意路径要求
注意DM软件安装目录/dm8/dmdbms/bin

检查磁盘映射

ll /dev/raw
crw-rw---- 1 dmdba dinstall 162, 1 11月 24 16:57 raw1
crw-rw---- 1 dmdba dinstall 162, 2 11月 24 16:57 raw2
crw-rw---- 1 dmdba dinstall 162, 3 11月 24 16:57 raw3
crw-rw---- 1 dmdba dinstall 162, 4 11月 24 16:57 raw4
crw-rw---- 1 root  disk     162, 0 11月 24 16:56 rawctl

检查防火墙

[root@DMDSC2 ~]# systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

环境变量添加

export PATH=$DM_HOME/bin:$DM_HOME/tool:$PATH

安装

准备参数文件目录

mkdir -p /dm8/config
mkdir -p /dm8/backup

准备参数文件

配置文件dmdcr_cfg.ini（节点1、节点2一致）

dmdcr_cfg.ini（节点1、节点2一致）

vi /dm8/config/dmdcr_cfg.ini
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/raw/raw2   
DCR_OGUID = 63635
[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = GRP_CSS
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 192.168.209.221
DCR_EP_PORT = 9341
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.209.222
DCR_EP_PORT = 9343
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_ASM]
DCR_EP_NAME = ASM0
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.209.221
DCR_EP_PORT = 9349
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 10
DCR_EP_HOST = 192.168.209.222
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/raw
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DSC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_DSC]
DCR_EP_NAME = DMDSC01 
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9741
[GRP_DSC]
DCR_EP_NAME = DMDSC02
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9742

dmasvrmal配置 ASM 的MAL 系统配置文件(两节点） ##########注意修改IP

vi /dm8/config/dmasvrmal.ini
[MAL_INST1]
MAL_INST_NAME = ASM0
MAL_HOST = 192.168.209.221
MAL_PORT = 7236

[MAL_INST2]
MAL_INST_NAME = ASM1
MAL_HOST = 192.168.209.222
MAL_PORT = 7236

dmdcr.ini（节点1、节点2，不一致，注意DMDCR_SEQNO 和路径是否正确）


节点1
vi /dm8/config/dmdcr.ini

DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm8/config/dmasvrmal.ini
DMDCR_SEQNO = 0
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /dm8/dmdbms/bin/dmasmsvr dcr_ini=/dm8/config/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /dm8/dmdbms/bin/dmserver path=/dm8/dsc0_config/dm.ini dcr_ini=/dm8/config/dmdcr.ini


节点2

vi /dm8/config/dmdcr.ini

DMDCR_PATH = /dev/raw/raw1
DMDCR_MAL_PATH =/dm8/config/dmasvrmal.ini
DMDCR_SEQNO = 1
DMDCR_ASM_RESTART_INTERVAL = 0
DMDCR_ASM_STARTUP_CMD = /dm8/dmdbms/bin/dmasmsvr dcr_ini=/dm8/config/dmdcr.ini
DMDCR_DB_RESTART_INTERVAL = 0
DMDCR_DB_STARTUP_CMD = /dm8/dmdbms/bin/dmserver path=/dm8/dmdbms/config/dsc1_config/dm.ini dcr_ini=/dm8/config/dmdcr.ini

dminit.ini 第一个节点有即可

vi /dm8/config/dminit.ini



db_name = DMDSC
system_path = +DMDATA/data
system = +DMDATA/data/dmdsc/system.dbf
system_size = 128
roll = +DMDATA/data/dmdsc/roll.dbf
roll_size = 128
main = +DMDATA/data/dmdsc/main.dbf
main_size = 128
ctl_path = +DMDATA/data/dmdsc/dm.ctl
ctl_size = 8
log_size = 256
dcr_path = /dev/raw/raw1
dcr_seqno = 0
auto_overwrite = 1
SYSDBA_PWD=Dameng123
SYSAUDITOR_PWD=Dameng123
[DMDSC01]
config_path = /dm8/dsc0_config
port_num = 5236
mal_host = 192.168.209.221
mal_port = 5238
log_path = +DMLOG/log/dsc0_log01.log
log_path = +DMLOG/log/dsc0_log02.log
[DMDSC02]
config_path = /dm8/dsc1_config
port_num = 5236
mal_host = 192.168.209.222
mal_port = 5239
log_path = +DMLOG/log/dsc1_log01.log
log_path = +DMLOG/log/dsc1_log02.log

初始化磁盘

dmdba执行
 /dm8/dmdbms/bin/dmasmcmd

创建DMASM磁盘：
create dcrdisk   '/dev/raw/raw1'   'dcr'
create votedisk  '/dev/raw/raw2'  'vote'
create asmdisk  '/dev/raw/raw3'  'LOG0'
create asmdisk  '/dev/raw/raw4'  'DATA0'
初始化DCR和VOTE
init  dcrdisk  '/dev/raw/raw1'   from  '/dm8/config/dmdcr_cfg.ini'  identified by  'Dameng123'
init  votedisk  '/dev/raw/raw2'  from  '/dm8/config/dmdcr_cfg.ini'


如果装的半路有错误，再次安装需要格式化 
sudo dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=1024
sudo dd if=/dev/zero of=/dev/raw/raw2 bs=1024 count=1024
sudo dd if=/dev/zero of=/dev/raw/raw3 bs=1024 count=1024
sudo dd if=/dev/zero of=/dev/raw/raw4 bs=1024 count=1024

启动 DMCSS、 DMASM 服务程序（两节点都要操作）

节点1-多开几个窗口

启动css和asm是需要有顺序的：
1）首先启动css服务
./dmcss DCR_INI=/dm8/config/dmdcr.ini
DMCSS V8
DMCSS IS READY
[2025-11-12 15:04:58:739] [CSS]: 设置EP CSS1[0]为控制节点
2) css启动成功后，再启动asm服务
./dmasmsvr DCR_INI=/dm8/config/dmdcr.ini

ASM SELF EPNO:0
DMASMSVR V8
dmasmsvr task worker thread startup
the ASM server is Ready.
check css cmd: START NOTIFY, cmd_seq: 2, code: 0
check css cmd: EP START, cmd_seq: 3, code: 0

ASM Control Node EPNO:0
[WARNING]Decode asmdisk device fail, sig:1751483255, disk_id:65535, group_id:65535.
[WARNING]Decode asmdisk device fail, sig:1751483255, disk_id:65535, group_id:65535.
check css cmd: EP OPEN, cmd_seq: 8, code: 0
check css cmd: EP REAL OPEN, cmd_seq: 11, code: 0

节点2-多开几个窗口

启动css和asm是需要有顺序的：
1）首先启动css服务
./dmcss DCR_INI=/dm8/config/dmdcr.ini
2) css启动成功后，再启动asm服务
./dmasmsvr DCR_INI=/dm8/config/dmdcr.ini


[dmdba@DMDSC2 config]$ dmcss DCR_INI=/dm8/config/dmdcr.ini
DMCSS V8
DMCSS IS READY
[2025-11-24 19:03:10:609] [CSS]: 设置EP CSS0[0]为控制节点

[2025-11-24 19:03:59:848] A guid change of ASM [ASM0] has been detected, instance must has been restarted.

[CSS]: detect ASM [ASM0] broken, need to force halt the same-site DB instance [DMDSC01].
shutdown ep[0] abort!
[2025-11-24 19:03:59:848] CSS may probably exclude the instance from the cluster and launch crash recovery process.

[CSS]: detect ASM [ASM1] broken, need to force halt the same-site DB instance [DMDSC02].
shutdown ep[1] abort!
[DB]: check ep crash, shutdown abort seqno[0]
shutdown ep[0] abort!
[DB]: check ep crash, shutdown abort seqno[1]
shutdown ep[1] abort!

--这个是正常信息

创建磁盘组及初始化数据库(以下在节点1执行，新开一个SSH）

创建磁盘组

1） 使用dmasmtool创建DMASM磁盘组 
dmdba用户执行
# /dm8/dmdbms/bin/dmasmtool DCR_INI=/dm8/config/dmdcr.ini
#创建日志磁盘组
DMASMTOOL V8
ASM>create diskgroup 'DMLOG' asmdisk '/dev/raw/raw3'
#创建数据磁盘组
ASM>create diskgroup 'DMDATA' asmdisk '/dev/raw/raw4'

初始化共享存储集群数据库实例

使用 dminit 初始化 DB 环境（节点1执行即可） ##########注意修改IP

# /dm8/dmdbms/bin/dminit control=/dm8/config/dminit.ini



initdb V8
db version: 0x7000d
file dm.key not found, use default license!
License will expire on 2026-05-27
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL

 log file path: +DMLOG/log/dsc0_log01.log


 log file path: +DMLOG/log/dsc0_log02.log


 log file path: +DMLOG/log/dsc1_log01.log


 log file path: +DMLOG/log/dsc1_log02.log

write to dir [+DMDATA/data/DSC].
create dm database success. 2025-11-12 15:12:25

初始化完成后会在 init 控制文件配置的目录下生成 2 个实例的配置文件（节点一执行即可）： ##########注意修改IP

将 dsc1_config 目录复制到节点 2 (10.34.61.167)上对应的目录下

 scp -r dsc1_config 192.168.245.222:/dm8/

启动数据库

节点一

节点1执行
# /dm8/dmdbms/bin/dmserver /dm8/dsc0_config/dm.ini dcr_ini=/dm8/config/dmdcr.ini

file dm.key not found, use default license!
version info: develop
csek2_vm_t = 1448
nsql_vm_t = 328
prjt2_vm_t = 176
ltid_vm_t = 216
nins2_vm_t = 1144
nset2_vm_t = 272
ndlck_vm_t = 192
ndel2_vm_t = 768
slct2_vm_t = 352
nli2_vm_t = 200
aagr2_vm_t = 304
pscn_vm_t = 400
dist_vm_t = 992
DM Database Server 64 V8 03134284368-20250527-275278-20149 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2026-05-27
hlck_sys_init, init g_drm_dest:[0, 1]
lbs_sys_init, the length of g_master_map is 8849, fill it use ok_ep_arr:[0, 1], n_ok_ep:2!
check CSS cmd: START NOTIFY, cmd_seq: 2, code: 0
Control Node change from 255 to 254
check CSS cmd: DCR_LOAD, cmd_seq: 3, code: 0
check CSS cmd: EP START, cmd_seq: 6, code: 0
Control Node change from 254 to 0
file lsn: 0
check CSS cmd: EP START2, cmd_seq: 11, code: 0
ndct db load finished, code:100
ckpt2_exec_immediately begin.
checkpoint: buffer pages flushing..., upd_cnt:2
checkpoint end, 2 pages flushed, used_space[4096], free_space[536858624].
checkpoint end, 0 pages flushed, used_space[4096], free_space[536858624].
checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
next_trxid in mem:[2002]
next_trxid = 4006.
pseg recv finished
nsvr_startup end.
uthr_pipe_create, create pipe[read:21, write:22]
uthr_pipe_create, create pipe[read:23, write:24]
uthr_pipe_create, create pipe[read:25, write:26]
uthr_pipe_create, create pipe[read:27, write:28]
aud sys init success.
aud rt sys init success.
trx: 4006 purged 1 pages
trx: 4044 purged 1 pages
trx: 4046 purged 1 pages
trx: 4048 purged 1 pages
......
......
trx: 5486 purged 1 pages
trx: 5490 purged 1 pages
trx: 5494 purged 1 pages
trx: 5502 purged 8 pages
trx: 5506 purged 1 pages
trx: 5524 purged 1 pages
trx: 5528 purged 1 pages
checkpoint for flush ts[65535] buffer...
checkpoint for flush ts[65535] buffer end
systables desc init success.
ndct_db_load_info finished, code:100.
nsvr_process_before_open begin.
nsvr_process_before_open success.
SYSTEM IS READY.
check CSS cmd: EP OPEN, cmd_seq: 16, code: 0
next_trxid in mem:[8016]
next_trxid = 10020.
[!!!DSC INFO!!!] DSC crash process over!
check CSS cmd: EP REAL OPEN, cmd_seq: 19, code: 0

节点2

节点2执行
# /dm8/dmdbms/bin/dmserver /dm8/dsc1_config/dm.ini dcr_ini=/dm8/config/dmdcr.ini

file dm.key not found, use default license!
version info: develop
csek2_vm_t = 1448
nsql_vm_t = 328
prjt2_vm_t = 176
ltid_vm_t = 216
nins2_vm_t = 1144
nset2_vm_t = 272
ndlck_vm_t = 192
ndel2_vm_t = 768
slct2_vm_t = 352
nli2_vm_t = 200
aagr2_vm_t = 304
pscn_vm_t = 400
dist_vm_t = 992
DM Database Server 64 V8 03134284368-20250527-275278-20149 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire on 2026-05-27
hpc_ini_info_pre_check end, code:0
hlck_sys_init, init g_drm_dest:[0, 1]
lbs_sys_init, the length of g_master_map is 8849, fill it use ok_ep_arr:[0, 1], n_ok_ep:2!
check CSS cmd: DCR_LOAD, cmd_seq: 4, code: 0
check CSS cmd: EP START, cmd_seq: 8, code: 0
Control Node change from 255 to 0
mal_tsk_process_g_crash_lsn_bro, ep_seqno(0), crash_lsn(0)
mal_tsk_process_g_crash_lsn_bro, ep_seqno(1), crash_lsn(0)
check CSS cmd: EP START2, cmd_seq: 13, code: 0
Control node start status: OPEN
file lsn: 0
ndct db load finished, code:100
ckpt2_exec_immediately begin.
checkpoint end, 0 pages flushed, used_space[4096], free_space[536858624].
checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
checkpoint end, 0 pages flushed, used_space[0], free_space[536862720].
pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs!
next_trxid in mem:[8013]
next_trxid = 10017.
pseg recv finished
nsvr_startup end.
uthr_pipe_create, create pipe[read:21, write:22]
uthr_pipe_create, create pipe[read:23, write:24]
uthr_pipe_create, create pipe[read:25, write:26]
uthr_pipe_create, create pipe[read:27, write:28]
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info finished, code:100.
nsvr_process_before_open begin.
nsvr_process_before_open success.
SYSTEM IS READY.
check CSS cmd: EP OPEN, cmd_seq: 17, code: 0
next_trxid in mem:[10017]
next_trxid = 12021.
check CSS cmd: EP REAL OPEN, cmd_seq: 20, code: 0

验证

[dmdba@localhost bin]$ /dm8/bin/disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 49.380(ms)
disql V8
SQL>  select * from v$dsc_ep_info;

行号     EP_NAME EP_SEQNO    EP_GUID              EP_TIMESTAMP         EP_MODE      EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1          dmdsc01 0           17432670             17433275             Control Node OK
2          dmdsc02 1           17452915             17453508             Normal Node  OK

注册服务（root执行）

节点一

#注册 dmcss 服务（两节点执行）
# /dm8/dmdbms/script/root/dm_service_installer.sh -t dmcss -p DmdscCss -dcr_ini /dm8/config/dmdcr.ini
创建服务(DmCSSServiceDmdscCss)完成

#注册 dmasm 服务
#/dm8/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -p DmdscAsm -dcr_ini /dm8/config/dmdcr.ini -y DmCSSServiceDmdscCss
Created symlink /etc/systemd/system/multi-user.target.wants/DmASMSvrServiceDmdscAsm.service → /usr/lib/systemd/system/DmASMSvrServiceDmdscAsm.service.
创建服务(DmASMSvrServiceDmdscAsm)完成

#注册 DSC 实例服务（dsc1, dsc2)
#节点 1（10.34.61.166） ：
#/dm8/dmdbms/script/root/dm_service_installer.sh -t dmserver -p DmdscServer -dcr_ini /dm8/config/dmdcr.ini -dm_ini /dm8/dsc0_config/dm.ini -y DmASMSvrServiceDmdscAsm
创建服务(DmServiceDmdscServer)完成

节点二

#注册 dmcss 服务（两节点执行）
# /dm8/dmdbms/script/root/dm_service_installer.sh -t dmcss -p DmdscCss -dcr_ini /dm8/config/dmdcr.ini
创建服务(DmCSSServiceDmdscCss)完成

#注册 dmasm 服务
#/dm8/dmdbms/script/root/dm_service_installer.sh -t dmasmsvr -p DmdscAsm -dcr_ini /dm8/config/dmdcr.ini -y DmCSSServiceDmdscCss
Created symlink /etc/systemd/system/multi-user.target.wants/DmASMSvrServiceDmdscAsm.service → /usr/lib/systemd/system/DmASMSvrServiceDmdscAsm.service.
创建服务(DmASMSvrServiceDmdscAsm)完成

#注册 DSC 实例服务（dsc1, dsc2)
#节点 1（10.34.61.166） ：
#/dm8/dmdbms/script/root/dm_service_installer.sh -t dmserver -p DmdscServer -dcr_ini /dm8/config/dmdcr.ini -dm_ini /dm8/dsc1_config/dm.ini -y DmASMSvrServiceDmdscAsm
创建服务(DmServiceDmdscServer)完成

服务启动

重启两节点实例（实际上是重启了两台服务器）：或者直接kill进程
需要关闭那两个css服务窗口再restart，先启动 css asm 最后再启动 server，需要等一小段时间
节点 1：
/dm8/bin/DmServiceDmdscServer status
节点 2：
/dm8/bin/DmServiceDmdscServer status

查看日志位置 /dm8/log/DmCSSServiceDmdscCss_err.log 
[root@DMDSC1 ~]# ps -ef|grep dmdba
root        3584    3451  0 17:59 pts/0    00:00:00 su - dmdba
dmdba       3589    3584  0 17:59 pts/0    00:00:00 -bash
dmdba       6814       1  0 18:05 ?        00:00:00 /dm8/dmdbms/bin/dmap dmap_ini=/dm8/dmdbms/bin/dmap.ini
root       10582       1  0 19:28 ?        00:00:00 su - dmdba
dmdba      10587   10582  0 19:28 ?        00:00:00 -bash
dmdba      10647   10587  0 19:28 ?        00:00:02 dmasmsvr DCR_INI=/dm8/config/dmdcr.ini
root       12005   11887  0 19:42 pts/3    00:00:00 grep --color=auto dmdba
[root@DMDSC1 ~]# kill -9 10647

关闭各窗口后，可以在root账号下启动 CSS、ASM和DB
# systemctl start DmCSSServiceDmdscCss.service
# systemctl start DmASMSvrServiceDmdscAsm.service
# systemctl start DmServiceDmdscServer.service

配置归档–注意目录问题，不在config下在dsc0和dsc1下

一、起归档
在两台机器的 /dm8/config/dsc1和dsc2 两个目录分别创建两个配置文件，dmarch.ini
同时修改这两个目录中有dm.ini的参数 ARCH_INI = 1

节点1
vi /dm8/dsc0_config/dmarch.ini
ARCH_WAIT_APPLY = 0
ARCH_LOCAL_SHARE = 1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL 
ARCH_DEST = +DMDATA/DSC0/arch
ARCH_FILE_SIZE = 256 
ARCH_SPACE_LIMIT = 2048
ARCH_FLUSH_BUF_SIZE = 0

[ARCHIVE_REMOTE1]    #远程归档
ARCH_TYPE = REMOTE
ARCH_DEST = DMDSC02    #节点2的实例名
ARCH_FILE_SIZE = 256 
ARCH_SPACE_LIMIT = 2048
ARCH_FLUSH_BUF_SIZE = 0
ARCH_INCOMING_PATH = +DMDATA/DSC1/arch

节点2
vi /dm8/dsc1_config/dmarch.ini
ARCH_WAIT_APPLY = 0
ARCH_LOCAL_SHARE = 1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = +DMDATA/DSC1/arch
ARCH_FILE_SIZE = 256 
ARCH_SPACE_LIMIT = 2048
ARCH_FLUSH_BUF_SIZE = 0

[ARCHIVE_REMOTE1]    #远程归档
ARCH_TYPE = REMOTE
ARCH_DEST = DMDSC01    #节点1的实例名
ARCH_FILE_SIZE = 256 
ARCH_SPACE_LIMIT = 2048
ARCH_FLUSH_BUF_SIZE = 0
ARCH_INCOMING_PATH = +DMDATA/DSC0/arch

节点1：
/dm/bin/DmServiceDmdscServer.service  restart
节点2：
/dm/bin/DmServiceDmdscServer.service  restart

验证服务状态及归档
[dmdba@localhost bin]$ /dm8/bin/disql sysdba/Dameng123
SQL> select * from v$dsc_ep_info;


行号     EP_NAME EP_SEQNO    EP_GUID              EP_TIMESTAMP         EP_MODE      EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1          DMDSC01 0           9429139              9429272              Control Node OK
2          DMDSC02 1           9474944              9475015              Normal Node  OK

已用时间: 6.970(毫秒). 执行号:101.


已用时间: 11.346(毫秒). 执行号:1.
SQL> select * from v$arch_status;


行号     ARCH_TYPE ARCH_DEST         ARCH_STATUS ARCH_SRC
---------- --------- ----------------- ----------- --------
1          LOCAL     +DMDATA/DSC2/arch VALID       DMDSC02
2          REMOTE    +DMDATA/DSC1/arch VALID       DMDSC01

已用时间: 3.518(毫秒). 执行号:102.


已用时间: 1.151(毫秒). 执行号:2.
SQL>

配置监视器

配置文件

mkdir  /dm8/config
vi /dm8/config/dmcssm.ini
#和 dmdcr_cfg.ini 中的 DCR_OGUID 保持一致
CSSM_OGUID = 63635
#配置所有 CSS 的连接信息，
#和 dmdcr_cfg.ini 中 CSS 配置项的 DCR_EP_HOST 和 DCR_EP_PORT 保持一致
CSSM_CSS_IP = 192.168.245.221:9341
CSSM_CSS_IP = 192.168.245.222:9343
CSSM_LOG_PATH =/dm8/log #监视器日志文件存放路径
CSSM_LOG_FILE_SIZE = 32 #每个日志文件最大 32M
CSSM_LOG_SPACE_LIMIT = 0 #不限定日志文件总占用空间

启监视器服务

启监视器服务
启动监视器：
# /dm8/bin/dmcssm /dm8/config/dmcssm.ini

# /dm8/bin/dmcssm /dm8/config/dmcssm.ini
[monitor]         2025-09-15 16:18:58: CSS MONITOR V8
[monitor]         2025-09-15 16:18:58: CSS MONITOR SYSTEM IS READY.

[monitor]         2025-09-15 16:18:58: Wait CSS Control Node choosed...
[monitor]         2025-09-15 16:18:59: Wait CSS Control Node choosed succeed.

show

monitor current time:2025-09-15 16:21:06, n_group:3
=================== group[name = GRP_CSS, seq = 0, type = CSS, Control Node = 0] ========================================

[CSS0] auto check = TRUE, global info:
[ASM0] auto restart = FALSE
[dmdsc01] auto restart = FALSE
[CSS1] auto check = TRUE, global info:
[ASM1] auto restart = FALSE
[dmdsc02] auto restart = FALSE

ep:     css_time               inst_name     seqno     port    mode         inst_status        vtd_status   is_ok        active       guid              ts
        2025-09-15 16:21:05    CSS0          0         9341    Control Node OPEN               WORKING      OK           TRUE         64593             66370
        2025-09-15 16:21:05    CSS1          1         9343    Normal Node  OPEN               WORKING      OK           TRUE         64261             66017

=================== group[name = GRP_ASM, seq = 1, type = ASM, Control Node = 0] ========================================

n_ok_ep = 2
ok_ep_arr(index, seqno):
(0, 0)
(1, 1)

sta = OPEN, sub_sta = STARTUP
break ep = NULL
recover ep = NULL

crash process over flag is TRUE
ep:     css_time               inst_name     seqno     port    mode         inst_status        vtd_status   is_ok        active       guid              ts
        2025-09-15 16:21:05    ASM0          0         9349    Control Node OPEN               WORKING      OK           TRUE         72363             74123
        2025-09-15 16:21:05    ASM1          1         9351    Normal Node  OPEN               WORKING      OK           TRUE         72457             74195

=================== group[name = GRP_DSC, seq = 2, type = DB, Control Node = 1] ========================================

n_ok_ep = 2
ok_ep_arr(index, seqno):
(0, 0)
(1, 1)

sta = OPEN, sub_sta = STARTUP
break ep = NULL
recover ep = NULL

crash process over flag is TRUE
ep:     css_time               inst_name     seqno     port    mode         inst_status        vtd_status   is_ok        active       guid              ts
        2025-09-15 16:21:05    dmdsc01       0         5236    Normal Node  OPEN               WORKING      OK           TRUE         148725            150446
        2025-09-15 16:21:05    dmdsc02       1         5236    Control Node OPEN               WORKING      OK           TRUE         134502            136223

==================================================================================================================

注册监视器服务，使用root账户执行，也考虑一下是否重启一下主机

/dm8/ddmdbms/script/root/dm_service_installer.sh -t dmcssm -p DmCssMon -cssm_ini /dm8/config/dmcssm.ini
创建服务(DmCSSMonitorServiceDmCssMon)完成
systemctl start  DmCSSMonitorServiceDmCssMon.service

DSC备份

联机备份DSC数据库到/dm8/backup中利用manager备份

SQL>BACKUP DATABASE BACKUPSET '/dm8/backup/db_full_bak_for_dsc';


ls -l /dm8/backup/

配置重连机制 dm_svc.conf

vi /etc/dm_svc.conf

dmdsc=(192.168.245.221:5236,192.168.245.222:5236)
SWITCH_TIME=(10000)
SWITCH_INTERVAL=(1000)


[dmdba@DMDSC1 backup]$ disql sysdba/Dameng123@dmdsc

服务器[192.168.245.221:5236]:处于普通打开状态
登录使用时间 : 90.313(ms)
disql V8
SQL>

联机备份

联机备份DSC数据库至 /dm8/backup目录，备份文件命名为 dmdsc_fullbak

ls -l /dm8/backup/
mkdir /dm8/backup
SQL>BACKUP DATABASE BACKUPSET '/dm8/backup/dmdsc_fullbak';
ls -l /dm8/backup/

修改buffer

为DSC共享存储集群配置服务名连接，服务名为 DCM_DSC

SP_SET_PARA_VALUE(2, 'buffer', 1000);

SQL> SP_SET_PARA_VALUE(2, 'buffer', 1000);
DMSQL 过程已成功完成
已用时间: 42.148(毫秒). 执行号:202.
SQL> exit
[dmdba@DMDSC1 backup]$ disql sysdba/Dameng123

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 7.200(ms)
disql V8
SQL> exit
[dmdba@DMDSC1 backup]$ DmServiceDmdscServer restart
Stopping DmServiceDmdscServer:

坑

坑1

1. DSC1的执行目录是/dm8/dmdbms/bin

2.初始化数据库参数 没有
SYSDBA_PWD=Dameng123
SYSAUDITOR_PWD=Dameng123

3.实例名和数据库名有变化


4. /dm8 dmdba没有写权限 ，无法创建相关配置文件的目录

5.最好设置环境变量
export PATH=$DM_HOME/bin:$DM_HOME/tool:$PATH

DSC部署部署攻略

注意/dm8目录权限，可以适当修改

检查磁盘映射

检查防火墙

环境变量添加

安装

准备参数文件目录

准备参数文件

配置文件dmdcr_cfg.ini（节点1、节点2一致）

dmasvrmal配置 ASM 的MAL 系统配置文件(两节点） ##########注意修改IP

dmdcr.ini（节点1、节点2，不一致，注意DMDCR_SEQNO 和路径是否正确）

dminit.ini 第一个节点有即可

初始化磁盘

启动 DMCSS、 DMASM 服务程序（两节点都要操作）

节点1-多开几个窗口

节点2-多开几个窗口

创建磁盘组及初始化数据库(以下在节点1执行，新开一个SSH）

创建磁盘组

初始化共享存储集群数据库实例

初始化完成后会在 init 控制文件配置的目录下生成 2 个实例的配置文件（节点一执行即可）： ##########注意修改IP

启动数据库

节点一

节点2

验证

注册服务（root执行）

节点一

节点二

服务启动

配置归档–注意目录问题，不在config下在dsc0和dsc1下

配置监视器

配置文件

启监视器服务

注册监视器服务，使用root账户执行，也考虑一下是否重启一下主机

DSC备份

配置重连机制 dm_svc.conf

联机备份

修改buffer

坑

作者

DSC部署部署攻略

注意/dm8目录权限 ，可以适当修改

检查磁盘映射

检查防火墙

环境变量添加

安装

准备参数文件目录

准备参数文件

配置文件dmdcr_cfg.ini（节点1、节点2一致）

dmasvrmal配置 ASM 的MAL 系统配置文件(两节点） ##########注意修改IP

dmdcr.ini（节点1、节点2，不一致，注意DMDCR_SEQNO 和路径是否正确）

dminit.ini 第一个节点有即可

初始化磁盘

启动 DMCSS、 DMASM 服务程序（两节点都要操作）

节点1-多开几个窗口

节点2-多开几个窗口

创建磁盘组及初始化数据库(以下在节点1执行，新开一个SSH）

创建磁盘组

初始化共享存储集群数据库实例

初始化完成后会在 init 控制文件配置的目录下生成 2 个实例的配置文件（节点一执行即可）： ##########注意修改IP

启动数据库

节点一

节点2

验证

注册服务（root执行）

节点一

节点二

服务启动

配置归档–注意目录问题，不在config下在dsc0和dsc1下

配置监视器

配置文件

启监视器服务

注册监视器服务，使用root账户执行，也考虑一下是否重启一下主机

DSC备份

配置重连机制 dm_svc.conf

联机备份

修改buffer

坑

作者

注意/dm8目录权限，可以适当修改