Prabhu, Trying using the following syntax for the UNTILE TIME clause: UNTIL TIME="to_date('13-04-2007:10:00:00', 'dd-mm-yyyy:hh24:mi:ss')"; HTH Thanks Chandra Pabba -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prabhu, Krishnaswamy Sent: Friday, April 13, 2007 10:32 AM To: oracle-l@xxxxxxxxxxxxx Subject: ORA-01861 on rman Hi List, We are getting the following error when we tried to do time based recovery. Can anyone help us to resolve the same. RMAN> run{ SET UNTIL TIME '2007-04-11:09:29:00'; restore database; recover database; } 2> 3> 4> 5> executing command: SET until clause RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at 04/13/2007 07:10:52 ORA-01861: literal does not match format string Thanks Prabhu _________________________________________________________________ Free & easy posting . Yello Classifieds. http://www.yello.in/home.php?utm_source=hotmailtag&utm_medium=textlink&u tm_content=in&utm_campaign=april -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l