Home » RDBMS Server » Server Administration » Not able to hot clone remote pdb with same name (19.0.0, Windows 2016)
Not able to hot clone remote pdb with same name [message #684029] Thu, 25 March 2021 17:43 Go to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

CREATE PLUGGABLE DATABASE illinois FROM illinois@clone_link
FILE_NAME_CONVERT =
('D:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_0012.DBF','P:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_002.DBF','D:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_001.DBF','P:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_001.DBF');



error


ORA-65005: missing or invalid file name pattern for file -
D:\APP\ORACLE\ORADATA\USA\ILLINOIS\SYSTEM01.DBF

my task is to duplicate the remote pdb but with some files shifting to a new location. it is not using OMF.

many thanks in advance!
Re: Not able to hot clone remote pdb with same name [message #684030 is a reply to message #684029] Fri, 26 March 2021 01:55 Go to previous messageGo to next message
John Watson
Messages: 8640
Registered: January 2010
Location: Global Village
Senior Member
Your statement includes file name conversions for only two files. What about all the others?

However, if you are simply remapping D: to P:, then that is all you need to specify.
Re: Not able to hot clone remote pdb with same name [message #684044 is a reply to message #684030] Mon, 29 March 2021 04:23 Go to previous messageGo to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear John,

yes there are other files as well. Even if other files are around, the outcome is still the same

ORA-65005: missing or invalid file name pattern for file -
D:\APP\ORACLE\ORADATA\USA\ILLINOIS\SYSTEM01.DBF
file_name_convert is used when the destination file is different the source, so why the error?

and how should I resolve it?
Re: Not able to hot clone remote pdb with same name [message #684047 is a reply to message #684044] Mon, 29 March 2021 06:05 Go to previous messageGo to next message
John Watson
Messages: 8640
Registered: January 2010
Location: Global Village
Senior Member
I wonder what command you are running? I find it hard to debug code that I cannot see. Perhaps someone else with greater Psychic Powers than me can assist.
Re: Not able to hot clone remote pdb with same name [message #684052 is a reply to message #684047] Mon, 29 March 2021 11:44 Go to previous messageGo to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear John

this is the only command I'm using to create the pluggable database remotely

CREATE PLUGGABLE DATABASE illinois FROM illinois@clone_link
FILE_NAME_CONVERT =
('D:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_0012.DBF','P:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_002.DBF','D:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_001.DBF','P:\APP\ORACLE\ORADATA\USA\ILLINOIS\APPSDATA\STATS_001.DBF');



am i missing something?

thanks
Re: Not able to hot clone remote pdb with same name [message #684053 is a reply to message #684052] Mon, 29 March 2021 12:52 Go to previous message
John Watson
Messages: 8640
Registered: January 2010
Location: Global Village
Senior Member
This is beginning to look like trolling: being deliberately stupid, in an attempt to make people angry.
However, I shall assume that it is not deliberate, and try to explain again.

The error message is clear: you need to supply old-to-new mappings for ALL the datafiles that need them. Not just two.
Previous Topic: Database resources
Next Topic: ORA-01653: unable to extend table
Goto Forum:
  


Current Time: Thu Dec 02 13:58:07 CST 2021