RE: RMAN restore command failed???

From: Amihay Gonen <Amihay.Gonen_at_ecitele.com>
Date: Thu, 30 Jun 2011 17:35:57 +0300
Message-ID: <5BB479729855824B9A8B9724F455F70E01302BC7845B_at_ILPTMAIL02.ecitele.com>

To_date not to_data

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

From: D'Hooge Freek [mailto:Freek.DHooge_at_uptime.be] Sent: 30 June 2011 17:27
To: mccdba1_at_yahoo.com; oracle-l_at_freelists.org Subject: RE: RMAN restore command failed???

Possible typo: to_data instead of to_date X-archive-position: 37172
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce_at_freelists.org Errors-to: oracle-l-bounce_at_freelists.org X-original-sender: Freek.DHooge_at_uptime.be Precedence: normal
Reply-To: Freek.DHooge_at_uptime.be

List-help: <mailto:ecartis_at_freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request_at_freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>

X-List-ID: oracle-l <oracle-l.freelists.org>

List-subscribe: <oracle-l-request_at_freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams_at_ixora.com.au>
List-post: <mailto:oracle-l_at_freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>

X-list: oracle-l  

Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: donderdag 30 juni 2011 16:19
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

--

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

This e-mail message is intended for the recipient only and contains information which is CONFIDENTIAL and which may be proprietary to ECI Telecom. If you have received this transmission in error, please inform us by e-mail, phone or fax, and then delete the original and all copies thereof.

--

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