Hello,
I created a CDB database with DB_CREATE_FILE_DEST = '/u02/oradata'.
Using OMF, the data files were created as following:
1 810 SYSTEM YES /u02/oradata/CDB2/datafile/o1_mf_system_b5f2f8s8_.dbf
3 870 SYSAUX NO /u02/oradata/CDB2/datafile/o1_mf_sysaux_b5f2c7x3_.dbf
4 220 UNDOTBS1 YES /u02/oradata/CDB2/datafile/o1_mf_undotbs1_b5f2ho2y_.dbf
5 250 PDB$SEED:SYSTEM NO /u02/oradata/CDB2/datafile/o1_mf_system_b5f2jy43_.dbf
6 5 USERS NO /u02/oradata/CDB2/datafile/o1_mf_users_b5f2hmyl_.dbf
7 550 PDB$SEED:SYSAUX NO /u02/oradata/CDB2/datafile/o1_mf_sysaux_b5f2jy41_.dbf
I would like to create a pluggable database (PDB) with it's data files located in /u02/oradata/CDB2/pdb2_1.
I cannot use FILE_NAME_CONVERT since the database is using OMF.
So I thought I would use the new PDB_FILE_NAME_CONVERT parameter:
SQL> alter system set PDB_FILE_NAME_CONVERT = '/u02/oradata/CDB2','/u02/oradata/CDB2/PDB2_1';
SQL> CREATE PLUGGABLE DATABASE pdb2_1 ADMIN USER pdb2_1_admin IDENTIFIED BY oracle_4U ROLES=(CONNECT);
According to RMAN report schema, data files were created as following:
1 810 SYSTEM YES /u02/oradata/CDB2/datafile/o1_mf_system_b5f2f8s8_.dbf
3 880 SYSAUX NO /u02/oradata/CDB2/datafile/o1_mf_sysaux_b5f2c7x3_.dbf
4 220 UNDOTBS1 YES /u02/oradata/CDB2/datafile/o1_mf_undotbs1_b5f2ho2y_.dbf
5 250 PDB$SEED:SYSTEM NO /u02/oradata/CDB2/datafile/o1_mf_system_b5f2jy43_.dbf
6 5 USERS NO /u02/oradata/CDB2/datafile/o1_mf_users_b5f2hmyl_.dbf
7 550 PDB$SEED:SYSAUX NO /u02/oradata/CDB2/datafile/o1_mf_sysaux_b5f2jy41_.dbf
10 250 PDB2_1:SYSTEM NO /u02/oradata/CDB2/07DA9CA33E5A49D8E053013C000AB7E5/datafile/o1_mf_system_b6f2gw99_.dbf
11 550 PDB2_1:SYSAUX NO /u02/oradata/CDB2/07DA9CA33E5A49D8E053013C000AB7E5/datafile/o1_mf_sysaux_b6f2gw9h_.dbf
Problem: For some reason it is using "07DA9CA33E5A49D8E053013C000AB7E5" instead of PDB2_1.
The same also happens when setting DB_CREATE_FILE_DEST = /u02/oradata/CDB2/pdb2_1
It creates files in /u02/oradata/CDB2/pdb2_1/CDB2/07D25A844AA4E14DE053013C000A677C/datafile
How can I use OMF to create data files in /u02/oradata/CDB2/pdb2_1/datafiles?
The database is 12.1.0.2 running in Oracle Linux 6.6
Any ideas? Thanks!