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

From: Roger Xu <roger_xu_at_dp7uptx.com>
Date: Tue, 12 Oct 2004 17:11:29 -0500
Message-ID: <A6801E8A03316A4DA597866F77A013F702D4F1E5@irv2kexch01>

Oops! You are right, Bruce. Thanks.
Now, I think I know why:

2004-10-09 06:23 redo log file 1_1439.dbf closed and archived

2004-10-09 16:12 <---- here is the later 'sysdate-2'( say, SCN XYZ)

2004-10-10 only a few activities

2004-10-11 00:42 redo log file 1_1440.dbf closed and archived

2004-10-11 15:39 redo log file 1_1441.dbf closed and archived

2004-10-11 16:12 I told RMAN to backup archivelog until time 'sysdate-2' delete input RMAN did backup and delete upto SCN XYZ, which was in 1_1440.dbf. That's why 1_1440.dbf was deleted, even it was closed in 2004-10-11, same day I ran RMAN backup/delete archivelog.

-----Original Message-----
From: Reardon, Bruce (CALBBAY)
[ mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: Tuesday, October 12, 2004 4:37 PM
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: RE: RMAN: backup archivelog until time 'sysdate-2' delete input

Roger,
Try using MI as the minute format rather than MM (which is 2 digit month) HTH,
Bruce Reardon

-----Original Message-----
From: Roger Xu
Sent: Wednesday, 13 October 2004 7:21 AM Subject: RE: RMAN: backup archivelog until time 'sysdate-2' delete input

'sysdate -2' is different from what I thought it was! Thanks, Brian. SQL> !date
Tue Oct 12 15:20:40 CDT 2004
SQL> select to_char(sysdate-2,'DD-MON-YYYY HH24:MM:SS') from dual; TO_CHAR(SYSDATE-2,'D

10-OCT-2004 15:10:42
SQL> !date
Tue Oct 12 15:20:45 CDT 2004

-----Original Message-----
From: Spears, Brian [ mailto:BSpears_at_Limitedbrands.com] Sent: Tuesday, October 12, 2004 8:41 AM
Subject: RE: RMAN: backup archivelog until time 'sysdate-2' delete input ...
I used select to_char(sysdate-2,'DD-MON-YY:HH.MM.SS') from dual; when it was run to make sure it was the time range I expected. ...
Brian
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [ mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu
Sent: Monday, October 11, 2004 4:55 PM
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: RMAN: backup archivelog until time 'sysdate-2' delete input

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'

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 Tue Oct 12 2004 - 17:07:34 CDT