达梦数据库归档日志分析
- 修改dm.ini文件
ARCH_INI=1
RLOG_APPEND_LOGIC=1
sql_trace_mask=2:3:23:25 - 编辑dmarch.ini文件
- 重启数据库
select * from v$archived_log;
select * from V$logmnr_contents;
select * from v$logmnr_logs;
call dbms_logmnr.end_logmnr();
call dbms_logmnr.add_logfile
('C:\SoftHome\Dameng\data\A\arch\ARCHIVE_LOCAL_20191203123144631_1.log');
Call dbms_logmnr.start_logmnr(
options => 2128
,starttime=> to_date('2019-12-03 11:20:39','yyyy-mm-dd hh24:mi:ss')
);
select sql_redo,timestamp from V$logmnr_contents
where sql_redo like '%create%'
and seg_owner = 'REDE'
order by timestamp desc;
call dbms_logmnr.end_logmnr();
C:\Windows\system32>C:\SoftHome\Dameng\bin\dmrachk.exe arch_fil=C:\Users\Adminis
trator\Desktop\ARCHIVE_LOCAL1_20191203112702329_0\ARCHIVE_LOCAL1_201912031127023
29_0.log
C:\Windows\system32>C:\SoftHome\Dameng\bin\dmmdf.exe FILE=C:\SoftHome\Dameng\dat
a\A\A02.log TYPE=2
1553066961
2058417526
C:\Windows\system32>C:\SoftHome\Dameng\bin\dmmdf.exe TYPE=7 FILE=C:\Users\Admini
strator\Desktop\ARCHIVE_LOCAL1_20191203112702329_0 DB_MAGIC_SRC=2058417526 DB_MA
GIC_DST=1553066961
dmmdf V7.1.5.158-Build(2017.02.13-77698)ENT
modify file C:\Users\Administrator\Desktop\ARCHIVE_LOCAL1_20191203112702329_0\AR
CHIVE_LOCAL1_20191203112702329_0.log db_magic success.