主备搭建
步骤一:主机脱机备份
进入dmrman
BACKUP DATABASE ‘/home/dmdba/dmdbms/data/AR_1/dm.ini’ FULL BACKUPSET ‘/home/dmdba/bak/fullbak1’;
步骤二:备机还原恢复更新db_magic
进入dmrman
restore database ‘/home/dmdba/dmdbms/dmdata/AR_2/dm.ini’ from backupset ‘/home/dmdba/bak/fullbak1’
recover database ‘/home/dmdba/dmdbms/dmdata/AR_2/dm.ini’ from backupset ‘/home/dmdba/bak/fullbak1’
recover database ‘/home/dmdba/dmdbms/dmdata/AR_2/dm.ini’ update db_magic;
步骤三:以前台方式启动数据库服务(mount状态启动)
主机前台启动
./dmserver …/data/AR_1/dm.ini mount
备机前台启动
./dmserver /home/dmdba/dmdbms/dmdata/AR_2/dm.ini mount
查询主备机lsn号和永久魔数是否一致
select file_lsn,cur_lsn from v$rlog;
select permanent_magic;
主机
备机
步骤四:配置文件
dm.ini
主机的
dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = AR
MAL_HOST = 10.10.10.7
MAL_PORT = 61141
MAL_INST_HOST = 192.168.152.133
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT=33141
[MAL_INST2]
MAL_INST_NAME = AR_2
MAL_HOST = 10.10.10.8
MAL_PORT = 61142
MAL_INST_HOST = 192.168.152.134
MAL_INST_PORT = 5237
MAL_DW_PORT = 52142
MAL_INST_DW_PORT=33142
dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = AR_2
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmdbms/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 10240
dmwatcher.ini
[GROUP_A]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /home/dmdba/dmdbms/data/AR_1/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver
备库文件配置
dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = AR
MAL_HOST = 10.10.10.7
MAL_PORT = 61141
MAL_INST_HOST = 192.168.152.133
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT=33141
[MAL_INST2]
MAL_INST_NAME = AR_2
MAL_HOST = 10.10.10.8
MAL_PORT = 61142
MAL_INST_HOST = 192.168.152.134
MAL_INST_PORT = 5237
MAL_DW_PORT = 52142
MAL_INST_DW_PORT=33142
dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = AR
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmdbms/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 10240
dmwatcher.ini
[GROUP_A]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /home/dmdba/dmdbms/dmdata/AR_2/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver
dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /home/dmdba/dmdbms/dmdata/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT =0
[GROUP_A]
MON_INST_OGUID =453331
MON_DW_IP = 10.10.10.7:52141
MON_DW_IP = 10.10.10.8:52142
监听器可以放在备库上
主机修改完dm.ini,dmmal.ini,dmwatcher.ini, dmarch.ini参数后
回到bin目录
前台启动数据库服务
./dmserver …/data/AR_1/dm.ini mount
然后进入disql
设置OGUID值
sp_set_oguid(453331);
把主库修改数据库模式为PRIMARY
alter database primary;
把备库修改数据库模式为STANDBY
alter database standby;
查看主备数据库信息
• 查看归档信息
• SQL>select arch_mode from v$database;
• 查看归档日志信息
• SQL>select arch_name,arch_type,arch_dest from v$DM_arch_ini;
• 查看OGUID
• SQL>select oguid from v$instance;
·查看MAL系统信息(全局)
·SQL>select * from v$DM_mal_ini;
主机注册守护进程服务
./dm_service_installer.sh -t dmwatcher -p AR -watcher_ini /home/dmdba/dmdbms/data/AR_1/dmwatcher.ini
备机
./dm_service_installer.sh -t dmwatcher -p AR_2 -watcher_ini /home/dmdba/dmdbms/data/AR_2/dmwatcher.ini
启动守护进程服务
主机
./DmWatcherServiceAR start
备机
./DmWatcherServiceAR_2 start
开启监听
./dmmonitor /home/dmdba/dmdbms/dmdata/AR_2/dmmonitor.ini
守护集群配置完成