| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
-----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
NOTICE This e-mail and any attachments are private and confidential and may contain privileged information.
If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments.
This notice should not be removed.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 12 2004 - 16:32:26 CDT
 |
 |