Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] RMAN "set until time" syntax ???
It has to do with your nls settings, however I find it always easier to
explicitly set the time using the to_date function rather than rely on nls
settings.
Ken
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of dba1 mcc
Sent: Tuesday, September 25, 2007 11:16 AM
To: oracle-l_at_freelists.org
Subject: [Q] RMAN "set until time" syntax ???
We have ORACLE 10GR2 on LINUX server. I am testing RMAN function and found some syntax issue need help:
If I use "set until time
"to_date('2007-09-21:15:00:00','YYYY-MM-DD:hh24:mi:ss')";
it work fine. But if I use "set until time
'2007-09-21:15:00:00';", I have error. based on RMAN
guide "set until time '2007-09-21:15:00:00';" should
work.
Anyone know why?
RMAN> run {
2> set until time '2007-09-21:15:00:00'; 3> restore database; 4> }
executing command: SET until clause
RMAN-00571:
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 25 2007 - 11:36:16 CDT