Re: Ergh..banging head against a wall here (sqlplus...recover..until time...sysdate)
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: ChrisDavid.Taylor@xxxxxxxxxxxxxxx, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 03 Aug 2010 22:19:58 +0800
Subtract the minutes from sysdate *before* formatting and then wrap a to_date
until time to_date(to_char(sysdate-5/1440,'YYYY-DD-MM:HH24:MI:SS'));
At 09:59 PM Tuesday, Taylor, Chris David wrote:
Ok, I'm trying to setup an automated job to recover a database
within sqlplus. Everything works fine until I try to add an "UNTIL
TIME" with SYSDATE. Is there no way to configure UNTIL TIME with SYSDATE?
This works:
SQL> recover database using backup controlfile until time
'2010-02-08:08:54:00';
Here's what I'm trying (and need) to do:
/* sysdate -5 minutes */
SQL> recover database using backup controlfile until time
to_char(sysdate,'YYYY-DD-MM:HH24:MI:SS')-5/1440;
ORA-00285: TIME not given as a string constant
Hemant K Chitale
http://hemantoracledba.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
