RE: [Q] RMAN "set until time" syntax ???
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: "dba1 mcc" <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 Sep 2007 13:07:34 -0400
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@xxxxxxxxx]
Sent: Tuesday, September 25, 2007 11:43 AM
To: Mercadante, Thomas F (LABOR); oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> dba1 mcc
> Sent: Tuesday, September 25, 2007 11:16 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
