Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01861 on rman

RE: ORA-01861 on rman

From: Pabba, Chandra <Chandra.Pabba_at_fmr.com>
Date: Fri, 13 Apr 2007 10:54:45 -0500
Message-ID: <6D2375ACD32D9B48A9B433AA0527B0840640FA69@MSGDCCCLA2WIN.DMN1.FMR.COM>


Prabhu,

Trying using the following syntax for the UNTILE TIME clause:

UNTIL TIME="to_date('13-04-2007:10:00:00', 'dd-mm-yyyy:hh24:mi:ss')";  

HTH Thanks
Chandra Pabba

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prabhu, Krishnaswamy Sent: Friday, April 13, 2007 10:32 AM
To: oracle-l_at_freelists.org
Subject: ORA-01861 on rman

Hi List,

We are getting the following error when we tried to do time based recovery.
Can anyone help us to resolve the same.

RMAN> run{
SET UNTIL TIME '2007-04-11:09:29:00';
restore database;
recover database;
}
2> 3> 4> 5>
executing command: SET until clause

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 04/13/2007 07:10:52 ORA-01861: literal does not match format string

Thanks
Prabhu



Free & easy posting . Yello Classifieds. http://www.yello.in/home.php?utm_source=hotmailtag&utm_medium=textlink&u tm_content=in&utm_campaign=april

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 13 2007 - 10:54:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US