Jack,
Your date format is
set until time 'to_date(''29012002094700'',''ddmmyyyyhh24miss'')';
whereas one that works for me and matches the documentation is
set until time "to_date('18-SEP-2001 01:00:00','dd-mon-YYYY HH24:MI:SS')";
Note the difference in quotation marks which is what the RMAN error message refers to
Try my format and see what happens
HTH
John
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 14:25
To: Multiple recipients of list ORACLE-L
Subject: RE: Rman again. Long screen output included
Hi,
That only works if the format mask is set correctly, ergo not very
flexible.
Jack
אדר יחיאל <[EMAIL PROTECTED]>@fatcity.com on 29-01-2002 14:15:22
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Subject: RE: Rman again. Long screen output included
Hello Jack
The RMAN command recover database;
is changed to be recover database until time '1999-03-05:11:33:00';
=========================================================
This electronic message contains information from the mmO2 plc Group
which may be privileged or confidential. The information is intended to be
for the use of the individual(s) or entity named above. If you are not the
intended recipient be aware that any disclosure, copying, distribution or
use of the contents of this information is prohibited. If you have received
this electronic message in error, please notify us by telephone or email
(to the numbers or address above) immediately.
=========================================================
