RE: ORA-01861 on rman
- From: "Karla, Srini \(HAS-SAT\)" <Srini_Karla@xxxxxxxxxxxx>
- To: <prabhu_adam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Apr 2007 12:00:13 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Prabhu, Krishnaswamy
Sent: Friday, April 13, 2007 10:32 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
