RE: ORA-01861 on rman

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Friday, April 13, 2007 2:31 PM
To: Srini_Karla@xxxxxxxxxxxx
Cc: prabhu_adam@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: ORA-01861 on rman

 

On 4/13/07, Karla, Srini (HAS-SAT) <Srini_Karla@xxxxxxxxxxxx> 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

Other related posts: