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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dba1 mcc Sent: Tuesday, September 25, 2007 11:16 AM To: oracle-l@xxxxxxxxxxxxx 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? =========== reference === setenv NLS_LANG american_america.us7ascii setenv NLS_DATE_FORMAT 'YYYY-MM-DD:hh24:mi:ss' RMAN> run { 2> set until time '2007-09-21:15:00:00'; 3> restore database; 4> } executing command: SET until clause RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at 09/25/2007 11:08:52 ORA-01861: literal does not match format string ____________________________________________________________________________ ________ Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l