WAL中身確認

DB

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();

 

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

 

/usr/pgsql-9.4/bin/pg_xlogdump 00000001000000000000009E

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)