DMDRS Oracel 19c ＜==＞ Dm8单机双向同步

最新推荐文章于 2025-10-21 22:09:11 发布

原创

最新推荐文章于 2025-10-21 22:09:11 发布 · 313 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#达梦数据库 #database

#DMDRS#

1. 配置19c==>Dm8单机单向同步

详细见文章《Oracle 19c==>DM8单机实时同步》

2. 配置Dm8==>19c 单向同步

2.1 Dm8配置

2.1.1 开启归档及逻辑日志

--检查归档
select arch_name,
       arch_type,
       arch_dest,
       arch_file_size,
       arch_space_limit,
       arch_is_valid,
       arch_incoming_path,
       arch_curr_dest
  from V$DM_ARCH_INI;
--检查逻辑日志
select para_name,para_value,DEFAULT_VALUE,DESCRIPTION from v$dm_ini where para_name='RLOG_APPEND_LOGIC';

--若归档没开启调整归档
alter database mount;
alter database add archivelog 'dest=/dm/arch,TYPE=local,FILE_SIZE=1024,SPACE_LIMIT=10240';
alter database archivelog;
alter database open;
--开启逻辑日志
call sp_set_para_value(1,'RLOG_APPEND_LOGIC',1);

配置结果

SQL> select para_name,para_value,DESCRIPTION from v$dm_ini where para_name='RLOG_APPEND_LOGIC';

行号     PARA_NAME         PARA_VALUE DESCRIPTION                       
---------- ----------------- ---------- ----------------------------------
1          RLOG_APPEND_LOGIC 1          Type of logic records in redo logs

已用时间: 7.897(毫秒). 执行号:242810.
SQL> select arch_name,
       arch_type,
       arch_dest,
       arch_file_size,
       arch_space_limit,
       arch_is_valid,
       arch_incoming_path,
       arch_curr_dest
  from V$DM_ARCH_INI;2   3   4   5   6   7   8   9   

行号     ARCH_NAME      ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT ARCH_IS_VALID ARCH_INCOMING_PATH ARCH_CURR_DEST
---------- -------------- --------- --------- -------------- ---------------- ------------- ------------------ --------------
1          ARCHIVE_LOCAL1 LOCAL

最低0.47元/天解锁文章