Home > Oracle > 12c clone PDB which has OMF file names

12c clone PDB which has OMF file names

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.

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: