RE: RMAN restore command failed???

From: <rajendra.pande_at_ubs.com>
Date: Thu, 30 Jun 2011 10:21:50 -0400
Message-ID: <D4C8B99EB96F2C42B4E19A3B87664F5E01C1FECC_at_NSTMC612PEX.ubsamericas.net>

to_data??

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Thursday, June 30, 2011 10:19 AM
To: oracle-l_at_freelists.org
Subject: RMAN restore command failed???

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
--

http://www.freelists.org/webpage/oracle-l

Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html for important disclosures and information about our e-mail policies. For your protection, please do not transmit orders or instructions by e-mail or include account numbers, Social Security numbers, credit card numbers, passwords, or other personal information.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 30 2011 - 09:21:50 CDT