My Oracle Support Banner

RMAN Duplicate Database for pdb Fails With ORA-03113 AND ORA-65011 : Pluggable Database Does Not Exist Message (Doc ID 2732258.1)

Last updated on MARCH 03, 2021

Applies to:

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

Symptoms

Rman duplicate using pluggable database option terminates with ORA-03113 AND ORA-65011 during open resetlogs

Issue reported only while doing a targetless duplicate of pdb connected to catalog.

Issue is reported when using set newname for database to new

 

Rman logs

 

RMAN-08161: contents of Memory Script:
{
sql clone 'alter system set "_system_trig_enabled"=FALSE';
Alter clone database open resetlogs;
sql clone 'alter system reset "_system_trig_enabled"';
}
RMAN-08162: executing Memory Script

RMAN-06162: sql statement: alter system set "_system_trig_enabled"=FALSE

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-01092: ORACLE instance
terminated. Disconnection forced
RMAN-03002: failure of Duplicate Db command at 10/20/2020 14:31:42
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database: ORA-03113: end-of-file on
communication channel
Process ID: 3409

 

 

Alert log Shows

============


ORA-65011: Pluggable database does not exist.
2020-10-20T14:31:40.616090+00:00
Errors in file  <path>/trace/<SID>_dbw0_3374.trc
:
ORA-65011: Pluggable database does not exist.
Errors in file
<path>/trace/<SID>_dbw0_3374.trc(incident=118235) (PDBNAME=CDB$ROOT):
ORA-65011 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in:
<path>/trace/<SID>_dbw0_3374_i118235.trc
2020-10-20T14:31:41.979987+00:00
USER (ospid: 3374): terminating the instance due to ORA error 65011

 

Sample script

Error while rman duplicate

rman auxiliary / connect catalog <username>/xxxxxx@<connect string>

RUN {
  allocate auxiliary channel C1 device type disk;
  allocate auxiliary channel C2 device type disk;
  allocate auxiliary channel C3 device type disk;
   set dbid <dbid>;
 set newname for database to new;
 SET UNTIL TIME "TO_DATE('20-OCT-2020 01:20:30','DD-MON-YYYY HH24:MI:SS')";
 duplicate database <name> DBID <dbid> to <newname> PLUGGABLE DATABASE <name of pdb to be clone>,"CDB$ROOT"
  LOGFILE
  GROUP 1 ('<name of diskgroup>') SIZE 400M REUSE,
  GROUP 2 ('<name of diskgroup>') SIZE 400M REUSE,
  GROUP 3 ('<name of diskgroup>') SIZE 400M REUSE;
}


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
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.