一、MySQL数据库
#查看是否开启日志及日志路径
show variables like'%log_bin%';
# 通过mysqlbinlog恢复删除的数据日志记录
# 将日志文件转换成mysqllog.sql
# /data/mysql/3306/binlog/mysql-bin.index为日志文件
mysqlbinlog --no-defaults --start-datetime='2022-08-24 14:16:00' --stop-datetime='2022-08-24 15:00:00' /data/mysql/3306/binlog/mysql-bin.index > /生成路径/mysqllog.sql
# 把mysqllog的DELETE转换为Insert语句
cat mysqllog.sql | sed -n '/###/p' | sed 's/### //g;s/\/\*.*/,/g;s/DELETE FROM/;INSERT INTO/g;s/WHERE/SELECT/g;' |sed -r 's/(@17.*),/\1;/g' | sed 's/@1=//g'| sed 's/@[1-9]=/,/g' | sed 's/@[1-9][0-9]=/,/g' > mysqllog_ins.sql
二、Oracle数据库
select * from s3_rtrecments as of timestamp to_timestamp('2022-08-24 14:16:00','yyyy-mm-dd hh24:mi:ss');