Forum Stats

  • 3,874,841 Users
  • 2,266,780 Discussions
  • 7,911,978 Comments

Discussions

Is there a way to change container id (cid) in a data file

user12021554
user12021554 Member Posts: 106 Blue Ribbon

1  CREATE PLUGGABLE DATABASE PDB3 using

  2  '/u01/app/oracle/oradata/pdb3recover.xml'

  3  NOCOPY

  4* TEMPFILE REUSE

SQL> /

CREATE PLUGGABLE DATABASE PDB3 using

*

ERROR at line 1:

ORA-65139: Mismatch between XML metadata file and data file

/u01/app/oracle/oradata/cdb1/pdb3/system01.dbf for value of cid (5 in the plug

XML file, 4 in the data file)

Is there anyway I can change the cid in data file. My /u01/app/oracle/oradata/pdb3recover.xm contains many database files,

if I  change cid in /u01/app/oracle/oradata/pdb3recover.xml to 4, then other files complain.

Somehow my system01,dbf file got messed up when I was unplugging PBD3 in a container database(cdb1)  and plugging  in another container (cdb2). I cannot find anyway to fix this problem. I do not have any backups because this is my play database.

This discussion has been closed.