RMAN - report命令小结

最新推荐文章于 2022-12-02 16:54:21 发布

转载最新推荐文章于 2022-12-02 16:54:21 发布

· 268 阅读

文章标签：

本文介绍了RMAN中用于检查备份和恢复策略的report命令的几种用法，包括report need backup、report unrecoverable和report obsolete等，并展示了如何指定不同的条件进行更精确的备份需求分析。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

RMAN使用report命令来检查备份和恢复策略是否满足数据库恢复的要求，report命令主要有几个用法
- - report need backup 根据备份策略报告需要backup的数据文件
- - report unrecoverable 报告因数据已更改需要backup的数据文件
- - report obsolete 报告过期备份文件

点击(此处)折叠或打开

RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1 0 +DATA/mhxy/datafile/system.256.908824039
RMAN> report unrecoverable;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------
5 full +DATA/mhxy/datafile/example.264.908824295
RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found

RMAN>

另外的情况是，report命令可以指定不同的条件，比如冗余的分数redundancy n、恢复窗口的时间 recovery window of n days、归档日志时间days n以及增量备份 incremental n

点击(此处)折叠或打开

REPORT NEED BACKUP RECOVERY WINDOW OFn DAYS
Displays objects requiring backup to satisfy a recovery window-based retention policy.
REPORT NEED BACKUP REDUNDANCYn
Displays objects requiring backup to satisfy a redundancy-based retention policy.
REPORT NEED BACKUP DAYS = n
Displays files that require more than n days
REPORT NEED BACKUP INCREMENTAL n
Displays files that require application of more than n incremental backups for recovery.

对数据文件和表空间使用report need backup命令

点击(此处)折叠或打开

RMAN> REPORT NEED BACKUP RECOVERY WINDOW OF 2 DAYS DATABASE SKIP TABLESPACE MOJO01;
RMAN> REPORT NEED BACKUP REDUNDANCY 2 DATAFILE 1;
RMAN> REPORT NEED BACKUP TABLESPACE TBS_3MOJO01; # uses configured retention policy
RMAN> REPORT NEED BACKUP INCREMENTAL 2; # checks entire database