My Oracle Support Banner

RMAN Duplicate fails with ORA-01157 ORA-01110 on "Alter clone database open resetlogs;" (Doc ID 2887290.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.11.0.0.0 version, Recovery Manager

RMAN DUPLICATE of encrypted standby tablespace database or RMAN DUPLICATE ... AS ENCRYPTED of a database where tablespaces
are not encrypted  fails with the below error on open database resetlogs:

 

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-04006: error from auxiliary database: ORA-12537: TNS:connection closed
RMAN-03002: failure of Duplicate Db command at ##/##/2022 00:07:01
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database: ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00604: error occurred at recursive SQL level 1
ORA-01157: cannot identify/lock data file XXXX - see DBWR trace file
ORA-01110: data file <tf#>: '<name_of_tempfile> or <ASM device>'
Process ID: XXXX
Session ID: XXXX Serial number: XXXX

 

Changes

 After encrypting standby tablespaces or duplicating a TDE encrypted standby database for the first time.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.