[Q] RMAN "set until time" syntax ???
- From: dba1 mcc <mccdba1@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 25 Sep 2007 08:15:31 -0700 (PDT)
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
____________________________________________________________________________________
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for
today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » [Q] RMAN "set until time" syntax ???
