Duplicate for standby fail

From: Juliano Ribeiro <supernoi_at_msn.com>
Date: Mon, 23 Aug 2021 21:43:09 +0200
Message-ID: <MWHPR18MB1373EAB3E8FFBD207D411A3CCCC49_at_MWHPR18MB1373.namprd18.prod.outlook.com>

Hello all,

Today I came across a "strange" error, at least new to me. When trying to create a database standby for the dataguard, it returned an error at the end when trying to create the Redo's and Redo's Standbys. The error was after the recovery of the archivelogs.

I just found a document in supportOracle, tried the solution, and made the duplicate again, but repeated the error.

Has anyone been through a similar situation?

Env:
Linux Redhat 7.9 x64
Oracle Database 19.8 (standalone, asm)

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>

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

Received on Mon Aug 23 2021 - 21:43:09 CEST