Re: Snapshot Thin Clone of Physical Standby

From: Jeremy Schneider <jeremy.schneider_at_ardentperf.com>
Date: Fri, 2 Oct 2015 13:43:56 -0400
Message-ID: <CA+fnDAYndOr2kFxJ3vDRF9inEKLweQYhbCqUFFezr-FqjmvR7g_at_mail.gmail.com>



On Fri, Oct 2, 2015 at 12:36 PM, Don Seiler <don_at_seiler.us> wrote:
>
> ORA-01511: error in renaming log/data files
> ORA-00261: log 52 of thread 1 is being archived or modified

well it's nice to hear that this problem still exists in 12c - i'm very aware of it in 11.2.0.3

it's because the software isn't really able to handle the standby log which is currently active. i have run into the exact same issue doing a "recover datafile" on a clone which was created using a backup controlfile from the standby. in my case, i simply used the backup from the primary (and changed nothing else) and i don't have the issue.

>
> So we go to plan B, which is to try to create a new controlfile. The new
> CREATE CONTROLFILE script doesn't specify the standby redo logs.
>
> ERROR at line 1:
> ORA-01196: file 1 is inconsistent due to a failed media recovery session
> ORA-01110: data file 1: '/file/name/here.dbf'
>
> Every variation of this that we've tried fails similarly.

So you did also try taking a backup of the primary controlfile and restoring this into the standby, then renaming all your logfiles and datafiles to match the new locations? That has worked for me on 11203 for avoiding the error you mentioned above.

-J

--
http://about.me/jeremy_schneider
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 02 2015 - 19:43:56 CEST

Original text of this message