Forum Stats

  • 3,751,251 Users
  • 2,250,337 Discussions
  • 7,867,360 Comments

Discussions

Remote pdb cloning for 19c when storage is on ASM for both source and Target

Ramesh Jadda-Oracle
Ramesh Jadda-Oracle Member Posts: 3 Employee
edited Jul 13, 2020 5:24PM in Enterprise Manager

Hi Experts,

I am doing a pdb cloning for a 19c databases and failing with below error. Could you please find the below details and suggest.

Source/Target DB Version: 19c

Storage: ASM for Both

SQL> create pluggable database DEV from [email protected]_link file_name_convert=('PRODCDB_IAD1HW', 'PRODCDB_IAD34X') KEYSTORE IDENTIFIED BY *********;

create pluggable database DEV from [email protected]_link file_name_convert=('PRODCDB_IAD1HW', 'PRODCDB_IAD34X') KEYSTORE IDENTIFIED BY *****

*

ERROR at line 1:

ORA-01276: Cannot add file

+DATAC1/PRODCDB_IAD34X/A2CD93DD4D64131FE053030110AC6605/DATAFILE/system.323.1043

720963.  File has an Oracle Managed Files file name.

Thanks

Ramesh

Ramesh Jadda-Oracle

Answers

  • EdStevens
    EdStevens Member Posts: 28,392 Gold Crown
    edited Jul 11, 2020 9:08AM
    3745028 wrote:Hi Experts,I am doing a pdb cloning for a 19c databases and failing with below error. Could you please find the below details and suggest.Source/Target DB Version: 19cStorage: ASM for BothSQL> create pluggable database DEV from [email protected]_link file_name_convert=('PRODCDB_IAD1HW', 'PRODCDB_IAD34X') KEYSTORE IDENTIFIED BY *********;create pluggable database DEV from [email protected]_link file_name_convert=('PRODCDB_IAD1HW', 'PRODCDB_IAD34X') KEYSTORE IDENTIFIED BY ******ERROR at line 1:ORA-01276: Cannot add file+DATAC1/PRODCDB_IAD34X/A2CD93DD4D64131FE053030110AC6605/DATAFILE/system.323.1043720963. File has an Oracle Managed Files file name.ThanksRamesh

    And what did you discover when you googled the error code: ORA-01276?

    See MOS doc id

    Doc ID 2420449.1

  • Ramesh Jadda-Oracle
    Ramesh Jadda-Oracle Member Posts: 3 Employee
    edited Jul 11, 2020 9:29AM

    Hi Steve,

    Thanks for your response.

    Have gone through this Document earlier, but it was for within a machine not between the systems.

    Thanks

    Ramesh

  • Markus Flechtner
    Markus Flechtner Member Posts: 501 Bronze Trophy
    edited Jul 13, 2020 5:24PM

    Hi,

    you can use

    create pluggable database DEV from [email protected]_link create_file_dest='+<YOUR_DG>' KEYSTORE IDENTIFIED BY *********;

    HTH

    Markus

    Ramesh Jadda-Oracle