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

From: Imtiaz Merchant <merchanti_at_hotmail.com>
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-l
Received on Mon Oct 24 2011 - 16:08:33 CDT

Original text of this message