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

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 25 Sep 2007 08:43:24 -0700 (PDT)
Message-ID: <496221.93131.qm@web60811.mail.yahoo.com>

Thanks for answer.

I change environment to "ksh" and setup variables. I still get same werror message.

• "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante_at_labor.state.ny.us> wrote:

> I don't use Linux, but this is obviously a mismatch
> of environmental
> variables.
>
> Instead of the "setenv" command, can you try:
>
> NLS_LANG=american_america.us7ascii
> export NLS_LANG
> NLS_DATE_FORMAT='YYYY-MM-DD:hh24:mi:ss'
> export NLS_DATE_FORMAT
>
> Tom
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> dba1 mcc
> Sent: Tuesday, September 25, 2007 11:16 AM
> To: oracle-l_at_freelists.org
> Subject: [Q] RMAN "set until time" syntax ???
>
> 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
>
>
>
>
       

---

Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC

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

Received on Tue Sep 25 2007 - 10:43:24 CDT