为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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时未查找下一级日期目录,希望能进行改进
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
执行成功