数据误删（delete）后恢复

一、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');