备份列表
===============
关键字 TY LV S 设备类型 完成时间
段数 副本数 标记
------- -- -- - ----------- ------------------- ------- ------- ---
10125 BAA DISK2005-04-04 09:58:23 1 1 TAG20050404T095735
10328 BAA DISK2005-04-05 09:32:24 3 1 TAG20050405T092238
10500 BAA DISK2005-04-07 02:15:28 2 1 TAG20050407T021118
10591 BAA DISK2005-04-09 02:19:48 1 1 TAG20050409T021841
10664 BAA DISK2005-04-10 02:07:00 1 1 TAG20050410T020606
10736 BAA DISK2005-04-12 02:06:48 1 1 TAG20050412T020550
10880 BAA DISK2005-04-14 02:17:11 2 1 TAG20050414T021215
RMAN> report obsolete;
RMAN 保留策略将应用于该命令
将 RMAN 保留策略设置为 7 天的恢复窗口
已废弃的备份和副本报表
类型
关键字 完成时间 文件名/句柄
-------------------- ------ ------------------ --------------------
备份集
103872005-04-05 09:32:38
备份段 103882005-04-05 09:32:38 F:\RMANBACK\SPCTL\C-4036286469-20050405-00
RMAN>
怎么只报了个参数文件/控制文件的备份过时? [/B]
I am not sure the exact answer. but according to metalink 134214.1
RMAN not always use incremental backup if it has archivelog backup too.
" Let's use the following RECOVER command as an example:
RMAN> run{
2> allocate channel x type disk;
3> restore datafile 7;
4> recover datafile 7;
5> }
RMAN will first restore datafile 7 from the last incremental
level 0 backup. Then, it will evaluate its two options for the recovery.
One option is to restore incremental level backups that exist since the
last level 0, then finish up with any archivelogs that exist from the
last incremental backup to the current point in time. The second option is
to ignore the incremental backups and simply apply all archive logs from
the level 0 backup until the current point in time. RMAN evaluates both
options and chooses the path that will make recovery occur in the shortest
amount of time.
"
so maybe in this case, RMAN just keep the option open .
最初由 wing hong 发布
[B]
I am not sure the exact answer. but according to metalink 134214.1
RMAN not always use incremental backup if it has archivelog backup too.
" Let's use the following RECOVER command as an example:
RMAN> run{
2> allocate channel x type disk;
3> restore datafile 7;
4> recover datafile 7;
5> }
RMAN will first restore datafile 7 from the last incremental
level 0 backup. Then, it will evaluate its two options for the recovery.
One option is to restore incremental level backups that exist since the
last level 0, then finish up with any archivelogs that exist from the
last incremental backup to the current point in time. The second option is
to ignore the incremental backups and simply apply all archive logs from
the level 0 backup until the current point in time. RMAN evaluates both
options and chooses the path that will make recovery occur in the shortest
amount of time.
"
so maybe in this case, RMAN just keep the option open . [/B]