RE: Duplicate database script truncates the time portion of set until time
Date: Mon, 24 Oct 2011 17:08:33 -0400
Message-ID: <BAY154-W337F4B12C9AD46819435D1ACEF0_at_phx.gbl>
Duh !! Never mind this post, resolved it by setting the NLS_DATE_FORMAT prior to getting into RMAN.
> From: merchanti_at_hotmail.com
> To: oracle-l_at_freelists.org
> 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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 24 2011 - 16:08:33 CDT