My Oracle Support Banner

DBMS_PDB.RECOVER Fails with "ORA-65185: could not find data file belonging to SYSTEM tablespace" (Doc ID 2477075.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

You unplugged a PDB, but the .xml manifest file no longer exists.   You still have all the data files and want to use DBMS_PDB.RECOVER in order to regenerate the .xml file.  When you run the procedure, it fails with "ORA-65185: could not find data file belonging to SYSTEM tablespace."

Example:

 

Changes

 You unplugged a PDB and are trying to recover the .xml manifest file (you still have the data files).

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


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