Re: [Q] RMAN "set until time" syntax ???

It's easiest to just do

set until time "to_date('2007-09-21:15:00:00','YYYY-MM-DD:HH24:MI:SS')";

Stefan

On 9/25/07, dba1 mcc <mccdba1_at_yahoo.com> wrote:
>
> We have ORACLE 10GR2 on LINUX server. I am testing
> RMAN function and found some syntax issue need help:
>
> If I use "set until time
> "to_date('2007-09-21:15:00:00','YYYY-MM-DD:hh24:mi:ss')";
> it work fine. But if I use "set until time
> '2007-09-21:15:00:00';", I have error. based on RMAN
> guide "set until time '2007-09-21:15:00:00';" should
> work.
>
> Anyone know why?
>
>
> =========== reference ===
> setenv NLS_LANG american_america.us7ascii
> setenv NLS_DATE_FORMAT 'YYYY-MM-DD:hh24:mi:ss'
>
> RMAN> run {
> 2> set until time '2007-09-21:15:00:00';
> 3> restore database;
> 4> }
>
> executing command: SET until clause
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK
> FOLLOWS ===============
> RMAN-00571:
> ===========================================================
> RMAN-03002: failure of set command at 09/25/2007
> 11:08:52
> ORA-01861: literal does not match format string
>
>
>
>
> ____________________________________________________________________________________
> Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated
> for today's economy) at Yahoo! Games.
> http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP SCSA SCNA
=========================

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