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
I did backup archivelogs to disk Roger. I did find that the same
confusion you have found.=20
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.
Note: before you do that command ...make sure you do this one..
sql 'alter system archive log current';
Brian
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
Sent: Tuesday, October 12, 2004 8:52 AM
To: roger_xu_at_dp7uptx.com; Oracle-L_at_Freelists. Org (E-mail)
Subject: RE: RMAN: backup archivelog until time 'sysdate-2' delete input
Roger - I don't see where you mentioned your Oracle version. RMAN has been notorious for being picky about the date format. I've generally heard of this in terms of recovery times and with Oracle 8i. Since I back up RMAN to disk, I don't use RMAN to backup the archive logs, so I haven't encountered this specific problem. Looking at Freeman's great Oracle9i Backup and Recovery, he uses the syntax:
'backup archivelog from time 'sysdate - 1';
Dennis Williams
DBA
Lifetouch, Inc.
-----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,
=20
It was "Mon Oct 11 16:12:07 CDT 2004" and I ran the following
=20
RMAN> run {
2> backup 3> format '/oback/obckp/redo-logs/DV2_%s_%p.logs' 4> archivelog until time 'sysdate-2' delete input; 5> }
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.=20
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 12 2004 - 08:41:53 CDT
![]() |
![]() |