RMAN> LIST INCARNATION OF DATABASE prod3;
RMAN> LIST INCARNATION OF DATABASE;
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- ------ ---------- ----------
1 1 RDBMS 774627068 PARENT 1 21-OCT-03
2 2 RDBMS 774627068 CURRENT 173832 21-OCT-03
www.ixdba.net
REPORT命令
报告需要备份的文件：
我们首先要执行交叉校验，然后可以利用REPORT命令报告需要备份的，RMAN根据我们的备份保留策略来给出结果。
CROSSCHECK BACKUP; # crosschecks backup sets and proxy copies
CROSSCHECK COPY; # crosschecks only disk copies of archived redo logs,
datafiles and control file
RMAN>REPORT NEED BACKUP;
RMAN 保留策略将应用于该命令
将 RMAN 保留策略设置为冗余 1
文件冗余备份少于1个
文件 #bkps 名称
---- ----- -----------------------------------------------------
5 0 E:\ORACLE\ORADATA\ROME\TEST.DBF
我们也可以给出DAYS参数来按照我们的要求时间让RMAN给出需要备份的结果。如下例：
REPORT NEED BACKUP DAYS = 1 DATABASE; # needs min 1 days of logs to recover
REPORT NEED BACKUP DAYS = 10 TABLESPACE SYSTEM;
REPORT NEED BACKUP DAYS = 5 DATAFILE '…/tools01.dbf';
我们也可以报告那些文件需要进行增量备份：
REPORT NEED BACKUP INCREMENTAL = 1 DATABASE;
REPORT NEED BACKUP INCREMENTAL = 3 TABLESPACE SYSTEM;
REPORT NEED BACKUP INCREMENTAL = 5 DATAFILE '…/users01.dbf';
报告过期备份：
CROSSCHECK BACKUP;
# lists backups that not needed to recover the database to within last week
REPORT OBSOLETE RECOVERY WINDOW OF 7 DAYS;
# lists backups that are superfluous because more than 2 copies are on tape
REPORT OBSOLETE REDUNDANCY = 2 DEVICE TYPE sbt;
