might be: to_data should be : to_date Med venlig hilsen Lenn Mikkelsen Senior Consultant - Miracle Premium Services Miracle A/S Borupvang 2C 2750 Ballerup Mobil: +45 53 74 71 08 Den 30/06/2011 kl. 16.18 skrev dba1 mcc: > any one know why this restore command failed??? > > RMAN> restore controlfile from autobackup until time "to_data('06/28/11 > 01:11:00','mm/dd/yy hh24:mi:ss')"; > > Starting restore at 30-JUN-11 > using channel ORA_DISK_1 > using channel ORA_DISK_2 > > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03002: failure of restore command at 06/30/2011 10:03:27 > ORA-00907: missing right parenthesis > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l