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

  • From: "Ken Naim" <kennaim@xxxxxxxxx>
  • To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 25 Sep 2007 12:36:16 -0400

It has to do with your nls settings, however I find it always easier to
explicitly set the time using the to_date function rather than rely on nls


-----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
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

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-00569: =============== ERROR MESSAGE STACK
FOLLOWS ===============
RMAN-03002: failure of set command at 09/25/2007
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.  


Other related posts: