数据库版本：Version 19.18.0.0.0
源数据库文件信息：
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 890 SYSTEM YES /u01/app/oracle/oradata/CDB/system01.dbf
3 560 SYSAUX NO /u01/app/oracle/oradata/CDB/sysaux01.dbf
4 280 UNDOTBS1 YES /u01/app/oracle/oradata/CDB/undotbs01.dbf
5 270 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/CDB/pdbseed/system01.dbf
6 330 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/CDB/pdbseed/sysaux01.dbf
7 5 USERS NO /u01/app/oracle/oradata/CDB/users01.dbf
8 100 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/CDB/pdbseed/undotbs01.dbf
16 270 PDB01:SYSTEM YES /u01/app/oracle/oradata/CDB/pdb01/system01.dbf
17 340 PDB01:SYSAUX NO /u01/app/oracle/oradata/CDB/pdb01/sysaux01.dbf
18 100 PDB01:UNDOTBS1 YES /u01/app/oracle/oradata/CDB/pdb01/undotbs01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 /u01/app/oracle/oradata/CDB/temp01.dbf
2 36 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/CDB/pdbseed/temp012023-03-14_05-17-44-972-AM.dbf
4 36 PDB01:TEMP 32767 /u01/app/oracle/oradata/CDB/pdb01/temp012023-03-14_05-17-44-972-AM.dbf
#本次操作在同一台主机克隆源数据库：
@在同一机器执行克隆操作pdb环境需要指定PDB_FILE_NAME_CONVERT参数，否则会有问题。
执行命令：
dbca -silent \
-createDuplicateDB -gdbName sbcdb -sid sbcdb \
-dbUniqueName sbcdb -sysPassword oracle \
-primaryDBConnectionString ora02:1521/cdb \
-datafileDestination /u01/db/sbcdb -storageType FS \
-initParams db_recovery_file_dest=/u01/arc2,PDB_FILE_NAME_CONVERT="/u01/app/oracle/oradata/CDB/,/u01/db/sbcdb/"
执行结果：
[oracle@ora02 ~]$ dbca -silent \
> -createDuplicateDB -gdbName sbcdb -sid sbcdb \
> -dbUniqueName sbcdb -sysPassword oracle \
> -primaryDBConnectionString ora02:1521/cdb \
> -datafileDestination /u01/db/sbcdb -storageType FS \
> -initParams db_recovery_file_dest=/u01/arc2,PDB_FILE_NAME_CONVERT="/u01/app/oracle/oradata/CDB/,/u01/db/sbcdb/"
Prepare for db operation
22% complete
Listener config step
44% complete
Auxiliary instance creation
67% complete
RMAN duplicate
89% complete
Post duplicate database operations
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/sbcdb/sbcdb1.log" for further details.
[oracle@ora02 ~]$ [oracle@ora02 ~]$ export ORACLE_SID=sbcdb
[oracle@ora02 ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Aug 17 14:35:39 2023
Version 19.18.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
report schPL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current
connected to target database: SBCDB (DBID=1540513692)
RMAN> ema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name SBCDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 890 SYSTEM YES /u01/db/sbcdb/system01.dbf
3 560 SYSAUX NO /u01/db/sbcdb/sysaux01.dbf
4 280 UNDOTBS1 YES /u01/db/sbcdb/undotbs01.dbf
5 270 PDB$SEED:SYSTEM NO /u01/db/sbcdb/pdbseed/system01.dbf
6 330 PDB$SEED:SYSAUX NO /u01/db/sbcdb/pdbseed/sysaux01.dbf
7 5 USERS NO /u01/db/sbcdb/users01.dbf
8 100 PDB$SEED:UNDOTBS1 NO /u01/db/sbcdb/pdbseed/undotbs01.dbf
16 270 PDB01:SYSTEM YES /u01/db/sbcdb/PDB01/system01.dbf
17 340 PDB01:SYSAUX NO /u01/db/sbcdb/PDB01/sysaux01.dbf
18 100 PDB01:UNDOTBS1 YES /u01/db/sbcdb/PDB01/undotbs01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 /u01/db/sbcdb/temp01.dbf
2 36 PDB$SEED:TEMP 32767 /u01/db/sbcdb/pdbseed/temp012023-03-14_05-17-44-972-AM.dbf
4 36 PDB01:TEMP 32767 /u01/db/sbcdb/PDB01/temp012023-03-14_05-17-44-972-AM.dbf
RMAN> exit
Recovery Manager complete.
[oracle@ora02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 17 14:37:19 2023
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.18.0.0.0
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
