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

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 25 Sep 2007 13:07:34 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08FC6@EXCNYSM0A1AJ.nysemail.nyenet>

NLS settings may not apply to the "set" command.

According to the documentation:

Setting NLS_DATE_FORMAT and NLS_LANG

Before invoking RMAN, set the NLS_DATE_FORMAT and NLS_LANG environment variables. These variables determine the format used for the time parameters in RMAN commands such as RESTORE, RECOVER, and REPORT.

So it looks like it only applies to the commands listed above.

Tom

-----Original Message-----
From: dba1 mcc [mailto:mccdba1_at_yahoo.com] Sent: Tuesday, September 25, 2007 11:43 AM To: Mercadante, Thomas F (LABOR); oracle-l_at_freelists.org Subject: RE: [Q] RMAN "set until time" syntax ???

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 - 12:07:34 CDT