Archive

Archive for April, 2014

12c clone PDB which has OMF file names

April 24, 2014 Leave a comment

Trying to clone a pdb database that has OMF file names failed with the following error


SQL> create pluggable database pdb1
2 AS CLONE using 'C:\oracle\xmlpdb\labpdb.xml'
3 MOVE
4 FILE_NAME_CONVERT=('C:\oracle\oradata\testlab\91706876B2124CE1AB370C721351A0F6','C:\oracle\oradata\testlab\pdb1');
create pluggable database pdb1
*
ERROR at line 1:
ORA-01276: Cannot add file C:\ORACLE\ORADATA\TESTLAB\PDB1\DATAFILE\O1_MF_SYSTEM_9OKLBC83_.DBF. File has an Oracle
Managed Files file name.

to fix this issue i had to do the following


create pluggable database pdb1
AS CLONE using 'C:\oracle\xmlpdb\labpdb.xml'
MOVE
FILE_NAME_CONVERT=('C:\oracle\oradata\testlab\91706876B2124CE1AB370C721351A0F6\DATAFILE\O1_MF_SYSTEM_9OKLBC83_.DBF','C:\oracle\oradata\testlab\pdb1\system01.dbf’,
'C:\oracle\oradata\testlab\91706876B2124CE1AB370C721351A0F6\DATAFILE\O1_MF_SYSAUX_9OKLBC7W_.DBF','C:\oracle\oradata\testlab\pdb1\sysaux01.dbf’,
'C:\oracle\oradata\testlab\91706876B2124CE1AB370C721351A0F6\DATAFILE\O1_MF_USERS_9OKLF7LZ_.DBF','C:\oracle\oradata\testlab\pdb1\users01.dbf’,
'C:\oracle\oradata\testlab\91706876B2124CE1AB370C721351A0F6\DATAFILE\O1_MF_TEMP_9OKLD9Y2_.DBF','C:\oracle\oradata\testlab\pdb1\temp01.bdf');

Pluggable database created.

Categories: Oracle