请教rman 中关于delete archivelog 两种SQL语句的区别

不了峰

oracle 版本10.2.0.5

在rman中执行


DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
与
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7';
有什么区别？

ALL COMPLETED 表示的是？

谢谢！
这个ALL COMPLETED 是不是和data guard日志传输有关？

不了峰

文档：
Note: The UNTIL TIME clause is not the same as the COMPLETED BEFORE clause.
UNTIL TIME specifies logs that could be used to recover to the indicated time,
whereas COMPLETED BEFORE specifies logs that were created
before the indicated time (refer to "completedTimeSpec" on page 2-61).

是不是可以这样理解

假设 时间为2012-05-17 12:00:00
那么用 UNTIL TIME  表示届时可以用来恢复的归档日志时间是从 2012-05-17 12:00:00 开始

而用 COMPLETED BEFORE 是用来表示 归档日志 完成的时间

不知道这样讲对不对 ？

Maclean Liu(刘相兵

Archivelog Completed Before VS UNTIL TIME  http://www.oracledatabase12g.com ... -vs-until-time.html

不了峰

谢谢,讲得清清楚楚,实验的明明白白