接上篇：另类的pdb恢复方式-CSDN博客
[BEGIN] 2025/8/15 21:47:13
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:47:24 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PDB1 MOUNTED
6 PDB2 READ WRITE NO
SQL> alter pluggable database pdb1 open;
alter pluggable database pdb1 open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database
Help: https://docs.oracle.com/error-help/db/ora-65086/
SQL> !oerr ora 65086
65086, 00000, "cannot open/close the pluggable database"
// *Cause: The pluggable database has been unplugged.
// *Action: The pluggable database can only be dropped.
//
SQL> create pluggable database pdb1 using '/home/oracle/pdb1.xml' nocopy tempfile reuse;
create pluggable database pdb1 using '/home/oracle/pdb1.xml' nocopy tempfile reuse
*
ERROR at line 1:
ORA-65012: Pluggable database PDB1 already exists.
Help: https://docs.oracle.com/error-help/db/ora-65012/
SQL> drop pluggable database pdb1;
Pluggable database dropped.
SQL> create pluggable database pdb1 using '/home/oracle/pdb1.xml' nocopy tempfile reuse;
create pluggable database pdb1 using '/home/oracle/pdb1.xml' nocopy tempfile reuse
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of fcpsb (108009543 in the plug XML file, 108028799 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> !
[oracle@ora23ai ~]$ ll pdb1*
-rw-r----- 1 oracle oinstall 1831501824 Aug 15 19:57 pdb1_01417281_1_1_1
-rw-r----- 1 oracle oinstall 1523965952 Aug 15 21:08 pdb1_054176dp_5_1_1
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:14 pdb1-3.xml
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:15 pdb1.xml
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:07 pdb1.xml.bak
pdb1:
total 8334432
-rw-r----- 1 oracle oinstall 10493952 Aug 15 21:08 data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
-rw-r----- 1 oracle oinstall 10493952 Aug 15 20:03 data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_524172kq
-rw-r----- 1 oracle oinstall 10493952 Aug 15 20:12 data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_g5417363
-rw-r----- 1 oracle oinstall 2147491840 Aug 15 21:08 data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
-rw-r----- 1 oracle oinstall 2147491840 Aug 15 20:12 data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_10417363
-rw-r----- 1 oracle oinstall 2147491840 Aug 15 20:03 data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_lt4172kq
-rw-r----- 1 oracle oinstall 367009792 Aug 15 20:03 data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_2u4172kq
-rw-r----- 1 oracle oinstall 367009792 Aug 15 20:12 data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_91417363
-rw-r----- 1 oracle oinstall 367009792 Aug 15 21:08 data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
-rw-r----- 1 oracle oinstall 319823872 Aug 15 21:08 data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
-rw-r----- 1 oracle oinstall 319823872 Aug 15 20:12 data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_lg417363
-rw-r----- 1 oracle oinstall 319823872 Aug 15 20:03 data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_q34172kq
[oracle@ora23ai ~]$ exit
exit
SQL> l1
1* create pluggable database pdb1 using '/home/oracle/pdb1.xml' nocopy tempfile reuse
SQL> create pluggable database pdb1 using '/home/oracle/pdb1-3.xml' nocopy tempfile reuse;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
6 PDB2 READ WRITE NO
7 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 NO
3 PDB3 READ WRITE NO
6 PDB2 READ WRITE NO
7 PDB1 READ WRITE NO
SQL> alter session set container=pdb1;
Session altered.
SQL> insert into ora23aipdb01.test values(1);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from ora23aipdb01.test;
ID
----------
1
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:54:45 2025
Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORA23AI (DBID=2427465694)
RMAN> backup pluggable database pdb1 format '/home/oracle/pdb1-4-%U';
backup pluggable database pdb1 format '/home/oracle/pdb1-4-%U';
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=278 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=00029 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
input datafile file number=00028 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
input datafile file number=00030 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
input datafile file number=00031 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-4-0741796l_7_1_1 tag=TAG20250815T215533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 15-AUG-25
Starting Control File Autobackup at 15-AUG-25
piece handle=/u01/app/oracle/product/23/db_1/dbs/c-2427465694-20250815-03 comment=NONE
Finished Control File Autobackup at 15-AUG-25
RMAN> exit
exit
Recovery Manager complete.
[oracle@ora23ai ~]$ mkdir pdb4
[oracle@ora23ai ~]$ pwd
/home/oracle
[oracle@ora23ai ~]$ ll
total 4800888
-rw-r--r--. 1 oracle oinstall 2068 Dec 23 2024 db_install.rsp
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 21:53 pdb1
-rw-r----- 1 oracle oinstall 1831501824 Aug 15 19:57 pdb1_01417281_1_1_1
-rw-r----- 1 oracle oinstall 1523965952 Aug 15 21:08 pdb1_054176dp_5_1_1
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:14 pdb1-3.xml
-rw-r----- 1 oracle oinstall 1560559616 Aug 15 21:55 pdb1-4-0741796l_7_1_1
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:15 pdb1.xml
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:07 pdb1.xml.bak
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 20:49 pdb2
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:56 pdb2.xml
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 21:16 pdb3
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 21:04 pdb3.xml
drwxr-xr-x 2 oracle oinstall 6 Aug 15 21:57 pdb4
-rw-r----- 1 oracle oinstall 3316 May 13 17:16 sqlnet.log
[oracle@ora23ai ~]$ ls -lt
total 4800888
drwxr-xr-x 2 oracle oinstall 6 Aug 15 21:57 pdb4
-rw-r----- 1 oracle oinstall 1560559616 Aug 15 21:55 pdb1-4-0741796l_7_1_1
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 21:53 pdb1
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 21:16 pdb3
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:15 pdb1.xml
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:14 pdb1-3.xml
-rw-r----- 1 oracle oinstall 1523965952 Aug 15 21:08 pdb1_054176dp_5_1_1
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 21:04 pdb3.xml
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:56 pdb2.xml
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 20:49 pdb2
-rw-r--r-- 1 oracle oinstall 9534 Aug 15 20:07 pdb1.xml.bak
-rw-r----- 1 oracle oinstall 1831501824 Aug 15 19:57 pdb1_01417281_1_1_1
-rw-r----- 1 oracle oinstall 3316 May 13 17:16 sqlnet.log
-rw-r--r--. 1 oracle oinstall 2068 Dec 23 2024 db_install.rsp
[oracle@ora23ai ~]$ rman target / debug trace=/tmp/rman_debug1-4
Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 21:58:34 2025
Version 23.6.0.24.10
Copyright (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 PDB4
format '/home/oracle/pdb4/%U'
from backupset '/home/oracle/pdb1-4-0741796l_7_1_1';restore using '/home/oracle/pdb1.xml'
2> foreign pluggable database PDB4
3> format '/home/oracle/pdb4/%U'
4>
from backupset '/home/oracle/pdb1-4-0741796l_7_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=13 device type=DISK
RMAN-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-4-0741796l_7_1_1
RMAN-08626: channel ORA_DISK_1: restoring foreign file 29 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_vp4179cr
RMAN-08626: channel ORA_DISK_1: restoring foreign file 28 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_9a4179cr
RMAN-08626: channel ORA_DISK_1: restoring foreign file 30 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_3f4179cr
RMAN-08626: channel ORA_DISK_1: restoring foreign file 31 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_ge4179cr
RMAN-08627: channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1-4-0741796l_7_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:59:07
RMAN-03009: failure of IRESTORE command on ORA_DISK_1 channel at 08/15/2025 21:59:07
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
exit
Recovery Manager complete.
[oracle@ora23ai ~]$ tail -500 /tmp/rman_debug1-4|more
DBGMISC: ENTERED krmzgetxttpluginf [21:59:07.499]
DBGMISC: EXITED krmzgetxttpluginf [21:59:07.499] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:59:07.499]
DBGMISC: EXITED krmzgchid [21:59:07.499] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:59:07.499]
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:59:07.500] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:59:07.500]
DBGMISC: EXITED krmzgetxttpluginf [21:59:07.500] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:59:07.500]
DBGMISC: EXITED krmzgchid [21:59:07.500] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:59:07.500]
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:59:07.501] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:59:07.501]
DBGMISC: EXITED krmzgetxttpluginf [21:59:07.501] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:59:07.501]
DBGMISC: EXITED krmzgchid [21:59:07.501] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:59:07.501]
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:59:07.501] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:59:07.501]
DBGMISC: EXITED krmzgetxttpluginf [21:59:07.501] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:59:07.502]
DBGMISC: EXITED krmzgchid [21:59:07.502] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [21:59:07.502]
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:59:07.502] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [21:59:07.502]
DBGMISC: EXITED krmzgetxttpluginf [21:59:07.502] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [21:59:07.502]
DBGMISC: EXITED krmzgchid [21:59:07.502] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmztrc [21:59:07.502]
DBGPLSQL: channel ORA_DISK_1: Calling doxttplug [21:59:07.502] (restore)
DBGMISC: EXITED krmztrc [21:59:07.502] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzxttplug [21:59:07.502]
DBGSQL: ENTERED krmkosqlerr
DBGSQL: TARGET> CREATE PLUGGABLE DATABASE PDB4 USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D
-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb
4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/h
ome/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) 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 PDB4 USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/hom
e/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/hom
e/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u
7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4
172u7' ) NOCOPY [21:59:07.537] (krmkosqlexe_impl)
DBGMISC: krmksqlerror called from file krmr.c, line 6851, cx: 94899271232936 for TARGET [21:59:07.538]
DBGMISC: Exception 6003 external exception thrown at krmkseqlerror@krmk3.c#5938 [21:59:07.538]
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:00:18 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
6 PDB2 READ WRITE NO
7 PDB1 READ WRITE NO
SQL> CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) NOCOPY
*
ERROR at line 1:
ORA-19505: failed to identify file
"/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7"
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> 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 22:05:24 2025
Version 23.6.0.24.10
Copyright (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-4.xml' format '/home/oracle/pdb1-4-2_%U' pluggable database pdb1;
backup for transport unplug into '/home/oracle/pdb1-4.xml' format '/home/oracle/pdb1-4-2_%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=412 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 22:05:31
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 close immediate;
alter pluggable database pdb1 close immediate;
Statement processed
RMAN> backup for transport unplug into '/home/oracle/pdb1-4.xml' format '/home/oracle/pdb1-4-2_%U' pluggable database pdb1;
backup for transport unplug into '/home/oracle/pdb1-4.xml' format '/home/oracle/pdb1-4-2_%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-4.xml
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00029 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
input datafile file number=00028 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
input datafile file number=00030 name=/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
input datafile file number=00031 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-4-2_094179r7_9_1_1 tag=TAG20250815T220626 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 15-AUG-25
RMAN> exit
exit
Recovery Manager complete.
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:06:53 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
6 PDB2 READ WRITE NO
7 PDB1 MOUNTED
SQL> CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) NOCOPY
*
ERROR at line 1:
ORA-19505: failed to identify file
"/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7"
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> 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 / debug trace=/tmp/rman_debug1-4-2
Recovery Manager: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:08:22 2025
Version 23.6.0.24.10
Copyright (c) 1982, 2024, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: ORA23AI (DBID=2427465694)
RMAN>
RMAN> restore using '/home/oracle/pdb1-4.xml'
foreign pluggable database PDB4
format '/home/oracle/pdb4/%U'
from backupset '/home/oracle/pdb1-4-2_094179r7_9_1_1';restore using '/home/oracle/pdb1-4.xml'
2> foreign pluggable database PDB4
3> format '/home/oracle/pdb4/%U'
4>
from backupset '/home/oracle/pdb1-4-2_094179r7_9_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=DISK
RMAN-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-4-2_094179r7_9_1_1
RMAN-08626: channel ORA_DISK_1: restoring foreign file 29 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t
RMAN-08626: channel ORA_DISK_1: restoring foreign file 28 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t
RMAN-08626: channel ORA_DISK_1: restoring foreign file 30 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t
RMAN-08626: channel ORA_DISK_1: restoring foreign file 31 to /home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t
RMAN-08627: channel ORA_DISK_1: foreign piece handle=/home/oracle/pdb1-4-2_094179r7_9_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 6 for /home/oracle/pdb1/temp01.dbf
RMAN-08430: channel ORA_DISK_1: plugging file 28 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
RMAN-08430: channel ORA_DISK_1: plugging file 29 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
RMAN-08430: channel ORA_DISK_1: plugging file 30 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
RMAN-08430: channel ORA_DISK_1: plugging file 31 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 22:09:49
RMAN-03009: failure of IRESTORE command on ORA_DISK_1 channel at 08/15/2025 22:09: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> exit
exit
Recovery Manager complete.
[oracle@ora23ai ~]$ tail -450 /tmp/rman_debug1-4-2|more
DBGMISC: Trimming message: ORA-06512: at "KRMICD", line 1497 [22:09:49.477] (krmstrim)
DBGMISC: ORA-06512: at line 26 (krmstrim)
DBGMISC: (56) (krmstrim)
DBGMISC: EXITED krmstrim with status 56 [22:09:49.477] elapsed time [00:00:00:00.000]
DBGMISC: Exception 10032 external exception recorded but not thrown at krmxr@krmx.c#2607 [22:09:49.478]
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 [22:09:49.478]
DBGMISC: EXITED krmiexe with status 1 [22:09:49.478] elapsed time [00:00:00:16.136]
DBGMISC: krmice: Command 'IRESTORE' execution has failed on channel ORA_DISK_1: krmice1 return code is 1 [22:09:49.478]
DBGMISC: Exception 3009 external exception thrown at krmice@krmi.c#4688 [22:09:49.478]
DBGMISC: Exception 3009 seen at krmice@krmi.c#5141 [22:09:49.478]
DBGMISC: Exception 3009 seen at krmiep2@krmi.c#1329 [22:09:49.478]
DBGMISC: Exception 3009 seen at krmice@krmi.c#5141 [22:09:49.478]
DBGMISC: Exception 3009 seen at krmiep2@krmi.c#1329 [22:09:49.478]
DBGMISC: Exception 3009 seen at krmicomp@krmi.c#6376 [22:09:49.478]
DBGMISC: krmicomp: error 3009 signalled during compilation [22:09:49.478]
DBGMISC: Exception 3002 external exception thrown at krmicomp@krmi.c#6426 [22:09:49.478]
DBGMISC: Exception 3002 seen at krmice1@krmi.c#7093 [22:09:49.478]
DBGMISC: Exception 3002 seen at krmice@krmi.c#5141 [22:09:49.478]
DBGMISC: ENTERED krmkmrsr [22:09:49.478]
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 = 0
DBGSQL: TARGET> select decode(open_mode, 'READ WRITE', 1, 0) into :read_write from v$database
DBGSQL: sqlcode = 0
DBGSQL: D :read_write = 1
DBGSQL: TARGET> select value into :vcomp_txt from v$parameter where name = 'compatible'
DBGSQL: sqlcode = 0
DBGSQL: D :vcomp_txt = 23.6.0
DBGSQL: 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 [22:09:49.488]
DBGSQL: ENTERED krmkosqlerr
DBGSQL: 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 = 46
DBGSQL: B :row_stamp = 1209247771
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)
DBGSQL: EXITED krmkosqlerr
[oracle@ora23ai ~]$ tail -500 /tmp/rman_debug1-4-2|more
DBGMISC: ENTERED krmzgetxttpluginf [22:09:49.442]
DBGMISC: EXITED krmzgetxttpluginf [22:09:49.442] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [22:09:49.442]
DBGMISC: EXITED krmzgchid [22:09:49.442] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [22:09:49.442]
RMAN-08430: channel ORA_DISK_1: plugging file 28 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
DBGMISC: EXITED krmzlog [22:09:49.442] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [22:09:49.442]
DBGMISC: EXITED krmzgetxttpluginf [22:09:49.442] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [22:09:49.442]
DBGMISC: EXITED krmzgchid [22:09:49.442] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [22:09:49.442]
RMAN-08430: channel ORA_DISK_1: plugging file 29 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
DBGMISC: EXITED krmzlog [22:09:49.443] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [22:09:49.443]
DBGMISC: EXITED krmzgetxttpluginf [22:09:49.443] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [22:09:49.443]
DBGMISC: EXITED krmzgchid [22:09:49.443] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [22:09:49.443]
RMAN-08430: channel ORA_DISK_1: plugging file 30 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
DBGMISC: EXITED krmzlog [22:09:49.444] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [22:09:49.444]
DBGMISC: EXITED krmzgetxttpluginf [22:09:49.444] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [22:09:49.444]
DBGMISC: EXITED krmzgchid [22:09:49.444] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzlog [22:09:49.444]
RMAN-08430: channel ORA_DISK_1: plugging file 31 for /home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
DBGMISC: EXITED krmzlog [22:09:49.444] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgetxttpluginf [22:09:49.444]
DBGMISC: EXITED krmzgetxttpluginf [22:09:49.444] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzgchid [22:09:49.445]
DBGMISC: EXITED krmzgchid [22:09:49.445] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmztrc [22:09:49.445]
DBGPLSQL: channel ORA_DISK_1: Calling doxttplug [22:09:49.445] (restore)
DBGMISC: EXITED krmztrc [22:09:49.445] elapsed time [00:00:00:00.000]
DBGMISC: ENTERED krmzxttplug [22:09:49.445]
DBGSQL: ENTERED krmkosqlerr
DBGSQL: TARGET> CREATE PLUGGABLE DATABASE PDB4 USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data
_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/p
db4/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) 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 PDB4 USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/h
ome/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/h
ome/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a417
2u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d
8417a0t' ) NOCOPY [22:09:49.476] (krmkosqlexe_impl)
DBGMISC: krmksqlerror called from file krmr.c, line 6851, cx: 94733328973224 for TARGET [22:09:49.477]
DBGMISC: Exception 6003 external exception thrown at krmkseqlerror@krmk3.c#5938 [22:09:49.477]
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:14:40 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
6 PDB2 READ WRITE NO
7 PDB1 MOUNTED
SQL> CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/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/pdb4/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/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' ) NOCOPY
*
ERROR at line 1:
ORA-19505: failed to identify file
"/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7"
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> CREATE PLUGGABLE DATABASE PDB4 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb4/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb4/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) NOCOPY;
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
5 PDB4 MOUNTED
6 PDB2 READ WRITE NO
7 PDB1 MOUNTED
SQL> !ls -l /home/oracle/pdb4
total 5556344
-rw-r----- 1 oracle oinstall 10493952 Aug 15 22:15 data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t
-rw-r----- 1 oracle oinstall 10493952 Aug 15 21:58 data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_ge4179cr
-rw-r----- 1 oracle oinstall 2147491840 Aug 15 22:15 data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t
-rw-r----- 1 oracle oinstall 2147491840 Aug 15 21:59 data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_vp4179cr
-rw-r----- 1 oracle oinstall 367009792 Aug 15 21:58 data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_9a4179cr
-rw-r----- 1 oracle oinstall 367009792 Aug 15 22:15 data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t
-rw-r----- 1 oracle oinstall 319823872 Aug 15 21:58 data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_3f4179cr
-rw-r----- 1 oracle oinstall 319823872 Aug 15 22:15 data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t
-rw-r----- 1 oracle oinstall 20979712 Aug 15 22:15 temp01.dbf
SQL> !mkdir /home/oracle/pdb5
SQL> CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb5/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) NOCOPY;
CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb5/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) NOCOPY
*
ERROR at line 1:
ORA-19505: failed to identify file
"/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t"
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> CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb5/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) COPY;
CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb5/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) COPY
*
ERROR at line 1:
ORA-65018: FILE_NAME_CONVERT or NOCOPY must be specified
Help: https://docs.oracle.com/error-help/db/ora-65018/
SQL> !oerr ora 65018
65018, 00000, "FILE_NAME_CONVERT or NOCOPY must be specified"
// *Cause: Oracle Managed Files (OMF) was not enabled and
// PDB_FILE_NAME_CONVERT was not defined.
// The FILE_NAME_CONVERT or the NOCOPY clause was not specified
// as a part of creating a pluggable database using data files.
// *Action: Enable OMF or define PDB_FILE_NAME_CONVERT system parameter before
// issuing CREATE PLUGGABLE DATABASE statement, or specify
// FILE_NAME_CONVERT clause or NOCOPY as a part of the statement.
//
SQL> CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb5/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb5/');
CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' SOURCE_FILE_NAME_CONVERT = ( '/home/oracle/pdb1/temp01.dbf' , '/home/oracle/pdb5/temp01.dbf' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-29_de417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-30_eh417a0t' , '/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7' , '/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-31_d8417a0t' ) file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb5/')
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/home/oracle/pdb5/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-28_lu417a0t
Help: https://docs.oracle.com/error-help/db/ora-65005/
SQL> !oerr ora 65005
65005, 00000, "missing or invalid file name pattern for file - %s"
// *Cause: Either source or replacement file name pattern was missing or
// invalid in a SOURCE_FILE_NAME_CONVERT or FILE_NAME_CONVERT clause.
// *Action: Correct the SOURCE_FILE_NAME_CONVERT or FILE_NAME_CONVERT clause
// and reissue the statement.
//
SQL> CREATE PLUGGABLE DATABASE PDB5 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb5/');
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PDB5 MOUNTED
5 PDB4 MOUNTED
6 PDB2 READ WRITE NO
7 PDB1 MOUNTED
SQL> !ls -l /home/oracle/pdb5/
total 2778200
-rw-r----- 1 oracle oinstall 10493952 Aug 15 22:22 data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7
-rw-r----- 1 oracle oinstall 2147491840 Aug 15 22:22 data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7
-rw-r----- 1 oracle oinstall 367009792 Aug 15 22:22 data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7
-rw-r----- 1 oracle oinstall 319823872 Aug 15 22:22 data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7
-rw-r----- 1 oracle oinstall 20979712 Aug 15 22:22 temp01.dbf
SQL> !ls -l /home/oracle/pdb1*.xml
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:14 /home/oracle/pdb1-3.xml
-rw-r--r-- 1 oracle oinstall 9602 Aug 15 22:09 /home/oracle/pdb1-4.xml
-rw-r--r-- 1 oracle oinstall 9605 Aug 15 21:59 /home/oracle/pdb1.xml
SQL> alter pluggable database pdb1 open;
alter pluggable database pdb1 open
*
ERROR at line 1:
ORA-65086: cannot open/close the pluggable database
Help: https://docs.oracle.com/error-help/db/ora-65086/
SQL> alter pluggable database pdb5 open;
Pluggable database altered.
SQL> alter pluggable database pdb4 open;
Pluggable database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PDB5 READ WRITE NO
5 PDB4 READ WRITE NO
6 PDB2 READ WRITE NO
7 PDB1 MOUNTED
SQL> drop pluggable database pdb1 ;
Pluggable database dropped.
SQL> create pluggable database pdb1 using '/home/oracle/pdb1-3.xml' nocopy tempfile reuse;
create pluggable database pdb1 using '/home/oracle/pdb1-3.xml' nocopy tempfile reuse
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of cid (4 in the plug XML file, 7 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> create pluggable database pdb1 using '/home/oracle/pdb1-4.xml' nocopy tempfile reuse;
Pluggable database created.
SQL> alter pluggable database pdb1 open;
Pluggable database altered.
SQL> alter session set container=pdb1;
Session altered.
SQL> insert into ora23aipdb01.test values(3);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from ora23aipdb01.test;
ID
----------
1
3
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65040: Operation is not allowed from within a pluggable database.
Help: https://docs.oracle.com/error-help/db/ora-65040/
SQL> !oerr ora 65040
65040, 00000, "Operation is not allowed from within a pluggable database."
// *Cause: An operation was attempted that can only be performed in the root
// or application root container.
// *Action: Switch to the root or application root container to perform the
// operation.
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 ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:30:31 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of cid (7 in the plug XML file, 9 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-4.xml pdb1-6.xml
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ grep cid pdb1-6.xml
<cid>9</cid>
[oracle@ora23ai ~]$ grep cid pdb1-4.xml
<cid>7</cid>
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:32:09 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of cid (7 in the plug XML file, 9 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of afn (28 in the plug XML file, 40 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 ~]$ grep afn pdb1-4.xml
<afn>28</afn>
<fafn>28</fafn>
<plugafn>0</plugafn>
<afn>29</afn>
<fafn>29</fafn>
<plugafn>0</plugafn>
<afn>30</afn>
<fafn>30</fafn>
<plugafn>0</plugafn>
<afn>6</afn>
<fafn>0</fafn>
<plugafn>0</plugafn>
<afn>31</afn>
<fafn>31</fafn>
<plugafn>0</plugafn>
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:34:30 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of createscnbas (108036707 in the plug XML file, 108056790 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 ~]$ grep 108036707 pdb1-6.xml
<createscnbas>108036707</createscnbas>
[oracle@ora23ai ~]$ sed -i s/108036707/108056790/g pdb1-6.xml
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:36:02 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSTEM_FNO-12_bp4172u7 for
value of fcpsb (108049464 in the plug XML file, 108056939 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 ~]$ grep 108049464 pdb1-6.xml
<fcpsb>108049464</fcpsb>
<fcpsb>108049464</fcpsb>
<fcpsb>108049464</fcpsb>
<fcpsb>108049464</fcpsb>
[oracle@ora23ai ~]$ sed -i s/CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');/108056790/G^Cdb1-6.xml
[oracle@ora23ai ~]$ sed -i s/108049464/108056939/g pdb1-6.xml
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:37:20 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7 for
value of afn (29 in the plug XML file, 41 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 ~]$ grep 29 pdb1-6.xml
<guid>29ED108305EC7E38E0653CDEB45D3AB5</guid>
<maxsize>4294967293</maxsize>
<afn>29</afn>
<fafn>29</fafn>
<maxsize>4294967293</maxsize>
<maxsize>4294967293</maxsize>
<maxsize>4294967293</maxsize>
[oracle@ora23ai ~]$ vi pdb1-6.xml
Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.6.0.24.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7 for
value of afn (29 in the plug XML file, 41 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 ~]$ grep 29 pdb1-6.xml
<guid>29ED108305EC7E38E0653CDEB45D3AB5</guid>
<maxsize>4294967293</maxsize>
<afn>29</afn>
<fafn>29</fafn>
<maxsize>4294967293</maxsize>
<maxsize>4294967293</maxsize>
<maxsize>4294967293</maxsize>
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ vi pdb1-6.xml
Version 23.6.0.24.10
[oracle@ora23ai ~]$ grep 108049464 pdb1-6.xml
<fcpsb>108049464</fcpsb>
<fcpsb>108049464</fcpsb>
<fcpsb>108049464</fcpsb>
<fcpsb>108049464</fcpsb>
[oracle@ora23ai ~]$ sed -i s/CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-4.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');/108056790/G^Cdb1-6.xml
[oracle@ora23ai ~]$ sed -i s/108049464/108056939/g pdb1-6.xml
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:37:20 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7 for
value of afn (29 in the plug XML file, 41 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 ~]$ grep 29 pdb1-6.xml
<guid>29ED108305EC7E38E0653CDEB45D3AB5</guid>
<maxsize>4294967293</maxsize>
<afn>29</afn>
<fafn>29</fafn>
<maxsize>4294967293</maxsize>
<maxsize>4294967293</maxsize>
<maxsize>4294967293</maxsize>
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Fri Aug 15 22:39:09 2025
Version 23.6.0.24.10
Copyright (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.10
SQL> CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/');
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-SYSAUX_FNO-13_0c4172u7 for
value of createscnbas (108036713 in the plug XML file, 108056796 in the data
file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> !
[oracle@ora23ai ~]$ grep 108036713 pdb1-6.xml
<createscnbas>108036713</createscnbas>
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ exit
exit
SQL> r
1* CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7 for
value of afn (30 in the plug XML file, 42 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> !
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ exit
exit
SQL> /
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-UNDOTBS1_FNO-14_2a4172u7 for
value of createscnbas (108036714 in the plug XML file, 108056797 in the data
file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> !
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ exit
exit
SQL> /
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7 for value
of afn (31 in the plug XML file, 43 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> !
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ exit
exit
SQL> /
CREATE PLUGGABLE DATABASE PDB6 AS CLONE USING '/home/oracle/pdb1-6.xml' file_name_convert=('/home/oracle/pdb1/','/home/oracle/pdb6/')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/home/oracle/pdb1/data_D-ORA23AI_I-2427465694_TS-JYC_FNO-15_4l4172u7 for value
of createscnbas (108036715 in the plug XML file, 108056798 in the data file)
Help: https://docs.oracle.com/error-help/db/ora-65139/
SQL> !
[oracle@ora23ai ~]$ vi pdb1-6.xml
[oracle@ora23ai ~]$ exit
exit
SQL> /
Pluggable database created.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB3 READ WRITE NO
4 PDB5 READ WRITE NO
5 PDB4 READ WRITE NO
6 PDB2 READ WRITE NO
9 PDB1 READ WRITE NO
12 PDB6 MOUNTED
SQL> alter pluggable database pdb6 open;
Pluggable database altered.
SQL> alter session set container=pdb6;
Session altered.
SQL> select * from ora23aipdb01.test;
ID
----------
1
3
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 ~]$
[END] 2025/8/15 22:44:29