RE: RMAN restore command failed???

From: Amihay Gonen <>
Date: Thu, 30 Jun 2011 17:35:57 +0300
Message-ID: <>

To_date not to_data

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

From: D'Hooge Freek [] Sent: 30 June 2011 17:27
To:; 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: Errors-to: X-original-sender: Precedence: normal

List-help: <>
List-unsubscribe: <>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <>
X-List-ID: oracle-l <>
List-subscribe: <>
List-owner: <>
List-post: <>
List-archive: <>
X-list: oracle-l  

Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82
-----Original Message-----

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


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.

-- Received on Thu Jun 30 2011 - 09:35:57 CDT

Original text of this message