cdb中有pdb1,pdb2
需求：希望將在線熱備份pdb1的備份集a，恢復成pdb3，使得cdb中有pdb1,2,3
參考到的：RMAN備份恢復典型案例——跨平臺遷移pdb - 墨天輪
| ORA-65122: Pluggable Database GUID Conflicts With The GUID Of An Existing Container (Doc ID 2416798.1) |
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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:
CREATE PLUGGABLE DATABASE
"
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.
Oracle若只有PDB數據庫文件，如何將PDB插入到其他CDB? - 墨天輪
[BEGIN] 2025/8/15 20:06:15
SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ ll /u01/app/oracle/oradata/ora23aipdb01
total 2783328
-rw-r-----. 1 oracle oinstall 10493952 Aug 15 19:56 jyc01.dbf
-rw-r-----. 1 oracle oinstall 2147491840 Aug 15 19:56 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 367009792 Aug 15 19:56 system01.dbf
-rw-r-----. 1 oracle oinstall 20979712 Jun 26 06:02 temp01.dbf
-rw-r-----. 1 oracle oinstall 319823872 Aug 15 19:56 undotbs01.dbf
[oracle@ora23ai ~]$ pwd
/home/oracle
[oracle@ora23ai ~]$ ll
total 1788600
-rw-r--r--. 1 oracle oinstall 2068 Dec 23 2024 db_install.rsp
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 20:03 pdb1
-rw-r----- 1 oracle oinstall 1831501824 Aug 15 19:57 pdb1_01417281_1_1_1
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:03 pdb1.xml
-rw-r----- 1 oracle oinstall 3316 May 13 17:16 sqlnet.log
[oracle@ora23ai ~]$ cp pdb1.xml
cp: missing destination file operand after 'pdb1.xml'
Try 'cp --help' for more information.
[oracle@ora23ai ~]$ cp pdb1.xml pdb1.xml.bak
[oracle@ora23ai ~]$ vi pdb1.xml
[oracle@ora23ai ~]$ grep guid pdb1.xml<guid>29ED108305EC7E38E0653CDEB45D3AB5</guid>
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:08:10 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb1.xml'
foreign pluggable database PDB1
format '/home/oracle/pdb1/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb1.xml'
2> foreign pluggable database PDB1
3> format '/home/oracle/pdb1/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=279 device type=DISKchannel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN Command Id : 2025-08-15T20:08:10
RMAN Command Id : 2025-08-15T20:08:10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:08:55
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> drop pluggable database ora23aipdb01 INCLUDING DATAFILES;
drop pluggable database ora23aipdb01 INCLUDING DATAFILES;
Statement processedRMAN> restore using '/home/oracle/pdb1.xml'
foreign pluggable database PDB1
format '/home/oracle/pdb1/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb1.xml'
2> foreign pluggable database PDB1
3> format '/home/oracle/pdb1/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using channel ORA_DISK_1channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_10417363
channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_91417363
channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_lg417363
channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_g5417363
channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbfPerforming import of metadata...
Finished restore at 15-AUG-25RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ ll /u01/app/oracle/oradata/ora23aipdb01
total 0
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:13:56 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO4 PDB1 MOUNTED
SQL> alter pluggable database pdb1 open;Pluggable database altered.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO4 PDB1 READ WRITE NO
SQL> select name from v$datafile;NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORA23AI/system01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/system01.dbf
/u01/app/oracle/oradata/ORA23AI/sysaux01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/ORA23AI/users01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/undotbs01.dbf
/u01/app/oracle/oradata/ORA23AI/undotbs01.dbf
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u711 rows selected.SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ cp pdb1.xml pdb2.xml
[oracle@ora23ai ~]$ vi pdb2.xml
[oracle@ora23ai ~]$ pwd
/home/oracle
[oracle@ora23ai ~]$ mkdir pdb2
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:17:23 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB2
3> format '/home/oracle/pdb2/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=32 device type=DISKchannel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_jr4173es
channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_s44173es
channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_4q4173es
channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_kj4173es
channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN Command Id : 2025-08-15T20:17:23
RMAN Command Id : 2025-08-15T20:17:23
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:17:49
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> RMAN> RMAN> restore AS CLONE using '/home/oracle/pdb2.xml'
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore AS CLONE
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "as": expecting one of: "allforeign, application, archivelog, asdecrypted, asencrypted, backupset, channel, check, controlfile, database, database root, datafile, device, dump, farsync, file_name_convert, file, force, foreign, from, frompreplugin, from service, high, pluggable, preview, primary, section, skip preplugin, skip readonly, spfile, standby, tablespace, to restore point, transport file, transport list, until restore point, until, using, validate, xmlfile, ("
RMAN-01007: at line 1 column 9 file: standard inputRMAN> foreign
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "foreign": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> format
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "format": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN>
from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ vi pdb2.xml
RMAN> exit
exit
Recovery Manager complete.
[oracle@ora23ai ~]$ vi pdb2.xml
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:21:03 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB2
3> format '/home/oracle/pdb2/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=276 device type=DISKchannel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_4d4173m8
channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_1b4173m8
channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_l64173m8
channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_kj4173m8
channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN Command Id : 2025-08-15T20:21:03
RMAN Command Id : 2025-08-15T20:21:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:21:44
ORA-65027: XML metadata file error while getting node or value for (GUID - PDB)
Help: https://docs.oracle.com/error-help/db/ora-65027/RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ oerr ora 65027
65027, 00000, "XML metadata file error while getting node or value for (%s - %s)"
// *Cause: An error occurred while trying to parse the XML metadata file.
// *Action: Check and correct the XML metadata file.
//
[oracle@ora23ai ~]$ rman target /\
> ^C
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:28:27 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml' nonsparse clone
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';
restore using '/home/oracle/pdb2.xml' nonsparse
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "nonsparse": expecting one of: "allforeign, application, archivelog, asdecrypted, asencrypted, backupset, channel, check, controlfile, database, database root, datafile, device, dump, farsync, file_name_convert, file, force, foreign, from, frompreplugin, from service, high, pluggable, preview, primary, section, skip preplugin, skip readonly, spfile, standby, tablespace, to restore point, transport file, transport list, until restore point, until, using, validate, xmlfile, ("
RMAN-01007: at line 1 column 39 file: standard inputRMAN> foreign
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "foreign": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> format
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "format": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> RMAN> restore using '/home/oracle/pdb2.xml' clone
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml' clone
2> foreign pluggable database PDB2
3> format '/home/oracle/pdb2/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:28:56
RMAN-12010: automatic channel allocation initialization failed
RMAN-06174: not connected to auxiliary databaseRMAN> restore using '/home/oracle/pdb2.xml' as clone
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml' as cloneRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "as": expecting one of: "allforeign, application, archivelog, asdecrypted, asencrypted, backupset, channel, check, controlfile, database, database root, datafile, device, dump, farsync, file_name_convert, file, force, foreign, from, frompreplugin, from service, high, pluggable, preview, primary, section, skip preplugin, skip readonly, spfile, standby, tablespace, to restore point, transport file, transport list, until restore point, until, using, validate, xmlfile, ("
RMAN-01007: at line 1 column 39 file: standard inputRMAN> foreign
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "foreign": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> format
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "format": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN>
from backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create or replace global, create or replace script, create script, crosscheck, declare, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, register, release, rename"
RMAN-01007: at line 1 column 1 file: standard inputRMAN> RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ vi pdb2.xml
[oracle@ora23ai ~]$ vi pdb2.xml
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:30:09 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB2
3> format '/home/oracle/pdb2/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=284 device type=DISKchannel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_s9417474
channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_2n417474
channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_t4417474
channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_li417474
channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN Command Id : 2025-08-15T20:30:09
RMAN Command Id : 2025-08-15T20:30:09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:30:44
ORA-65027: XML metadata file error while getting node or value for (CDB Database ID - PDB)
Help: https://docs.oracle.com/error-help/db/ora-65027/RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ pwd
/home/oracle
[oracle@ora23ai ~]$ ll *.xml*
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:13 pdb1.xml
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:07 pdb1.xml.bak
-rw-r--r-- 1 oracle oinstall 9454 Aug 15 20:30 pdb2.xml
[oracle@ora23ai ~]$ cp pdb1.xml pdb2.xml
[oracle@ora23ai ~]$ vi pdb2.xml
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:31:53 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB2
3> format '/home/oracle/pdb2/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=284 device type=DISKchannel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_ko4174ab
channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_644174ab
channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_ls4174ab
channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_gr4174ab
channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:17
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN Command Id : 2025-08-15T20:31:53
RMAN Command Id : 2025-08-15T20:31:53
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:32:28
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ rman target / debug trace=/tmp/rman_debugRecovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:33:13 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.RMAN-06005: connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB2
format '/home/oracle/pdb2/%U'
from backupset '/home/oracle/pdb1_01417281_1_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB2
3> format '/home/oracle/pdb2/%U'
4>
from backupset '/home/oracle/pdb1_01417281_1_1_1';
RMAN-03090: Starting restore at 15-AUG-25
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=279 device type=DISKRMAN-08016: channel ORA_DISK_1: starting datafile backup set restore
RMAN-08089: channel ORA_DISK_1: specifying datafile(s) to restore from backup set
RMAN-08622: channel ORA_DISK_1: restoring all foreign files in backup piece
RMAN-08003: channel ORA_DISK_1: reading from backup piece /home/oracle/pdb1_01417281_1_1_1
RMAN-08626: channel ORA_DISK_1: restoring foreign file 13 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp
RMAN-08626: channel ORA_DISK_1: restoring foreign file 12 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp
RMAN-08626: channel ORA_DISK_1: restoring foreign file 14 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp
RMAN-08626: channel ORA_DISK_1: restoring foreign file 15 to /home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp
RMAN-08627: channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1_01417281_1_1_1
RMAN-08023: channel ORA_DISK_1: restored backup piece 1
RMAN-08180: channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
RMAN-08430: channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:33:45
RMAN-03009: failure of IRESTORE command on ORA_DISK_1 channel at 08/15/2025 20:33:45
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/
app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/Coracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-242746
5694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf'REATE PLUGGA , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,
'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY；BLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/
2> app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-242746
3> 5694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,
4>
'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY；5> 6> RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-00600: internal error, arguments [2016] [4] [] [] []RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:46:15 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/
app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/ 2 oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-242746
5694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' 3 , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,
'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY； 4 5
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> ^CSQL> ^C^CSQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:47:46 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp for
value of guid (39ED108305EC7E38E0653CDEB45D3AB5 in the plug XML file,
29ED108305EC7E38E0653CDEB45D3AB4 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ pwd
/home/oracle
[oracle@ora23ai ~]$ cp pdb1.xml pdb2.xml
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:48:40 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp for
value of guid (29ED108305EC7E38E0653CDEB45D3AB5 in the plug XML file,
29ED108305EC7E38E0653CDEB45D3AB4 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ vi pdb2.xml
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:49:16 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL>
SQL>
SQL>
SQL> CREATE PLUGGABLE DATABASE PDB2 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb2/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' ,'/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp' ) NOCOPY;Pluggable database created.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO4 PDB1 READ WRITE NO6 PDB2 MOUNTED
SQL> alter pluggable database pdb2 open;Pluggable database altered.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO4 PDB1 READ WRITE NO6 PDB2 READ WRITE NO
SQL> select name from v$datafile;NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORA23AI/system01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/system01.dbf
/u01/app/oracle/oradata/ORA23AI/sysaux01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/ORA23AI/users01.dbf
/u01/app/oracle/oradata/ORA23AI/pdbseed/undotbs01.dbf
/u01/app/oracle/oradata/ORA23AI/undotbs01.dbf
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7NAME
--------------------------------------------------------------------------------
/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_ek4174cp
/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_144174cp
/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_sg4174cp
/home/oracle/pdb2/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_na4174cp15 rows selected.SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:52:35 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> backup pluggable database pdb1;
backup pluggable database pdb1;
Starting backup at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=279 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00017 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
input datafile file number=00016 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
input datafile file number=00018 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
input datafile file number=00019 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
channel ORA_DISK_1: starting piece 1 at 15-AUG-25
channel ORA_DISK_1: finished piece 1 at 15-AUG-25
piece handle=/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1 tag=TAG20250815T205249 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 15-AUG-25Starting Control File Autobackup at 15-AUG-25
piece handle=/u01/app/oracle/product/23/db_1/dbs/c-2427465694-20250815-01 comment=NONE
Finished Control File Autobackup at 15-AUG-25RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ pwd
/home/oracle
[oracle@ora23ai ~]$ mkdir pdb3
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:55:28 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB3
format '/home/oracle/pdb3/%U'
from backupset '/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB3
3> format '/home/oracle/pdb3/%U'
4>
from backupset '/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1';
Starting restore at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=29 device type=DISKchannel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1
channel ORA_DISK_1: restoring foreign file 17 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_em4175mc
channel ORA_DISK_1: restoring foreign file 16 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_ib4175mc
channel ORA_DISK_1: restoring foreign file 18 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_854175mc
channel ORA_DISK_1: restoring foreign file 19 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_134175mc
channel ORA_DISK_1: foreign piece handle=/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN Command Id : 2025-08-15T20:55:28
RMAN Command Id : 2025-08-15T20:55:28
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:55:56
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ rman target / debug trace=/tmp/rman_debugRecovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:56:07 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.RMAN-06005: connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb2.xml'
foreign pluggable database PDB3
format '/home/oracle/pdb3/%U'
from backupset '/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1';restore using '/home/oracle/pdb2.xml'
2> foreign pluggable database PDB3
3> format '/home/oracle/pdb3/%U'
4>
from backupset '/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1';
RMAN-03090: Starting restore at 15-AUG-25
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=285 device type=DISKRMAN-08016: channel ORA_DISK_1: starting datafile backup set restore
RMAN-08089: channel ORA_DISK_1: specifying datafile(s) to restore from backup set
RMAN-08622: channel ORA_DISK_1: restoring all foreign files in backup piece
RMAN-08003: channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1
RMAN-08626: channel ORA_DISK_1: restoring foreign file 17 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_434175nu
RMAN-08626: channel ORA_DISK_1: restoring foreign file 16 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu
RMAN-08626: channel ORA_DISK_1: restoring foreign file 18 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_4d4175nu
RMAN-08626: channel ORA_DISK_1: restoring foreign file 19 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_7u4175nu
RMAN-08627: channel ORA_DISK_1: foreign piece handle=/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1
RMAN-08023: channel ORA_DISK_1: restored backup piece 1
RMAN-08180: channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
RMAN-08430: channel ORA_DISK_1: plugging file 3 for /u01/app/oracle/oradata/ora23aipdb01/temp01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 20:56:46
RMAN-03009: failure of IRESTORE command on ORA_DISK_1 channel at 08/15/2025 20:56:46
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ vi /tmp/rman_debug
[oracle@ora23ai ~]$ tail -500 /tmp/rman_debug |more
DBGMISC: ENTERED krmzgetxttpluginf [20:56:46.892]
DBGMISC: EXITED krmzgetxttpluginf [20:56:46.892] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [20:56:46.892]
DBGMISC: EXITED krmzgchid [20:56:46.892] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [20:56:46.892]
RMAN-08430: channel ORA_DISK_1: plugging file 12 for /u01/app/oracle/oradata/ora23aipdb01/system01.dbf
DBGMISC: EXITED krmzlog [20:56:46.893] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [20:56:46.893]
DBGMISC: EXITED krmzgetxttpluginf [20:56:46.893] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [20:56:46.893]
DBGMISC: EXITED krmzgchid [20:56:46.893] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [20:56:46.893]
RMAN-08430: channel ORA_DISK_1: plugging file 13 for /u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf
DBGMISC: EXITED krmzlog [20:56:46.894] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [20:56:46.894]
DBGMISC: EXITED krmzgetxttpluginf [20:56:46.894] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [20:56:46.894]
DBGMISC: EXITED krmzgchid [20:56:46.894] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [20:56:46.894]
RMAN-08430: channel ORA_DISK_1: plugging file 14 for /u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf
DBGMISC: EXITED krmzlog [20:56:46.895] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [20:56:46.895]
DBGMISC: EXITED krmzgetxttpluginf [20:56:46.895] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [20:56:46.895]
DBGMISC: EXITED krmzgchid [20:56:46.895] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [20:56:46.895]
RMAN-08430: channel ORA_DISK_1: plugging file 15 for /u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf
DBGMISC: EXITED krmzlog [20:56:46.896] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [20:56:46.896]
DBGMISC: EXITED krmzgetxttpluginf [20:56:46.896] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [20:56:46.896]
DBGMISC: EXITED krmzgchid [20:56:46.896] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmztrc [20:56:46.896]
DBGPLSQL: channel ORA_DISK_1: Calling doxttplug [20:56:46.896] (restore)
DBGMISC: EXITED krmztrc [20:56:46.896] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzxttplug [20:56:46.896]
DBGSQL: ENTERED krmkosqlerrDBGSQL: TARGET> CREATE PLUGGABLE DATABASE PDB3 USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/
app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/system01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/sysaux01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs0
1.dbf' , '/home/oracle/pdb3/undotbs01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/jyc01.dbf' ) NOCOPY
DBGSQL: sqlcode = 65122
DBGSQL: error: ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container. (krmkosqlerr)
DBGSQL: Help: https://docs.oracle.com/error-help/db/ora-65122/ (krmkosqlerr)
DBGSQL: (krmkosqlerr)
DBGSQL: EXITED krmkosqlerr
DBGMISC: krmkosqlexe called from file krmr.c, line 6837 has produced error 65122 at TARGET upon executing CREATE PLUGGABLE DATABASE PDB3 USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01
/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/system01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.db
f' , '/home/oracle/pdb3/sysaux01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/undotbs01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/jyc01.dbf' ) NOCO
PY [20:56:46.923] (krmkosqlexe_impl)
DBGMISC: krmksqlerror called from file krmr.c, line 6851, cx: 94214224801192 for TARGET [20:56:46.924]
DBGMISC: Exception 6003 external exception thrown at krmkseqlerror@krmk3.c#5938 [20:56:46.924]
DBGMISC: Exception 6003 seen at krmzxttplug@krmz.c#10171 [20:56:46.924]
DBGRPC: krmxr - xc channel ORA_DISK_1, chx channel ORA_DISK_1, returned from peicnt with peirc 3
DBGMISC: ENTERED krmstrim [20:56:46.924]
DBGMISC: Trimming message: ORA-06512: at "KRMICD", line 1497 [20:56:46.925] (krmstrim)
DBGMISC: ORA-06512: at line 26 (krmstrim)
DBGMISC: (56) (krmstrim)
DBGMISC: EXITED krmstrim with status 56 [20:56:46.925] elapsed time [00:00:00:00.000]
DBGMISC: Exception 10032 external exception recorded but not thrown at krmxr@krmx.c#2607 [20:56:46.925]
DBGRPC: krmxr - xc channel ORA_DISK_1, chx channel ORA_DISK_1, got execution errors (step_60)
DBGRPC: krmxr - exiting with 1
DBGMISC: krmqexe: unhandled exception on channel ORA_DISK_1 [20:56:46.925]
DBGMISC: EXITED krmiexe with status 1 [20:56:46.925] elapsed time [00:00:00:16.129]
DBGMISC: krmice: Command 'IRESTORE' execution has failed on channel ORA_DISK_1: krmice1 return code is 1 [20:56:46.925]
DBGMISC: Exception 3009 external exception thrown at krmice@krmi.c#4688 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmice@krmi.c#5141 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmiep2@krmi.c#1329 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmice@krmi.c#5141 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmiep2@krmi.c#1329 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmicomp@krmi.c#6376 [20:56:46.925]
DBGMISC: krmicomp: error 3009 signalled during compilation [20:56:46.925]
DBGMISC: Exception 3002 external exception thrown at krmicomp@krmi.c#6426 [20:56:46.925]
DBGMISC: Exception 3002 seen at krmice1@krmi.c#7093 [20:56:46.925]
DBGMISC: Exception 3002 seen at krmice@krmi.c#5141 [20:56:46.925]
DBGMISC: ENTERED krmkmrsr [20:56:46.926]DBGSQL: TARGET> select decode(status, 'OPEN', 1, 0), decode(archiver, 'FAILED', 1, 0), decode(database_status, 'SUSPENDED', 1, 0) into :status, :archstuck, :dbsuspended from v$instance
DBGSQL: sqlcode = 0
DBGSQL: D :status = 1
DBGSQL: D :archstuck = 0
DBGSQL: D :dbsuspended = 0DBGSQL: TARGET> select decode(open_mode, 'READ WRITE', 1, 0) into :read_write from v$database
DBGSQL: sqlcode = 0
DBGSQL: D :read_write = 1DBGSQL: TARGET> select value into :vcomp_txt from v$parameter where name = 'compatible'
DBGSQL: sqlcode = 0
DBGSQL: D :vcomp_txt = 23.6.0DBGSQL: TARGET> declare dot1st number; dot2nd number; dot3rd number; comptxt varchar2(255) := :vcomp_txt; begin comptxt := comptxt || '.0.0'; dot1st := instr(comptxt, '.', 1, 1); dot2nd := instr(comptxt, '.'
, 1, 2); dot3rd := instr(comptxt, '.', 1, 3); comptxt := lpad(substr(comptxt, 1, dot1st - 1), 2, '0') || lpad(substr(comptxt, dot1st + 1, dot2nd - dot1st - 1), 2, '0') || lpad(substr(comptxt, dot2nd + 1, dot3rd - dot2nd
- 1), 2, '0');:vcomp_ub4 := to_number(comptxt); end;
DBGSQL: sqlcode = 0
DBGSQL: B :vcomp_ub4 = 230600
DBGSQL: B :vcomp_txt = 23.6.0
DBGMISC: krmkpdbs(): vcomp_txt:23.6.0 vcomp_ub4:230600 flags:5 [20:56:46.937]
DBGSQL: ENTERED krmkosqlerrDBGSQL: TARGET> select /*+ rule */ round(sum(MBYTES_PROCESSED)), round(sum(INPUT_BYTES)), round(sum(OUTPUT_BYTES)) from V$RMAN_STATUS START WITH RECID = :row_id and STAMP = :row_stamp CONNECT BY PRIOR RECID= parent_recid
DBGSQL: sqlcode = 24347
DBGSQL: B :row_id = 31
DBGSQL: B :row_stamp = 1209243389
DBGSQL: success: ORA-24347: Warning of a NULL column in an aggregate function (krmkosqlerr)
DBGSQL: Help: https://docs.oracle.com/error-help/db/ora-24347/ (krmkosqlerr)
DBGSQL: (krmkosqlerr)
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 20:58:43 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO4 PDB1 READ WRITE NO6 PDB2 READ WRITE NO
SQL> CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/system01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/sysaux01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/undotbs01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/jyc01.dbf' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/system01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/sysaux01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/undotbs01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/jyc01.dbf' ) NOCOPY
*
ERROR at line 1:
ORA-19505: failed to identify file "/home/oracle/pdb3/system01.dbf"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Help: https://docs.oracle.com/error-help/db/ora-19505/SQL>
SQL> CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_434175nu' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_4d4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_7u4175nu' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb2.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_434175nu' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_4d4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_7u4175nu' ) NOCOPY
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu for
value of cid (3 in the plug XML file, 4 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ cp pdb1
pdb1/ pdb1_01417281_1_1_1 pdb1.xml pdb1.xml.bak
[oracle@ora23ai ~]$ cp pdb1
pdb1/ pdb1_01417281_1_1_1 pdb1.xml pdb1.xml.bak
[oracle@ora23ai ~]$ cp pdb1.xml pdb3.xml
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:04:07 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb3.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_434175nu' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_4d4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_7u4175nu' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb3.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/ora23aipdb01/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/u01/app/oracle/oradata/ora23aipdb01/system01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/sysaux01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_434175nu' , '/u01/app/oracle/oradata/ora23aipdb01/undotbs01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_4d4175nu' , '/u01/app/oracle/oradata/ora23aipdb01/jyc01.dbf' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_7u4175nu' ) NOCOPY
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_8f4175nu for
value of cid (3 in the plug XML file, 4 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO4 PDB1 READ WRITE NO6 PDB2 READ WRITE NO
SQL> backup for transport unplug into '/home/oracle/pdb1.xml' format '/home/oracle/pdb1_%U' pluggable database pdb1;
SP2-0734: unknown command beginning "backup for..." - rest of line ignored.
Help: https://docs.oracle.com/error-help/db/sp2-0734/
SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ rman target /Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:07:21 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.connected to target database: ORA23AI (DBID=2427465694)RMAN> backup for transport unplug into '/home/oracle/pdb1.xml' format '/home/oracle/pdb1_%U' pluggable database pdb1;
backup for transport unplug into '/home/oracle/pdb1.xml' format '/home/oracle/pdb1_%U' pluggable database pdb1;
Starting backup at 15-AUG-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=156 device type=DISK
running UNPLUG on the specified pluggable database: PDB1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/15/2025 21:07:26
ORA-65025: Pluggable database PDB1 is not closed on all instances.
Help: https://docs.oracle.com/error-help/db/ora-65025/RMAN> alter pluggable database pdb1;
alter pluggable database pdb1;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 08/15/2025 21:07:37
ORA-00922: missing or invalid option
Help: https://docs.oracle.com/error-help/db/ora-00922/RMAN> alter pluggable database pdb1 close immediate;
alter pluggable database pdb1 close immediate;
Statement processedRMAN> backup for transport unplug into '/home/oracle/pdb1.xml' format '/home/oracle/pdb1_%U' pluggable database pdb1;
backup for transport unplug into '/home/oracle/pdb1.xml' format '/home/oracle/pdb1_%U' pluggable database pdb1;
Starting backup at 15-AUG-25
using channel ORA_DISK_1
running UNPLUG on the specified pluggable database: PDB1
UNPLUG file path : /home/oracle/pdb1.xml
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00017 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
input datafile file number=00016 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
input datafile file number=00018 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
input datafile file number=00019 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
channel ORA_DISK_1: starting piece 1 at 15-AUG-25
channel ORA_DISK_1: finished piece 1 at 15-AUG-25
piece handle=/home/oracle/pdb1_054176dp_5_1_1 tag=TAG20250815T210803 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 15-AUG-25RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ rman target / debug trace=/tmp/rman_debug1Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:08:40 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.RMAN-06005: connected to target database: ORA23AI (DBID=2427465694)RMAN> restore using '/home/oracle/pdb1.xml'
foreign pluggable database PDB3
format '/home/oracle/pdb3/%U'
from backupset '/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1';restore using '/home/oracle/pdb1.xml'
2> foreign pluggable database PDB3
3> format '/home/oracle/pdb3/%U'
4>
from backupset '/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1';
RMAN-03090: Starting restore at 15-AUG-25
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=276 device type=DISKRMAN-08016: channel ORA_DISK_1: starting datafile backup set restore
RMAN-08089: channel ORA_DISK_1: specifying datafile(s) to restore from backup set
RMAN-08622: channel ORA_DISK_1: restoring all foreign files in backup piece
RMAN-08003: channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1
RMAN-08626: channel ORA_DISK_1: restoring foreign file 17 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl
RMAN-08626: channel ORA_DISK_1: restoring foreign file 16 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl
RMAN-08626: channel ORA_DISK_1: restoring foreign file 18 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl
RMAN-08626: channel ORA_DISK_1: restoring foreign file 19 to /home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl
RMAN-08627: channel ORA_DISK_1: foreign piece handle=/u01/app/oracle/product/23/db_1/dbs/034175h1_3_1_1
RMAN-08023: channel ORA_DISK_1: restored backup piece 1
RMAN-08180: channel ORA_DISK_1: restore complete, elapsed time: 00:00:16
RMAN-08430: channel ORA_DISK_1: plugging file 4 for /home/oracle/pdb1/temp01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 16 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
RMAN-08430: channel ORA_DISK_1: plugging file 17 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
RMAN-08430: channel ORA_DISK_1: plugging file 18 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
RMAN-08430: channel ORA_DISK_1: plugging file 19 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/15/2025 21:09:57
RMAN-03009: failure of IRESTORE command on ORA_DISK_1 channel at 08/15/2025 21:09:57
ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container.
Help: https://docs.oracle.com/error-help/db/ora-65122/RMAN> exit
exitRecovery Manager complete.
[oracle@ora23ai ~]$ tail -500 /tmp/rman_debug1|more
DBGMISC: ENTERED krmzgetxttpluginf [21:09:57.544]
DBGMISC: EXITED krmzgetxttpluginf [21:09:57.544] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:09:57.544]
DBGMISC: EXITED krmzgchid [21:09:57.544] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:09:57.545]
RMAN-08430: channel ORA_DISK_1: plugging file 16 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
DBGMISC: EXITED krmzlog [21:09:57.545] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:09:57.545]
DBGMISC: EXITED krmzgetxttpluginf [21:09:57.545] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:09:57.545]
DBGMISC: EXITED krmzgchid [21:09:57.545] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:09:57.545]
RMAN-08430: channel ORA_DISK_1: plugging file 17 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
DBGMISC: EXITED krmzlog [21:09:57.546] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:09:57.546]
DBGMISC: EXITED krmzgetxttpluginf [21:09:57.546] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:09:57.546]
DBGMISC: EXITED krmzgchid [21:09:57.546] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:09:57.546]
RMAN-08430: channel ORA_DISK_1: plugging file 18 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
DBGMISC: EXITED krmzlog [21:09:57.547] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:09:57.547]
DBGMISC: EXITED krmzgetxttpluginf [21:09:57.547] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:09:57.547]
DBGMISC: EXITED krmzgchid [21:09:57.547] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:09:57.547]
RMAN-08430: channel ORA_DISK_1: plugging file 19 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
DBGMISC: EXITED krmzlog [21:09:57.547] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:09:57.547]
DBGMISC: EXITED krmzgetxttpluginf [21:09:57.548] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:09:57.548]
DBGMISC: EXITED krmzgchid [21:09:57.548] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmztrc [21:09:57.548]
DBGPLSQL: channel ORA_DISK_1: Calling doxttplug [21:09:57.548] (restore)
DBGMISC: EXITED krmztrc [21:09:57.548] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzxttplug [21:09:57.548]
DBGSQL: ENTERED krmkosqlerrDBGSQL: TARGET> CREATE PLUGGABLE DATABASE PDB3 USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/home/oracle/pdb1/data_D
-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb
3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl' , '/h
ome/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl' ) NOCOPY
DBGSQL: sqlcode = 65122
DBGSQL: error: ORA-65122: Pluggable database GUID conflicts with the GUID of an existing container. (krmkosqlerr)
DBGSQL: Help: https://docs.oracle.com/error-help/db/ora-65122/ (krmkosqlerr)
DBGSQL: (krmkosqlerr)
DBGSQL: EXITED krmkosqlerr
DBGMISC: krmkosqlexe called from file krmr.c, line 6837 has produced error 65122 at TARGET upon executing CREATE PLUGGABLE DATABASE PDB3 USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/hom
e/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl' , '/hom
e/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u
7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4
176gl' ) NOCOPY [21:09:57.588] (krmkosqlexe_impl)
DBGMISC: krmksqlerror called from file krmr.c, line 6851, cx: 94508159065512 for TARGET [21:09:57.589]
DBGMISC: Exception 6003 external exception thrown at krmkseqlerror@krmk3.c#5938 [21:09:57.589]
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:11:33 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl' ) NOCOPY
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl for
value of fcpsb (108028799 in the plug XML file, 108009543 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ cp pdb1.xml pdb1-3.xml
[oracle@ora23ai ~]$ vi pdb1.xml
ta_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl' ) NOCOPY
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl for
value of fcpsb (108028799 in the plug XML file, 108009543 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> exit
Disconnected from Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
[oracle@ora23ai ~]$ cp pdb1.xml pdb1-3.xml
[oracle@ora23ai ~]$ vi pdb1.xml
[oracle@ora23ai ~]$ sed -i s/108028799/108009543/g pdb1.xml
[oracle@ora23ai ~]$ grep 208009543 pdb1.xml
[oracle@ora23ai ~]$ grep 108009543 pdb1.xml<fcpsb>108009543</fcpsb><fcpsb>108009543</fcpsb><fcpsb>108009543</fcpsb><fcpsb>108009543</fcpsb>
[oracle@ora23ai ~]$ grep 108028799 pdb1.xml
[oracle@ora23ai ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:16:10 2025
Version 23.6.0.24.10Copyright (c) 1982, 2024, Oracle. All rights reserved.Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10SQL> CREATE PLUGGABLE DATABASE PDB3 AS CLONE USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb3/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-16_gu4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-17_4s4176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-18_p14176gl' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb3/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-19_ih4176gl' ) NOCOPY;Pluggable database created.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO3 PDB3 MOUNTED4 PDB1 MOUNTED6 PDB2 READ WRITE NO
SQL> alter database pluggable pdb3 open;
alter database pluggable pdb3 open*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
Help: https://docs.oracle.com/error-help/db/ora-02231/SQL> alter pluggable database pdb3 open;Pluggable database altered.SQL> show pdbs;CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------2 PDB$SEED READ ONLY NO3 PDB3 READ WRITE NO4 PDB1 MOUNTED6 PDB2 READ WRITE NO
SQL> [END] 2025/8/15 21:21:24
