本文主要使用:
1,FILE_NAME_CONVERT clause
2,CREATE_FILE_DEST clause
3,Oracle Managed Files
4,PDB_FILE_NAME_CONVERT initialization parameter
// if the file_name_convert_clause is not specified and Oracle Managed Files is not enabled.
FILE_NAME_CONVERT
CREATE PLUGGABLE DATABASE pdb02 ADMIN USER adm IDENTIFIED BY adm FILE_NAME_CONVERT=('pdbseed','pdb02');
CREATE_FILE_DEST
CREATE PLUGGABLE DATABASE pdb03 ADMIN USER adm IDENTIFIED BY adm CREATE_FILE_DEST='/pdb';
PDB_FILE_NAME_CONVERT
alter session set pdb_file_name_convert='/u01/app/oracle/oradata/CDB/pdbseed','/pdb';
CREATE PLUGGABLE DATABASE pdb04 ADMIN USER adm IDENTIFIED BY adm ;
OMF管理
alter system set db_create_file_dest='/u01/app/oracle/oradata/CDB';
CREATE PLUGGABLE DATABASE pdb05 ADMIN USER adm IDENTIFIED BY adm ;
文件位置:
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 900 SYSTEM YES /u01/app/oracle/oradata/CDB/system01.dbf
2 270 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/CDB/pdbseed/system01.dbf
3 630 SYSAUX NO /u01/app/oracle/oradata/CDB/sysaux01.dbf
4 295 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/CDB/pdbseed/sysaux01.dbf
5 685 UNDOTBS1 YES /u01/app/oracle/oradata/CDB/undotbs01.dbf
6 445 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/CDB/pdbseed/undotbs01.dbf
7 5 USERS NO /u01/app/oracle/oradata/CDB/users01.dbf
33 270 PDB02:SYSTEM NO /u01/app/oracle/oradata/CDB/pdb02/system01.dbf
34 295 PDB02:SYSAUX NO /u01/app/oracle/oradata/CDB/pdb02/sysaux01.dbf
35 445 PDB02:UNDOTBS1 NO /u01/app/oracle/oradata/CDB/pdb02/undotbs01.dbf
36 270 PDB03:SYSTEM NO /pdb/CDB/E83591B00D03644CE05506513572C122/datafile/o1_mf_system_kko7gw9p_.dbf
37 295 PDB03:SYSAUX NO /pdb/CDB/E83591B00D03644CE05506513572C122/datafile/o1_mf_sysaux_kko7gw9q_.dbf
38 445 PDB03:UNDOTBS1 NO /pdb/CDB/E83591B00D03644CE05506513572C122/datafile/o1_mf_undotbs1_kko7gw9r_.dbf
39 270 PDB04:SYSTEM NO /pdb/system01.dbf
40 295 PDB04:SYSAUX NO /pdb/sysaux01.dbf
41 445 PDB04:UNDOTBS1 NO /pdb/undotbs01.dbf
42 270 PDB05:SYSTEM NO /u01/app/oracle/oradata/CDB/CDB/E83591B00D07644CE05506513572C122/datafile/o1_mf_system_kko7k8dh_.dbf
43 295 PDB05:SYSAUX NO /u01/app/oracle/oradata/CDB/CDB/E83591B00D07644CE05506513572C122/datafile/o1_mf_sysaux_kko7k8dj_.dbf
44 445 PDB05:UNDOTBS1 NO /u01/app/oracle/oradata/CDB/CDB/E83591B00D07644CE05506513572C122/datafile/o1_mf_undotbs1_kko7k8dk_.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 38 TEMP 32767 /u01/app/oracle/oradata/CDB/temp01.dbf
2 38 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/CDB/pdbseed/temp01.dbf
4 38 PDB04:TEMP 32767 /pdb/temp01.dbf
5 38 PDB05:TEMP 32767 /u01/app/oracle/oradata/CDB/CDB/E83591B00D07644CE05506513572C122/datafile/o1_mf_temp_kko7k8dl_.dbf
8 38 PDB02:TEMP 32767 /u01/app/oracle/oradata/CDB/pdb02/temp01.dbf
9 38 PDB03:TEMP 32767 /pdb/CDB/E83591B00D03644CE05506513572C122/datafile/o1_mf_temp_kko7gw9r_.dbf
RMAN>