RMAN: backup archivelog until time 'sysdate-2' delete input

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Mon, 11 Oct 2004 16:54:38 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F7051836DA@irv2kexch01>

Hi list,

It was "Mon Oct 11 16:12:07 CDT 2004" and I ran the following

RMAN> run {

2>      backup
3>       format '/oback/obckp/redo-logs/DV2_%s_%p.logs'
4>       archivelog until time 'sysdate-2' delete input;
5>     }

Since I specified "sysdate-2", I expected it only archive/delete up to "Oct 09 16:12:06". Was I right? But the truth is it archived/deleted redo file "1_1440.dbf", which was created between "Mon Oct 11 00:12:40 2004" and "Mon Oct 11 00:42:39 2004". WHY?

My last three redo files was:
.. .. ..

Sat Oct 9 06:23:22 2004
.. .. ..

Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/DV2/saparch/DV2arch/1_1439.dbf' Sat Oct 9 06:23:34 2004
.. .. ..

Mon Oct 11 00:12:40 2004
.. .. ..

Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/DV2/saparch/DV2arch/1_1440.dbf'
.. .. ..

Mon Oct 11 00:42:39 2004
.. .. ..

Mon Oct 11 15:39:37 2004
.. .. ..

Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/DV2/saparch/DV2arch/1_1441.dbf' Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.

This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 11 2004 - 16:50:34 CDT