ORA-65122: Pluggable database GUID conflicts with the GUID of an existing

ORA-65122: Pluggable Database GUID Conflicts With The GUID Of An Existing Container (文件 ID 2416798.1)

SYS@CDBLHR18c> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         4 PDBLHR3                        MOUNTED
         7 PDBLHR2                        MOUNTED
SYS@CDBLHR18c> create pluggable database PDBLHR4
  2  using '/tmp/PDBLHR1.xml'
  3  nocopy tempfile reuse;
create pluggable database PDBLHR4
*
ERROR at line 1:
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing
container.
SYS@CDBLHR18c> create pluggable database PDBLHR4 as clone
  2  using '/tmp/PDBLHR1.xml'
  3  nocopy tempfile reuse;
create pluggable database PDBLHR4 as clone
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/u08/app/oracle/oradata/CDBLHR18C/CDBLHR18C/8FF8F6081FDE6D87E053823BA8C0C041/dat
afile/o1_mf_system_go4h7gtb_.dbf for value of guid
(7A2048D2D3D3B765E053823BA8C0BE92 in the plug XML file,
8FF8F6081FDE6D87E053823BA8C0C041 in the data file)
-- 這裡修改/tmp/PDBLHR1.xml檔案，將<guid>7A2048D2D3D3B765E053823BA8C0BE92</guid>修改為<guid>8FF8F6081FDE6D87E053823BA8C0C041</guid>
SYS@CDBLHR18c> create pluggable database PDBLHR4 as clone
  2  using '/tmp/PDBLHR1.xml'
  3  nocopy tempfile reuse;
Pluggable database created.
SYS@CDBLHR18c> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBLHR4                        MOUNTED
         4 PDBLHR3                        MOUNTED
         7 PDBLHR2                        MOUNTED

In this Document

Symptoms

Cause

Solution

---

APPLIES TO:

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

SYMPTOMS

Restored Pluggable database in a different container and unplugged. Dropped existing old PDB  and trying to plug in new PDB and getting error:
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.


SQL> drop pluggable database PDB1 INCLUDING DATAFILES;

Pluggable database dropped.

SQL> SET SERVEROUTPUT ON
DECLARE
compatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(pdb_descr_file => '/tmp/cdbrf_pdb1.xml')
WHEN TRUE THEN
'YES'
ELSE 'NO'
END;
BEGIN
DBMS_OUTPUT.PUT_LINE(compatible);
END;
/SQL>
YES

PL/SQL procedure successfully completed.

SQL> create pluggable database PDB1
using '/tmp/cdbrf_pdb1.xml'
COPY FILE_NAME_CONVERT = ('+DATA', '+EON_DAT_QA');
; 2 3
create pluggable database pdb1
*
ERROR at line 1:
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.

CAUSE

 The same PDB had been plugged previously hence the  GUID already exists

SOLUTION

 This is expected error.

Use  AS CLONE clause.

create pluggable database ....
AS CLONE using '.....xml'
file_name_convert=(...,..);

Or, if you would like to move the XML file, you can use:
create pluggable database ....
AS CLONE using '.....xml'
MOVE
file_name_convert=(...,..);

AS CLONE option is used when target CDB already contains a PDB that was created using the same set of data files. And this is the case here.

Please take a look at:
https://docs.oracle.com/database/121/SQLRF/statements_6010.htm#SQLRF55686
"
AS CLONE Clause

Specify this clause only if the target CDB already contains a PDB that was created using the same set of data files. The source files remain as an unplugged PDB and can be used again. Specifying AS CLONE also ensures that Oracle Database generates new identifiers, such as DBID and GUID, for the new PDB.

---

---

About Me

........................................................................................................................ ● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除 ● 本文在itpub、部落格園、CSDN和個人微 信公眾號（ xiaomaimiaolhr ）上有同步更新 ● 本文itpub地址： http://blog.itpub.net/26736162 ● 本文部落格園地址： http://www.cnblogs.com/lhrbest ● 本文CSDN地址： https://blog.csdn.net/lihuarongaini ● 本文pdf版、個人簡介及小麥苗雲盤地址： http://blog.itpub.net/26736162/viewspace-1624453/ ● 資料庫筆試面試題庫及解答： http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA寶典今日頭條號地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826 ........................................................................................................................ ● QQ群號： 230161599 （滿） 、618766405 ● 微 信群：可加我微 信，我拉大家進群，非誠勿擾 ● 聯絡我請加QQ好友 （ 646634621 ） ，註明新增緣由 ● 於 2019-08-01 06:00 ~ 2019-08-31 24:00 在西安完成 ● 最新修改時間：2019-08-01 06:00 ~ 2019-08-31 24:00 ● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解 ● 版權所有，歡迎分享本文，轉載請保留出處 ........................................................................................................................ ● 小麥苗的微店 ： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ● 小麥苗出版的資料庫類叢書 ： http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麥苗OCP、OCM、高可用網路班 ： http://blog.itpub.net/26736162/viewspace-2148098/ ● 小麥苗騰訊課堂主頁 ： https://lhr.ke.qq.com/ ........................................................................................................................ 使用 微 信客戶端 掃描下面的二維碼來關注小麥苗的微 信公眾號（ xiaomaimiaolhr ）及QQ群（DBA寶典）、新增小麥苗微 信， 學習最實用的資料庫技術。 ........................................................................................................................

 

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-2653532/，如需轉載，請註明出處，否則將追究法律責任。