RE: Rman again. Long screen output removed

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Wed, 30 Jan 2002 01:39:47 -0800
Message-ID: <F001.0040013D.20020130012519@fatcity.com>

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: nlzanen1_at_EY.NL [mailto:nlzanen1_at_EY.NL] 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

××“×¨ ×™×—×™××œ <adary_at_mehish.co.il>@fatcity.com on 29-01-2002 14:15:22

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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.

Received on Wed Jan 30 2002 - 03:39:47 CST