最新(火)

VMware(Vsphere配置共享存储)

# cd /vmfs/volumes/49f5c866-a25fe688-2bff-003048c37402/ # mkdir sharedisk # cd sharedisk 创建共享磁盘。 (例:vmkfstools -c 10000m -d  eagerzer...

2016年11月18日星期五

ORA-65139 Mismatch between XML metadata file and data file

While converting a non-CDB database to a PDB database, sometimes I was able to this, but sometimes I was facing the following error.

################################
SQL> create  pluggable database pdb2 using '/u01/oracle/noncdb.xml';
create  pluggable database pdb2 using '/u01/oracle/noncdb.xml'
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
+DATA/NONCDB/DATAFILE/system.279.868463067 for value of fcpsb (1618349 in the
plug XML file, 1619859 in the data file) 
################################

After a long of investigation, I realized that I need to strictly follow the proper steps to convert a non-CDB database to a PDB database. Steps are as follows
  1. Shutdown non-cdb database
  2. Startup non-cdb in read-only mode
  3. Execute DBMS_PDB.DESCRIBE to describe the non-cdb database in .xml file
  4. Connect to CDB and create PDB out using xml file created above
  5. Execute noncdb_to_pdb.sql script
The reason of facing this error is either or both of the following mistakes
  1. If you don’t start non-CDB database in read-only mode while describing it in the xml file, you will face this error; while creating the PDB using this xml file.
  2. After you described the non-CDB database in the xml file, you SHOULD NOT open the non-CDB database until you are finished executing your “CREATE PLUGGABLE DATABASE” command using this xml file, to create your PDB.
If you have made either or both of the above mistakes, you should perform all the steps again following correct sequence

没有评论:

发表评论

简历

XXX

职位

售前工程师

毕业学校

北京交通大学

本科

所学专业

计算机应用

籍贯

四川省南充市

腾讯QQ

712116176

现所在地

北京市昌平区回龙观

技能

oracle,VMware,IBM,HP,Dell

获得成就

201411月荣得VMware初级工程师认证

20152 月荣获VMware高级工程师认证

20155 月荣获ROSE双机热备高级工程师认证

20156 月荣获 oracle OCP认证工程师

20156 月荣获 DELL认证工程师

VCAP认证

VCAP认证