RE: ORA-01861 on rman

From: Karla, Srini \(HAS-SAT\) <Srini_Karla_at_harcourt.com>
Date: Fri, 13 Apr 2007 12:00:13 -0500
Message-ID: <A2B00E685298CF4E8D1E5288432D025E0355CF65@HASSATEXCP07VA.edu.regn.net>

Set these environment variables before starting rman session.

NLS_LANG=AMERICAN_AMERICA.US7ASCII -- set your NLS_LANG value. NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS" Thanks,
Srini Karla
Sr. Database Administrator,
Harcourt Assessments, Inc.,
San Antonio, TX 78259

210-339-5252 work
210-683-3936 cell


---------------------------------------------------

Our Sharepoint: http://hassatappp022/sites/epa/ea/default.aspx


---------------------------------------------------

-----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 - 12:00:13 CDT