RE: ORA-01861 on rman

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 13 Apr 2007 14:55:31 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08D14@EXCNYSM0A1AJ.nysemail.nyenet>

That's why I like (and always use) Chandra's example. Put this within the Rman script and it becomes a self-documenting recovery script:  

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

Easy to use and perfectly safe. And in 6 months when you look at this script again, it will be much easier to remember how it all worked.

Tom      

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Friday, April 13, 2007 2:31 PM
To: Srini_Karla_at_harcourt.com
Cc: prabhu_adam_at_hotmail.com; oracle-l_at_freelists.org Subject: Re: ORA-01861 on rman  

On 4/13/07, Karla, Srini (HAS-SAT) <Srini_Karla_at_harcourt.com> wrote:

        Set these environment variables before starting rman session.         

        NLS_DATE_FORMAT="YYYY-MM-DD:HH24:MI:SS" Maybe on Unix/Linux.

That won't work on Windows.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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

Received on Fri Apr 13 2007 - 13:55:31 CDT