测试重建pdb的xml文件

查看pdb

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11G                         READ WRITE NO

关闭pdb11g

SQL> alter pluggable database PDB11G close instances=all;

Pluggable database altered.

拔出pdb

SQL> alter pluggable database pdb11g unplug into '/home/oracle/pdb11g.xml';

Pluggable database altered.

删除pdb11g

SQL> drop pluggable database pdb11g;

Pluggable database dropped.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO

确定数据文件位置

[oracle@rac19c1 ~]$ more pdb11g.xml 
<?xml version="1.0" encoding="UTF-8"?>
<PDB>
  <xmlversion>1</xmlversion>
  <pdbname>PDB11G</pdbname>
  <cid>3</cid>
  <byteorder>1</byteorder>
  <vsn>318767104</vsn>
  <vsns>
    <vsnnum>19.0.0.0.0</vsnnum>
    <cdbcompt>19.0.0.0.0</cdbcompt>
    <pdbcompt>19.0.0.0.0</pdbcompt>
    <vsnlibnum>0.0.0.0.24</vsnlibnum>
    <vsnsql>24</vsnsql>
    <vsnbsv>8.0.0.0.0</vsnbsv>
  </vsns>
  <dbid>2641994281</dbid>
  <ncdb2pdb>0</ncdb2pdb>
  <cdbid>1705761252</cdbid>
  <guid>97987F2E53CC2C05E0530B38A8C0CB0F</guid>
 

查看数据文件

ASMCMD> cd 97987F2E53CC2C05E0530B38A8C0CB0F/
ASMCMD> cd datafile
EXAMPLE.302.1024667731
SOE.306.1024667731
SYSAUX.303.1024667731
SYSTEM.305.1024667731
T.299.1024667731
T1.300.1024667731
T2.301.1024667731
UNDOTBS1.304.1024667731
UNDOTBS2.298.1024667731
USERS.297.1024667731
ASMCMD> pwd
+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile

执行DBMS_PDB.RECOVER重新生成xml

DBMS_PDB.RECOVER (
pdb_descr_file IN VARCHAR2,
pdb_name IN VARCHAR2,
filenames IN VARCHAR2);

SQL> exec dbms_pdb.recover(pdb_descr_file=>'/home/oracle/test.xml',pdb_name=>'pdb11g',filenames=>'+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/EXAMPLE.302.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/SOE.306.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/SYSAUX.303.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/SYSTEM.305.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/T.299.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/T1.300.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/T2.301.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/UNDOTBS1.304.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/UNDOTBS2.298.1024667731,+datadg/rac19c/97987F2E53CC2C05E0530B38A8C0CB0F/datafile/USERS.297.1024667731');

PL/SQL procedure successfully completed.

使用新的xml插入pdb

SQL> create pluggable database pdb11g using '/home/oracle/test.xml';

Pluggable database created.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11G                         MOUNTED

启动数据库

SQL>  alter pluggable database PDB11G open instances=all;

Pluggable database altered.

在1节点发现发现pdb的open_mode为MIGRATE ，2节点正常

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11G                         MIGRATE    YES

重启一节点pdb，恢复正常。