Database Utilities (MOSC)

MOSC Banner

How do I plug in an unplugged PDB without the XML file (Oracle 19c)

I unplugged PDBs and copied off the files from our Oracle 19c database to prepare for the server to be upgraded. Once the server was upgraded, I reinstalled Oracle. When I went to plug back in the PDBs, I realized that I lost the XML masterfile/metdata files and the data file backups. How do I plug in the PDBs into the new database without the XML files? I have tried the following to recreate the XML files:

BEGIN
DBMS_PDB.DESCRIBE(
pdb_descr_file => '/u01/app/oracle/oradata/NEWPDB/metadata.xml',
pdb_path => '/u01/app/oracle/oradata/NEWPDB');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center