RE: RMAN: backup archivelog until time 'sysdate-2' delete input
- From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
- To: "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Oct 2004 08:36:51 +1100
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@xxxxxxxxxxxxxxxxx]
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.
__________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
