Re: [Q] RMAN "set until time" syntax ???
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Tue, 25 Sep 2007 19:17:17 +0200
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@xxxxxxxxx> 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
> --
> //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@xxxxxxxxxxxx
http://www.trivadis.com
OCP SCSA SCNA
=========================
Other related posts:
