RE: Duplicate database script truncates the time portion of set until time

  • From: Imtiaz Merchant <merchanti@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Oct 2011 17:08:33 -0400

Duh !! Never mind this post, resolved it by setting the NLS_DATE_FORMAT prior 
to getting into RMAN.

> From: merchanti@xxxxxxxxxxx
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Duplicate database script truncates the time portion of set until 
> time
> Date: Mon, 24 Oct 2011 16:40:18 -0400
> 
> I had a script that used to duplicate a prod database to a test environment 
> up until the last known backup using the --> set until time "to_date('some 
> date', 'dy Mon dd hh24:mi:ss yyyy')" option.  This used to work fine until 
> 10g, but after the upgrade to 11g, the time portion is somehow being chomped 
> off and i'm left with a duplicate database being attempted until the previous 
> day. 
> 
> Any thoughts or inputs would be appreciated from the list. 
>                                         
> --
> //www.freelists.org/webpage/oracle-l
> 
> 
                                          
--
//www.freelists.org/webpage/oracle-l


Other related posts: