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