数据守护简介

DM8守护集群 （类似于Oracle的DataGuard） 但是通过搭建过程 感觉 部署十分方便，搭建难度小于oracle的 DataGuard

其原理也是 操作系统平台、达梦版本相同的数据库 通过主库传输归档日志到备库，备库通过实时应用主库的归档日志，使主库和备份 数据实时同步。

开始备份

1、主库先备份全库

./dmrman BACKUP DATABASE '/dm8/data/DAMENG/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'

2、把主库备份文件传输到备库

scp *.* 192.168.218.128:/dm8/backup

3、备库恢复主库的备份

./dmrman RESTORE DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/backup'	

4、修改主库文件

dm.ini
        INSTANCE_NAME = DM01
        PORT_NUM = 5246
        DW_INACTIVE_INTERVAL = 60 
        ALTER_MODE_STATUS = 0 
        ENABLE_OFFLINE_TS = 2 
        MAL_INI = 1
        ARCH_INI = 1
        RLOG_SEND_APPLY_MON = 64
dmmal.ini
     	MAL_CHECK_INTERVAL = 5  # 邮件检查间隔的时间段
        MAL_CONN_FAIL_INTERVAL = 5 # 失败了再去重连的时间
        [MAL_INST1] 
        MAL_INST_NAME = DM01   #记住这个
        MAL_HOST = 1192.168.218.128
        MAL_PORT = 55101
        MAL_INST_HOST = 192.168.218.128  ##记住这个
        MAL_INST_PORT = 5236  ## 记住这个
        MAL_DW_PORT = 65101  #数据守护邮件系统的端口号
        MAL_INST_DW_PORT = 45101 #数据守护邮件实例的端口号
        [MAL_INST2] 
        MAL_INST_NAME = DM02
        MAL_HOST = 1192.168.218.129
        MAL_PORT = 55121 
        MAL_INST_HOST = 1192.168.218.129
        MAL_INST_PORT = 5236
        MAL_DW_PORT = 65121 
        MAL_INST_DW_PORT = 45121

dmarch.ini
            [ARCHIVE_REALTIME] 
            ARCH_TYPE = REALTIME
            ARCH_DEST = DM02#这个主库写备库备库写主库!
            [ARCHIVE_LOCAL1] 
            ARCH_TYPE = LOCAL
            ARCH_DEST = /dm8/arch#要保证有这个路径!
            ARCH_FILE_SIZE = 128
            ARCH_SPACE_LIMIT = 0
dmwatcher.ini
      	[GRP1]   #组名 每个节点上面的守护进程的组名都要一样！
        DW_TYPE = GLOBAL
        DW_MODE = AUTO 
        DW_ERROR_TIME = 10 
        INST_RECOVER_TIME = 60 
        INST_ERROR_TIME = 10 
        INST_OGUID = 0  #每个节点的这个值也是要一致！
        INST_INI = /dm8/data/DAMENG/dm.ini  
        INST_AUTO_RESTART = 1
        INST_STARTUP_CMD = /dm8/bin/dmserver 
        RLOG_SEND_THRESHOLD = 0  
        RLOG_APPLY_THRESHOLD = 0 

5、启动主库

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

6、通过disql修改配置

./disql sysdba/dameng123@192.168.218.128:5236
	SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
	SQL>sp_set_oguid(0); 
 	SQL>alter database primary;
	SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

7、修改备库

dm.ini
        INSTANCE_NAME = DM02
        PORT_NUM = 5246 
        DW_INACTIVE_INTERVAL = 60 
        ALTER_MODE_STATUS = 0  
        ENABLE_OFFLINE_TS = 2 
        MAL_INI = 1 
        ARCH_INI = 1  
        RLOG_SEND_APPLY_MON = 64 
        
     dmmal.ini
         MAL_CHECK_INTERVAL = 5 
         MAL_CONN_FAIL_INTERVAL = 5  
         [MAL_INST1] 
         MAL_INST_NAME = DM01
         MAL_HOST = 192.168.218.128
         MAL_PORT = 55101 
         MAL_INST_HOST = 192.168.218.128
         MAL_INST_PORT = 5236 
         MAL_DW_PORT = 65101  
         MAL_INST_DW_PORT = 45101 
         [MAL_INST2] 
         MAL_INST_NAME = DM02
         MAL_HOST = 192.168.218.129
         MAL_PORT = 55121 
         MAL_INST_HOST = 192.168.218.129
         MAL_INST_PORT = 5236 
         MAL_DW_PORT = 65121 
         MAL_INST_DW_PORT = 45121 
         
         
    dmarch.ini
        [ARCHIVE_REALTIME] 
        ARCH_TYPE = REALTIME 
        ARCH_DEST = DM01
        [ARCHIVE_LOCAL1] 
        ARCH_TYPE = LOCAL 
        ARCH_DEST = /dm8/arch  
        ARCH_FILE_SIZE = 128  
        ARCH_SPACE_LIMIT = 0 
    dmwatcher.ini
        [GRP1] 
        DW_TYPE = GLOBAL 
        DW_MODE = AUTO 
        DW_ERROR_TIME = 10 
        INST_RECOVER_TIME = 60 
        INST_ERROR_TIME = 10  
        INST_OGUID = 0
        INST_INI = /dm8/data/DAMENG/dm.ini 
        INST_AUTO_RESTART = 1
        INST_STARTUP_CMD = /dm8/bin/dmserver 
        RLOG_APPLY_THRESHOLD = 0 

8、以 Mount 方式启动备库

/dm8/bin/dmserver /dm8/data/DAMENG/dm.ini mount

9、通过disql修改备库参数

./disql sysdba/dameng123@192.168.218.129:5236
	SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
    	SQL>sp_set_oguid(0); 
    	SQL>alter database standby; 
    	SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

10、启动主库的守护进程

/dm8/bin/dmwatch /dm8/data/DAMENG/dmwatcher.ini

11、启动备库守护进程

/dm8/bin/dmwatch /dm8/data/DAMENG/dmwatcher.ini

12、在监视器服务器上配置监视器

dmmonitor.ini
        MON_DW_CONFIRM = 1  #确定监视器
        MON_LOG_PATH = /dm8/data/log  #监视器日志
        MON_LOG_INTERVAL = 60 
        MON_LOG_FILE_SIZE = 32 
        MON_LOG_SPACE_LIMIT = 0 
        [GRP1] 
        MON_INST_OGUID = 0
        MON_DW_IP = 192.168.218.128:65101 
        MON_DW_IP = 192.168.218.129:65121

13、启动监视器

/dm8/bin/dmmonitor /dm8/data/DAMENG/dmmonitor.ini

14、手动注册到dm数据库中

注册到服务中，机器重启就会启动数据守护集群

14.1、注册主库

/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMWATCHER -watcher_ini /dm8/data/DAMENG/dmwatcher.ini

14.2、注册备库

/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMWATCHER -watcher_ini /dm8/data/DAMENG/dmwatcher.ini

14.3、注册监视器

/dm8/script/root/dm_service_installer.sh -t dmmonitor -p DMMONITOR -monitor_ini /dm8/data/DAMENG/dmmonitor.ini

至此，达梦数据守护集群搭建完毕，跟着一步一步的来会成功的。希望能够帮到你~

注意：配置的所有文件都在/dm8/data/DAMENG/目录下