Pluggable Databases - Expert Consolidation in Oracle Database 12c - page 240

MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE '/u01/oradata/CDB3/system01.dbf'
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oradata/CDB3/sysaux01.dbf'
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP
TEMPFILE '/u01/oradata/CDB3/temp01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1"
DATAFILE '/u01/oradata/CDB3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE
GROUP 1 ('/u01/oradata/CDB3/redo01.log') SIZE 50M,
GROUP 2 ('/u01/oradata/CDB3/redo02.log') SIZE 50M,
GROUP 3 ('/u01/oradata/CDB3/redo03.log') SIZE 50M
USER SYS IDENTIFIED BY "&&sysPassword"
USER SYSTEM IDENTIFIED BY "&&systemPassword"
enable pluggable database
seed file_name_convert=(
'/u01/oradata/CDB3/system01.dbf','/u01/oradata/CDB3/pdbseed/system01.dbf',
'/u01/oradata/CDB3/sysaux01.dbf','/u01/oradata/CDB3/pdbseed/sysaux01.dbf',
'/u01/oradata/CDB3/temp01.dbf','/u01/oradata/CDB3/pdbseed/temp01.dbf',
'/u01/oradata/CDB3/undotbs01.dbf','/u01/oradata/CDB3/pdbseed/undotbs01.dbf'
);
The dbca-generated script creates a much longer seed file name convert statement—one for each data file
in the CDB. Please bear in mind that the above command is just an example—please review it and modify values
appropriately.
teStING the FILe_NaMe_CONVert paraMeterS
the file_name_convert parameters are well known to Oracle Dbas who have cloned databases using rMaN in
the past. the parameter seems to be equivalent to the replace( ) function in sQl. this makes for easy testing.
Connect to your database as an administrative user and issue the following query:
SQL> select file_name,
2 replace(file_name,
3 'string to be matched', 'string to replace match with')
4 from dba_data_files;
the resulting output of the replace function will tell you the location of the data file with the conversion parameter
applied.