Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user12021554Aug 16 2014

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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2014

Added on Aug 16 2014

#database-key-features, #multitenant

0 comments

1,274 views