Re: Duplicate from active database failing with ORA-19625 , ORA-27037 for archivelogs

Thanks, Mladen. The problem was that the duplicate was *not* copying all the required logs even though they existed on the primary server. Once I copied all logs manually, the duplicate was able to complete successfully.

On Sat, Feb 2, 2019 at 5:15 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 1/31/19 3:54 PM, Sandra Becker wrote:
>
> Q1: Why isn't the duplicate copying all the logs if they are on disk?
> Q2: Can I manually copy the logs before I start the duplicate?
> Q3: How can I find all the logs that I will need?
>
> Hi Sandy,
> I hope you stayed warm during the recent "polar vortex". Here are your
> answers:
> Q1) If you are doing duplicate database from the backup, that backup has
> its time. Nothing newer than that backup time will not be copied.
> Q2) Yes, you can. Please use scp or similar utility.
> Q3) The best place to look is V$ARCHIVED_LOG
>
> My turn to ask questions:
> 1) Why would you copy the archived logs manually? Duplicate DB will do
> that for you automagically.
> 2) Why do you need to know which logs are needed. Again, duplicate will
> do that automagically.
>
> I was awoken by the phone, so I am not in the best of shapes right now.
> I will create an example for you this afternoon.
> AFAIK, you are using Commvault so there should be no problem with the
> backup SW of choice.
> Regards
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Sandy B.

--
http://www.freelists.org/webpage/oracle-l