アーカイブログのローテート

• MySQL

(8.4.0)

https://dev.mysql.com/doc/refman/8.4/en/flush.html

show binary logs;

flush logs;

※flush logs は下記と同様
FLUSH BINARY LOGS
FLUSH ENGINE LOGS
FLUSH ERROR LOGS
FLUSH GENERAL LOGS
FLUSH RELAY LOGS
FLUSH SLOW LOGS

• Oracle

(23c)

archive log list;

alter system archive log current;

SELECT SEQUENCE#,DEST_ID,STANDBY_DEST,ARCHIVED,APPLIED,DELETED,STATUS,COMPLETION_TIME,CREATOR,REGISTRAR
FROM V$ARCHIVED_LOG
ORDER BY SEQUENCE#,DEST_ID
;

• PostgreSQL

(16)

select pg_switch_wal();

ls -ltr /var/lib/pgsql/16/arc

• SQL Server

(2022)

https://learn.microsoft.com/ja-jp/sql/relational-databases/sql-server-transaction-log-architecture-and-management-guide?view=sql-server-ver16#Backups

トランザクション ログについて、
アーカイブの概念なし