It's easiest to just do set until time "to_date('2007-09-21:15:00:00','YYYY-MM-DD:HH24:MI:SS')"; Stefan On 9/25/07, dba1 mcc <mccdba1@xxxxxxxxx> wrote: > > 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 > > > -- ========================= Stefan P Knecht Consultant Infrastructure Managed Services Trivadis AG Europa-Strasse 5 CH-8152 Glattbrugg Phone +41-44-808 70 20 Fax +41-808 70 12 Mobile +41-79-571 36 27 stefan.knecht@xxxxxxxxxxxx http://www.trivadis.com OCP SCSA SCNA =========================