OraFAQ Forum: Server Administration » Not able to hot clone remote pdb with same name

Home » RDBMS Server » Server Administration » Not able to hot clone remote pdb with same name (19.0.0, Windows 2016)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to hot clone remote pdb with same name [message #684029]

Thu, 25 March 2021 17:43

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!

Report message to a moderator

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

John Watson
Messages: 8960
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.

Report message to a moderator

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

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?

Report message to a moderator

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

John Watson
Messages: 8960
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.

Report message to a moderator

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

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

Report message to a moderator

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

John Watson
Messages: 8960
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.

Report message to a moderator

Previous Topic:	Database resources
Next Topic:	ORA-01653: unable to extend table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 08:33:40 CST 2024