My Oracle Support Banner

Clone Of Database Fails With ORA-65345: Cannot Refresh Pluggable Database (Doc ID 2849275.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Oracle Database Cloud Exadata Service - Version N/A to N/A [Release 1.0]
Oracle Database Exadata Express Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

You are trying to clone a non CDB into a PDB on DBCS. The target CDB (DBCS) has been patched to 19.14 and has the 32631551 patch. The source db is 19.12 (Single Instance on OCI bare metal server) and does not have the 32631551 patch.
The clone runs for five hours and then fails.
create pluggable database dwprdpdb from non$cdb@clone_link KEYSTORE IDENTIFIED BY "*"
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-65345: cannot refresh pluggable database

Elapsed: 05:07:06.10

Alert log:
  2022-01-31T21:42:58.257002-06:00
  PDB(3):Endian type of dictionary set to little
  2022-01-31T21:43:00.564436-06:00
  ****************************************************************
  Pluggable Database PDB with pdb id - 3 is created as UNUSABLE.
  If any errors are encountered before the pdb is marked as NEW,
  then the pdb must be dropped
  local undo-1, localundoscn-0x0000000000000007
  ****************************************************************
  2022-01-31T21:43:03.300286-06:00
  Applying media recovery for pdb-0 from SCN 2278564308624 to SCN 2278566434008
  Remote log information: count-1
  thr-1,seq-172536,logfile-/u03/dwprd_archivelogs/parlog_1_172536_f8aebf51_1048019846.arc,los-2278566433916,nxs-18446744073709551615,maxblks-22
  DWPRDPDB(3):Media Recovery Start
  2022-01-31T21:43:03.305866-06:00
  DWPRDPDB(3):Serial Media Recovery started
  DWPRDPDB(3):max_pdb is 5
  DWPRDPDB(3):Refresh recovery failed to find archive log for thr-1, scn-2278564308624
  2022-01-31T21:43:03.649850-06:00
  DWPRDPDB(3):Media Recovery failed with error 65345

Changes

 

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.