Re: Duplicate for standby fail
From: Leng Burgess <lkaing_at_gmail.com>
Date: Wed, 25 Aug 2021 16:37:58 +1000
Message-Id: <27D20A98-B1AC-41B8-9982-5ADE4F40388D_at_gmail.com>
>>
>>
>> Doc Oracle:RMAN Duplicate for Standby Failing with RMAN-05535 ORA-01156 (Doc ID 2183867.1)
>>
>> Command:
>> run {
>> duplicate target database for standby from active database dorecover nofilenamecheck;
>> }
>> Error:
>>
>> Oracle Error:
>> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
>> ORA-01152: file 1 was not restored from a sufficiently old backup
>> ORA-01110: data file 1: '+DATA/<dbname>/DATAFILE/system.269.1080901629'
>>
>> RMAN-00571: ===========================================================
>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>> RMAN-00571: ===========================================================
>> RMAN-03002: failure of Duplicate Db command at 08/18/2021 12:07:33
>> RMAN-05501: aborting duplication of target database
>> RMAN-06136: Oracle error from auxiliary database: ORA-01156: recovery or flashback in progress may need access to files
>>
>> Recovery Manager complete.
>>
>>
>> Thank you.
>>
>> Att.
>>
>> Juliano Ribeiro
>> <http://br.linkedin.com/in/supernoi>
Date: Wed, 25 Aug 2021 16:37:58 +1000
Message-Id: <27D20A98-B1AC-41B8-9982-5ADE4F40388D_at_gmail.com>
The RMAN-6136 is probably misleading. The mean error is probably coming from ORA-1547. That is, either the datafile copy from the target db failed, or recovery failed.
Have you got the full duplicate log?
> On 24 Aug 2021, at 7:09 am, Mladen Gogala <gogala.mladen_at_gmail.com> wrote: > > Juliano, did you turn off the standby in dg broker? If you didn't, dg broker will turn on recovery as soon as it detects that the instance is in the mounted state. You should disable the standby in the dgmgrl and turn off log shipping. > > Regards > > On 8/23/21 3:43 PM, Juliano Ribeiro wrote:
>>
>>
>> Doc Oracle:RMAN Duplicate for Standby Failing with RMAN-05535 ORA-01156 (Doc ID 2183867.1)
>>
>> Command:
>> run {
>> duplicate target database for standby from active database dorecover nofilenamecheck;
>> }
>> Error:
>>
>> Oracle Error:
>> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
>> ORA-01152: file 1 was not restored from a sufficiently old backup
>> ORA-01110: data file 1: '+DATA/<dbname>/DATAFILE/system.269.1080901629'
>>
>> RMAN-00571: ===========================================================
>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>> RMAN-00571: ===========================================================
>> RMAN-03002: failure of Duplicate Db command at 08/18/2021 12:07:33
>> RMAN-05501: aborting duplication of target database
>> RMAN-06136: Oracle error from auxiliary database: ORA-01156: recovery or flashback in progress may need access to files
>>
>> Recovery Manager complete.
>>
>>
>> Thank you.
>>
>> Att.
>>
>> Juliano Ribeiro
>> <http://br.linkedin.com/in/supernoi>
> -- > Mladen Gogala > Database Consultant > Tel: (347) 321-1217 > https://dbwhisperer.wordpress.com <https://dbwhisperer.wordpress.com/> > -- http://www.freelists.org/webpage/oracle-l
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 25 2021 - 08:37:58 CEST