热门搜索
分布式
数据库一体机
云数据库
建设银行
保险核心
密集交易
登录
注册
DSC集群通过SQL查看集群信息
DSC集群通过SQL查看集群信息
Solreal
2023/12/01
1344
0
0
摘要
DSC集群完成之后可以通过以下SQL查询集群的信息
检查集群
SQL> select * from V$dsc_ep_info;
LINEID EP_NAME EP_SEQNO EP_GUID EP_TIMESTAMP EP_MODE EP_STATUS
---------- ------- ----------- -------------------- -------------------- ------------ ---------
1 DSC0 0 9684163 9684477 Control Node OK
2 DSC1 1 9725549 9725768 Normal Node OK
used time: 468.386(ms). Execute id is 55000.
检查文件路径
SQL> select path from v$datafile;
LINEID PATH
---------- --------------------------
1 +DMDATA/data/SYSTEM.dbf
2 +DMDATA/data/ROLL.dbf
3 +DMDATA/data/DSC/TEMP0.DBF
4 +DMDATA/data/MAIN.dbf
used time: 233.157(ms). Execute id is 55002.
SQL> select path from v$rlogfile;
LINEID PATH
---------- ----------------------
1 +DMDATA/DSC0_LOG01.log
2 +DMDATA/DSC0_LOG02.log
used time: 272.908(ms). Execute id is 55005.
检查实例
SQL> select name,instance_name,host_name from v$instance;
LINEID NAME INSTANCE_NAME HOST_NAME
---------- ---- ------------- ---------
1 DSC0 DSC0 dsc01
used time: 822.051(ms). Execute id is 55100.
SQL> select name,instance_name,host_name from v$instance;
LINEID NAME INSTANCE_NAME HOST_NAME
---------- ---- ------------- ---------
1 DSC1 DSC1 dsc02
used time: 17.985(ms). Execute id is 7.
检查ASM
SQL> select group_id,group_name,TOTAL_SIZE from v$asmgroup;
LINEID GROUP_ID GROUP_NAME TOTAL_SIZE
---------- ----------- ---------- -----------
1 0 DMDATA 10239
2 1 DMARCH 2047
3 125 VOTE 2048
4 126 DCR 2048
used time: 907.805(ms). Execute id is 55007.
SQL> select disk_name,disk_path from v$asmdisk;
LINEID DISK_NAME DISK_PATH
---------- ---------- -----------------
1 DMASMDATA0 /dev/dm/asm-diskh
2 DMASMARCH0 /dev/dm/asm-diskg
3 DMASMvote /dev/dm/asm-diske
4 DMASMdcr /dev/dm/asm-diskf
used time: 433.907(ms). Execute id is 55008.
SQL> select * from V$ASMATTR;
LINEID AU_SIZE EXTENT_SIZE LOCAL_CODE LOCAL_LANG USE_SHM EXTENT_ARR_SIZE
---------- ----------- ----------- ---------- ---------- ------- ---------------
1 1048576 4 PG_GB18030 EN TRUE 12351936
used time: 77.872(ms). Execute id is 55013.
SQL> select file_id,type,path from v$asmfile;
LINEID FILE_ID TYPE PATH
---------- -------------------- --------- ------------------------
1 2147483649 DIRECTORY +DMDATA
2 2147483650 DIRECTORY +DMDATA/data
3 2147483651 DIRECTORY +DMDATA/data/DSC
4 2147483652 DIRECTORY +DMDATA/data/DSC/bak
5 2147483653 FILE +DMDATA/data/dm.ctl
6 2147483679 FILE +DMDATA/DSC0_LOG01.log
7 2147483680 FILE +DMDATA/DSC0_LOG02.log
8 2147483681 FILE +DMDATA/DSC1_LOG01.log
9 2147483682 FILE +DMDATA/DSC1_LOG02.log
10 2147483661 FILE +DMDATA/data/SYSTEM.dbf
11 2147483659 DIRECTORY +DMDATA/data/DSC/ctl_bak
12 2147483685 FILE +DMDATA/data/MAIN.dbf
13 2147483662 FILE +DMDATA/data/DSC/dm_service.prikey
14 2147483684 FILE +DMDATA/data/DSC/ctl_bak/dm_20221208175156_758750.ctl
15 2147483686 FILE +DMDATA/data/ROLL.dbf
16 2147483687 DIRECTORY +DMDATA/data/DSC/HMAIN
17 2147483688 FILE +DMDATA/data/DSC/TEMP0.DBF
18 2147483689 FILE +DMDATA/data/DSC/TEMP1.DBF
19 2147483692 FILE +DMDATA/data/DSC/rep_conflict.log
20 2147483691 FILE +DMDATA/data/DSC/ctl_bak/dm_20221208180445_380829.ctl
21 2147483694 FILE +DMDATA/data/DSC/ctl_bak/dm_20221208180608_533426.ctl
22 2164260865 DIRECTORY +DMARCH
23 4244635649 DIRECTORY +VOTE
24 4244635650 FILE +VOTE/VOTE
25 4261412865 DIRECTORY +DCR
26 4261412866 FILE +DCR/DCR
26 rows got
used time: 485.758(ms). Execute id is 55009.
检查DCR
SQL> select * from V$DCR_INFO;
LINEID VERSION N_GROUP VTD_PATH UDP_FLAG UDP_OGUID DCR_PATH
---------- ----------- ----------- ----------------- ----------- -------------------- -----------------
1 259 3 /dev/dm/asm-diske 0 210715 /dev/dm/asm-diskf
used time: 923.717(ms). Execute id is 55010.
SQL> select * from V$DCR_GROUP;
LINEID GROUP_TYPE GROUP_NAME N_EP DSKCHK_CNT NETCHK_TIME
---------- ---------- ---------- ----------- ----------- -----------
1 CSS GRP_CSS 2 65 0
2 ASM GRP_ASM 2 61 0
3 DB GRP_DSC 2 57 0
used time: 903.076(ms). Execute id is 55011.
SQL> select * from V$DCR_EP;
LINEID GROUP_NAME EP_NAME EP_SEQNO EP_HOST EP_PORT UDP_PORT SHM_KEY SHM_SIZE ASM_LOAD_PATH
---------- ---------- ------- ----------- -------------- ----------- ----------- ----------- ----------- -------------
1 GRP_CSS CSS0 0 192.168.33.200 11286 0 0 0 NULL
2 GRP_CSS CSS1 1 192.168.33.58 11286 0 0 0 NULL
3 GRP_ASM ASM0 0 192.168.33.200 11276 0 42424 1024 /dev/dm
4 GRP_ASM ASM1 1 192.168.33.58 11277 0 42425 1024 /dev/dm
5 GRP_DSC DSC0 0 5237 0 0 0 NULL
6 GRP_DSC DSC1 1 5237 0 0 0 NULL
6 rows got
创建测试数据
SQL> create table t1(id int,time datetime);
executed successfully
used time: 535.329(ms). Execute id is 55016.
SQL> insert into t1 values(1,now());
affect rows 1
used time: 0.908(ms). Execute id is 55017.
SQL> commit;
executed successfully
used time: 502.314(ms). Execute id is 55019.
SQL> select * from t1;
LINEID ID TIME
---------- ----------- --------------------------
1 1 2022-12-08 18:24:26.540339
used time: 00:00:01.008. Execute id is 55018.
登录另一个节点，可以正常查到数据
SQL> select * from t1;
LINEID ID TIME
---------- ----------- --------------------------
1 1 2022-12-08 18:24:26.540339
used time: 00:00:03.320. Execute id is 2.
评论
后发表回复
作者
文章
阅读量
获赞
扫一扫
联系客服
联系客服
鄂Copyright © 达梦国产化应用创新实验室
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1
达梦在线服务平台社区用户管理规范
鄂ICP备18017926号-1