检查最近一次备份的状态 / 时间

Oracle

SELECT session_key, input_type, status,
       start_time, end_time,
       output_bytes_display
FROM v$rman_backup_job_details
ORDER BY start_time DESC
FETCH FIRST 10 ROWS ONLY;

RMAN 历史也可通过 RMAN> LIST BACKUP SUMMARY 查看。

PostgreSQL

-- WAL archiving health (for physical backup/PITR):
SELECT last_archived_wal, last_archived_time,
       failed_count, last_failed_time
FROM pg_stat_archiver;

逻辑（pg_dump）备份不会记录在数据库内；请检查备份工具/作业的日志。

MySQL

-- There is no built-in backup record; check the backup tool's log.
-- For the binlog-based PITR window:
SHOW BINARY LOGS;

SHOW BINARY LOGS 显示可用的 binlog 文件（PITR 窗口）；备份历史在工具（Xtrabackup 等）的日志中。

SQL Server

SELECT database_name,
       MAX(backup_finish_date) AS last_backup,
       CASE type WHEN 'D' THEN 'Full' WHEN 'I' THEN 'Diff'
                 WHEN 'L' THEN 'Log' END AS backup_type
FROM msdb.dbo.backupset
GROUP BY database_name, type
ORDER BY database_name;

msdb.dbo.backupset 记录 SQL Server 执行的每一次备份。

MongoDB

// There is no built-in backup record. PITR window = oplog duration:
rs.printReplicationInfo()  // oplog first/last event times

oplog 窗口决定了从副本集最多能往前做多久的 PITR；备份历史在工具的日志中。

Redis

INFO persistence
# check the rdb_last_save_time (epoch), rdb_last_bgsave_status,
# aof_last_bgrewrite_status lines

rdb_last_save_time 给出最近一次成功 RDB 保存的时间（Unix epoch）；rdb_changes_since_last_save 显示尚未备份的写入次数。