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

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Tue, 25 Sep 2007 11:31:20 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08FC5@EXCNYSM0A1AJ.nysemail.nyenet>

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

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

Received on Tue Sep 25 2007 - 10:31:20 CDT