搭建企业网站流程,欧模网室内设计网,谷德设计网app,做网站就上凡科建站cdb中有pdb1,pdb2
需求#xff1a;希望将在线热备份pdb1的备份集a#xff0c;恢复成pdb3#xff0c;使得cdb中有pdb1,2,3
参考到的#xff1a;RMAN备份恢复典型案例——跨平台迁移pdb - 墨天轮 ORA-65122: Pluggable Database GUID Conflicts With The GUID Of An Existi…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
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ pwd
/home/oracle
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ cp pdb1.xml
cp: missing destination file operand after pdb1.xml
Try cp --help for more information.
[oracleora23ai ~]$ cp pdb1.xml pdb1.xml.bak
[oracleora23ai ~]$ vi pdb1.xml
[oracleora23ai ~]$ grep guid pdb1.xmlguid29ED108305EC7E38E0653CDEB45D3AB5/guid
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID279 device typeDISKchannel 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.
[oracleora23ai ~]$ ll /u01/app/oracle/oradata/ora23aipdb01
total 0
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ cp pdb1.xml pdb2.xml
[oracleora23ai ~]$ vi pdb2.xml
[oracleora23ai ~]$ pwd
/home/oracle
[oracleora23ai ~]$ mkdir pdb2
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID32 device typeDISKchannel 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.
[oracleora23ai ~]$ vi pdb2.xml
RMAN exit
exit
Recovery Manager complete.
[oracleora23ai ~]$ vi pdb2.xml
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID276 device typeDISKchannel 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.
[oracleora23ai ~]$ 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.
//
[oracleora23ai ~]$ rman target /\^C
[oracleora23ai ~]$ 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 (DBID2427465694)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.
[oracleora23ai ~]$ vi pdb2.xml
[oracleora23ai ~]$ vi pdb2.xml
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID284 device typeDISKchannel 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.
[oracleora23ai ~]$ pwd
/home/oracle
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ cp pdb1.xml pdb2.xml
[oracleora23ai ~]$ vi pdb2.xml
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID284 device typeDISKchannel 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.
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID279 device typeDISKRMAN-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.dbfREATE 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 ) NOCOPYBLE 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 ) NOCOPY5 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.
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ pwd
/home/oracle
[oracleora23ai ~]$ cp pdb1.xml pdb2.xml
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ vi pdb2.xml
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID279 device typeDISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number00017 name/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
input datafile file number00016 name/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
input datafile file number00018 name/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
input datafile file number00019 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 tagTAG20250815T205249 commentNONE
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 commentNONE
Finished Control File Autobackup at 15-AUG-25RMAN exit
exitRecovery Manager complete.
[oracleora23ai ~]$ pwd
/home/oracle
[oracleora23ai ~]$ mkdir pdb3
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID29 device typeDISKchannel 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.
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID285 device typeDISKRMAN-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.
[oracleora23ai ~]$ vi /tmp/rman_debug
[oracleora23ai ~]$ 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 krmkseqlerrorkrmk3.c#5938 [20:56:46.924]
DBGMISC: Exception 6003 seen at krmzxttplugkrmz.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 krmxrkrmx.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 krmicekrmi.c#4688 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmicekrmi.c#5141 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmiep2krmi.c#1329 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmicekrmi.c#5141 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmiep2krmi.c#1329 [20:56:46.925]
DBGMISC: Exception 3009 seen at krmicompkrmi.c#6376 [20:56:46.925]
DBGMISC: krmicomp: error 3009 signalled during compilation [20:56:46.925]
DBGMISC: Exception 3002 external exception thrown at krmicompkrmi.c#6426 [20:56:46.925]
DBGMISC: Exception 3002 seen at krmice1krmi.c#7093 [20:56:46.925]
DBGMISC: Exception 3002 seen at krmicekrmi.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)
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ cp pdb1
pdb1/ pdb1_01417281_1_1_1 pdb1.xml pdb1.xml.bak
[oracleora23ai ~]$ cp pdb1
pdb1/ pdb1_01417281_1_1_1 pdb1.xml pdb1.xml.bak
[oracleora23ai ~]$ cp pdb1.xml pdb3.xml
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID156 device typeDISK
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 number00017 name/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
input datafile file number00016 name/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
input datafile file number00018 name/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
input datafile file number00019 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 tagTAG20250815T210803 commentNONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 15-AUG-25RMAN exit
exitRecovery Manager complete.
[oracleora23ai ~]$ 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 (DBID2427465694)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: SID276 device typeDISKRMAN-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.
[oracleora23ai ~]$ 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 krmkseqlerrorkrmk3.c#5938 [21:09:57.589]
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ cp pdb1.xml pdb1-3.xml
[oracleora23ai ~]$ 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
[oracleora23ai ~]$ cp pdb1.xml pdb1-3.xml
[oracleora23ai ~]$ vi pdb1.xml
[oracleora23ai ~]$ sed -i s/108028799/108009543/g pdb1.xml
[oracleora23ai ~]$ grep 208009543 pdb1.xml
[oracleora23ai ~]$ grep 108009543 pdb1.xmlfcpsb108009543/fcpsbfcpsb108009543/fcpsbfcpsb108009543/fcpsbfcpsb108009543/fcpsb
[oracleora23ai ~]$ grep 108028799 pdb1.xml
[oracleora23ai ~]$ 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
