重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: RMAN查询数据文件的备份 [打印本页]

作者: Inkcup 时间: 2026-4-6 17:16
标题: RMAN查询数据文件的备份
R1. 按日期范围查询

rman target /

# 查询3月31日当天的备份
list backup of datafile 15 completed between '31-MAR-26' and '01-APR-26';

# 或者使用具体时间范围
list backup of datafile 15 completed after '30-MAR-26 23:59:59' and before '31-MAR-26 23:59:59';

# 查询包含3月31日备份的详细信息
list backup of datafile 15 completed after '31-MAR-26' detailed;

2. 查询备份摘要

# 查询备份摘要信息
list backup of datafile 15 summary;

# 查询备份集信息
list backup of datafile 15;

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)