1、主库在线备份
BACKUP DATABASE BACKUPSET '/dmdb/dmbak/test01_20220105_1400';
2、先配置备机完全
备库各种参数配置好,然后按照普通的搭建步骤处理
RESTORE DATABASE '/dmdb/dmdata/test/dm.ini' FROM BACKUPSET '/dmdb/dmbak/test01_20220105_1400' ;
RECOVER DATABASE '/dmdb/dmdata/test/dm.ini' FROM BACKUPSET '/dmdb/dmbak/test01_20220105_1400';
RECOVER DATABASE '/dmdb/dmdata/test/dm.ini' UPDATE DB_MAGIC;
注意DmServiceGRP1服务配置的启动方式必须是启动到mount状态
DmServiceGRP1 start
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
select OGUID,MODE$ from v$instance;
sp_set_oguid(453331);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p GRP1 -watcher_ini /dmdb/dmdata/test/dmwatcher.ini
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmmonitor -p GRP1 -monitor_ini /dmdb/monitor/dmmonitor.ini
DmWatcherServiceGRP1 start
DmMonitorServiceGRP1 start
3、再配置主机
SP_SET_PARA_VALUE (2,'MAL_INI',1);
SP_SET_PARA_VALUE (2,'ALTER_MODE_STATUS',0);
SP_SET_PARA_VALUE (2,'ENABLE_OFFLINE_TS',2);
cat dm.ini |grep DMSERVER
sed -i 's/DMSERVER/test01/g' dm.ini
cat dm.ini |grep DMSERVER
cat dm.ini |grep test01
准备dm.ini、dmarch.ini、dmmal.ini参数文件
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
select OGUID,MODE$ from v$instance;
alter database mount;
sp_set_oguid(453331);
alter database primary;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DmServiceGRP1 stop
DmServiceGRP1 start
/home/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmwatcher -p GRP1 -watcher_ini /dmdb/dmdata/test/dmwatcher.ini
DmWatcherServiceGRP1 start