注册

dmhs BUG: oracle11g源端日志路径,配置为USE_DB_RECOVERY_FILE_DEST时未查找下一级日期目录

Wisper 2023/02/25 1123 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8(目标端) oracle11g(源端)
【DMHS版本】DMHS console tool: V4.3.02-Build(2022.12.08-120188trunc)_64_2212
【操作系统】:centos 7.9
【CPU】:1
【问题描述】*:dmhs BUG: oracle11g源端日志路径,配置为USE_DB_RECOVERY_FILE_DEST时未查找下一级日期目录,希望能进行改进

oracle11g源端启动cpt报错:

DMHS> START cpt
CSL[ERROR]: 初始化日志分析模块失败

# dmhs报错找不到日志归档路径: [归档路径,少找了一个日志yyyy_mm_dd目录:如
/data/mydb/fra/MYDB/archivelog/2023_02_24]

2023-02-25 15:52:02 CPT[INFO]: ORA_V4.3.02_64
2023-02-25 15:52:02 CPT[ERROR]: 归档路径(/data/mydb/fra/MYDB1/archivelog)不存在
2023-02-25 15:52:02 MGR[ERROR]: 初始化日志分析模块失败
2023-02-25 15:52:02 MGR[ERROR]: ID号为90的日志分析模块启动失败

检查源端数据库配置[自动管理归档]

SYS@MYDB(mydb): 1> show parameter recover
NAME                                 TYPE            VALUE
------------------------------------ --------------- ------------------------------
db_recovery_file_dest                string          /data/mydb/fra
db_recovery_file_dest_size           big integer     4182M
SYS@MYDB(mydb): 1> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     18
Next log sequence to archive   20
Current log sequence           20
SYS@MYDB(mydb): 1> show parameter archive

NAME                                 TYPE            VALUE
------------------------------------ --------------- ------------------------------
archive_lag_target                   integer         0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
log_archive_dest_24                  string
log_archive_dest_25                  string
log_archive_dest_26                  string
log_archive_dest_27                  string
log_archive_dest_28                  string
log_archive_dest_29                  string
log_archive_dest_3                   string
log_archive_dest_30                  string
log_archive_dest_31                  string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string

SYS@MYDB(mydb): 1> select name from v$archived_log;

NAME
----------------------------------------------------------------------
/data/fra/mydb/MYDB/archivelog/2023_01_09/o1_mf_1_1_kvr7jhhd_.arc
/data/fra/mydb/MYDB/archivelog/2023_01_10/o1_mf_1_1_kvtfv0oh_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_11/o1_mf_1_2_kvwv5wpg_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_11/o1_mf_1_3_kvxj7x1q_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_16/o1_mf_1_4_kwbr45nj_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_16/o1_mf_1_5_kwbr5rc2_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_18/o1_mf_1_6_kwhyvvsk_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_18/o1_mf_1_7_kwhz1502_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_19/o1_mf_1_8_kwllpxwt_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_19/o1_mf_1_9_kwlm7oll_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_28/o1_mf_1_10_kx91b95n_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_28/o1_mf_1_11_kx9s05gt_.arc
/data/mydb/fra/MYDB/archivelog/2023_01_28/o1_mf_1_12_kx9s078k_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_20/o1_mf_1_13_kz6d95wr_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_21/o1_mf_1_14_kz897ft6_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_23/o1_mf_1_15_kzgwcmbk_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_23/o1_mf_1_16_kzgwcv08_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_24/o1_mf_1_17_kzj7f7vy_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_24/o1_mf_1_18_kzkjqm2c_.arc
/data/mydb/fra/MYDB/archivelog/2023_02_24/o1_mf_1_19_kzkjqt9j_.arc

替换解决方案

归档不能使用USE_DB_RECOVERY_FILE_DEST
alter system set log_archive_dest_1='location=/data/mydb/fra' scope=both sid='*';
SYS@MYDB(mydb): 1> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /data/mydb/fra
Oldest online log sequence     18
Next log sequence to archive   20
Current log sequence           20
# 切换一次归档
SYS@MYDB(mydb): 1> alter system archive log current;
System altered.

# dmhs重新启动cpt模块
DMHS> start cpt
执行成功
回答 0
暂无回答
扫一扫
联系客服