達夢資料庫如何解除主從關係

slnngk發表於2024-03-25
資料庫

環境:
OS:Centos 7
DB:DMV8

1.停掉dmwatcher並刪除服務
[root@host02 root]# systemctl stop DmWatcherServiceGRP1
[root@host02 root]# cd /dmdbms/product/script/root
[root@host02 root]# ./dm_service_uninstaller.sh -n DmWatcherServiceGRP1

2.刪除實時歸檔

[dmdba@host02 DAMENG]$ vi dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE        = REALTIME #實時歸檔型別
ARCH_DEST        = DAMENG   #實時歸檔目標例項名,這裡是主庫的例項名

[ARCHIVE_LOCAL1]
ARCH_TYPE        = LOCAL          #本地歸檔型別
ARCH_DEST        = /dmdbms/arch #本地歸檔檔案存放路徑
ARCH_FILE_SIZE   = 2048           #單位Mb,本地單個歸檔檔案最大值
ARCH_SPACE_LIMIT = 0         #單位Mb,0 表示無限制,範圍 1024~4294967294M
ARCH_FLUSH_BUF_SIZE = 0
ARCH_HANG_FLAG = 1

刪除實時歸檔部分

3.若在該機器配置部署了監控機的話也要刪除
[root@host02 root]#systemctl stop DmMonitorServiceMonitor
[root@host02 root]# ./dm_service_uninstaller.sh -n DmMonitorServiceMonitor

4.刪除dmmal.ini配置檔案
注意這裡還需要修改配置檔案,把MAL_INI引數原來的1改成0,ALTER_MODE_STATUS原來的0該成1
vi /dmdbms/data/DAMENG/dm.ini
MAL_INI= 0 #dmmal.ini
ALTER_MODE_STATUS =1

5.重啟資料庫
systemctl stop DmServiceDMSERVER.service
systemctl start DmServiceDMSERVER.service

6.重置oguid並修改模式

SQL>alter database mount;
SQL>sp_set_oguid(0);
SQL>alter database normal;

SQL> select name,status$,mode$,OGUID from v$instance;

LINEID     name      status$ mode$  OGUID      
---------- --------- ------- ------ -----------
1          DAMENGBAK OPEN    NORMAL 0

used time: 0.590(ms). Execute id is 504.

相關文章