WAL中身確認

• Oracle

LogMiner

https://docs.oracle.com/cd/E57425_01/121/SUTIL/GUID-40619B3B-8BDF-4D90-B924-5A0F8A631F98.htm

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

SELECT NAME FROM V$ARCHIVED_LOG
WHERE FIRST_TIME = (SELECT MAX(FIRST_TIME) FROM V$ARCHIVED_LOG);

EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => '/u01/app/oracle/oradata/orcl/1_31_997959341.dbf', -
OPTIONS => DBMS_LOGMNR.NEW);

EXECUTE DBMS_LOGMNR.START_LOGMNR( -
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID,
SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS WHERE username IN ('TEST');

EXECUTE DBMS_LOGMNR.END_LOGMNR();

 

• MySQL

--バイナリログの中身確認
mysqlbinlog mysql-bin-log.000069
--バイナリログの中身確認(SQL文も出力)
mysqlbinlog -v mysql-bin-log.000069

 

• PostgreSQL

(17)

cd /var/lib/pgsql/17/data/pg_wal
ls -ltr

select pg_switch_wal();

/usr/pgsql-17/bin/pg_waldump 000000020000000000000009

/usr/pgsql-17/bin/pg_walsummary /var/lib/pgsql/17/data/pg_wal/summaries/0000000200000000090000280000000009001B90.summary

 

 

 

• SQL Server

https://blog.engineer-memo.com/2011/10/26/%E3%83%88%E3%83%A9%E3%83%B3%E3%82%B6%E3%82%AF%E3%82%B7%E3%83%A7%E3%83%B3%E3%83%AD%E3%82%B0%E3%81%AE%E3%83%90%E3%83%83%E3%82%AF%E3%82%A2%E3%83%83%E3%83%97%E3%81%8B%E3%82%89%E3%83%AD%E3%82%B0%E3%83%AC/

--トランザクションログの内容を確認
select * from sys.fn_dblog(NULL,NULL)

--トランザクションログのバックアップから内容を確認
SELECT * FROM sys.fn_dump_dblog(NULL, NULL, NULL, 1
, N'C:\test\log20190323'
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
, NULL, NULL, NULL)