目录
三、配置后台启动实例,进行数据库参数优化(两个节点操作一致)
一、安装DM8数据库
具体安装步骤查看下面链接,这里不再赘述
二、初始化实例
DW0
dminit PATH=/dmdata page_size=16 charset=0 log_size=2048 db_name=DAMENG instance_name=DW0
DW1
dminit PATH=/dmdata page_size=16 charset=0 log_size=2048 db_name=DAMENG instance_name=DW1
三、配置后台启动实例,进行数据库参数优化(两个节点操作一致)
cp -p /dm8/bin/service_template/DmService /dm8/bin/DmService
vim /dm8/bin/DmService
INI_PATH=/dmdata/DAMENG/dm.ini
DmService start
disql SYSDBA/SYSDBA
四、脱机备份还原数据库
DW0备份
查看DMAP服务是否启动
ps -ef|grep dmap
若未启动则须先启动DMAP服务
DmAPService start
关闭数据库服务
DmService stop
开始脱机备份
backup database '/dmdata/DAMENG/dm.ini' backupset '/home/dmdba/bakfull';
将备份集拷贝到DW1
scp -r /home/dmdba/bakfull dmdba@192.168.208.88:/home/dmdba/bakfull
DW1还原
实例服务关闭并打开dmrman
restore database '/dmdata/DAMENG/dm.ini' from backupset '/dmbak/bakfull';
recover database '/dmdata/DAMENG/dm.ini' from backupset '/home/dmdba/bakfull';
recover database '/dmdata/DAMENG/dm.ini' update db_magic;
五、修改dm.ini参数(两个节点相同)
vim /dmdata/DAMENG/dm.ini
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
六、配置归档dmarch.ini(两个节点不同)
DW0
vim /dmdata/DAMENG/dmarch.ini
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME
ARCH_DEST = dw1
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmarch
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 102400
DW1
vim /dmdata/DAMENG/dmarch.ini
[ARCHIVE_REALTIME1]
ARCH_TYPE = REALTIME
ARCH_DEST = dw0
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmarch
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 102400
七、配置mal文件dmmal.ini(两个节点相同)
如果可以的话建议使用两张网卡,一个对外一个对内。
vim /dmdata/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 15
[MAL_INST1]
MAL_INST_NAME = dw0
MAL_HOST = 192.168.208.87
MAL_PORT = 7336
MAL_INST_HOST = 192.168.208.87
MAL_INST_PORT = 5236
MAL_DW_PORT = 7536
MAL_INST_DW_PORT = 7436
[MAL_INST2]
MAL_INST_NAME = dw1
MAL_HOST = 192.168.208.88
MAL_PORT = 7336
MAL_INST_HOST = 192.168.208.88
MAL_INST_PORT = 5236
MAL_DW_PORT = 7536
MAL_INST_DW_PORT = 7436
八、配置守护进程dmwatcher.ini(两个节点相同)
vim /dmdata/DAMENG/dmwatcher.ini
[GRP_DW]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 30
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 20
INST_OGUID = 453331
INST_INI = /dmdata/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
九、修改主备库状态与oguid(两个节点不同)
修改后台启动参数,并后台启动服务到mount状态
DW0
vim /dm8/bin/DmService
START_MODE=mount
DmService start
disql SYSDBA/SYSDBA
sp_set_oguid(453331);
alter database primary;
DW1
同样修改后台启动文件
vim /dm8/bin/DmService
START_MODE=mount
DmService start
disql SYSDBA/SYSDBA
sp_set_oguid(453331);
alter database standby;
十、修改守护进程后台启动(两个节点相同)
cp -p /dm8/bin/service_template/DmWatcherService /dm8/bin/DmWatcherService
vim /dm8/bin/DmWatcherService
INI_PATH=/dmdata/DAMENG/dmwatcher.ini
十一、配置sql日志(两个节点相同)
vim /dmdata/DAMENG/sqllog.ini
BUF_TOTAL_SIZE = 10240
BUF_SIZE = 1024
BUF_KEEP_CNT = 6
[SLOG_ALL]
FILE_PATH = ../log
PART_STOR = 1
SWITCH_MODE = 2
SWITCH_LIMIT = 512
ASYNC_FLUSH = 1
FILE_NUM = 5
ITEMS = 0
SQL_TRACE_MASK = 7:14:15:22:24:25:26:27:28
MIN_EXEC_TIME = 1500
USER_MODE = 0
USERS =
十二、启动守护进程(两个节点都启动)
DmWatcherService start
十三、启动监视器进程
如果条件允许建议放在第三台机,同样需要安装达梦数据库,但不需要初始化实例,我这里将监视器放在主库这边
vim /dmdata/DAMENG/dmmonitor.ini
MON_DW_CONFIRM = 0
MON_LOG_PATH = /dm8/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 200
MON_LOG_SPACE_LIMIT = 1024
[GRP_DW]
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.208.87:7536
MON_DW_IP = 192.168.208.88:7536
前台启动监视器
./dmmonitor /dmdata/DAMENG/dmmonitor.ini
配置后台启动
cp -p /dm8/bin/service_template/DmMonitorService /dm8/bin/DmMonitorService
vim /dm8/bin/DmMonitorService
INI_PATH=/dmdata/DAMENG/dmmonitor.ini
启动后到 /dm8/log查找监视器日志,其中守护进程状态 WSTATUS 为 OPEN,实例状态 ISTATUS 为 OPEN,归档类型 RTYPE 为 TIMELY,归档状态 RSTAT 为VALID。
更多资讯请到达梦社区地址了解: