Forum Stats

  • 3,876,124 Users
  • 2,267,064 Discussions
  • 7,912,438 Comments

Discussions

Avoid GUID path for PDB datafiles in ASM when create PDB using database link from nocdb

mantovam
mantovam Member Posts: 46
edited Mar 30, 2018 11:38PM in Multitenant

Hi folks

When created PDB from nocdb database using the command:

CREATE PLUGGABLE DATABASE pdbtest FROM [email protected]_non_cdb_test

This command works, but put the datafiles in path :

+DG_DATA/CDB12/68A4A953A4D72D16E0536900A8C0E85A/DATAFILE/system.307.972136815

Is there some option to avoid this created using the GUID - "68A4A953A4D72D16E0536900A8C0E85A" in path of datafile?

We want some like this:

+DG_DATA/PDBTEST/DATAFILE/system.271.970791477

A path without GUID, and using OMF. I tried FILE_NAME_CONVERT, create_file_dest and other command option in CREATE PLUGGABLE DATABASE  but no sucess.

Oracle version 12.1.0.2

Answers

  • Franck Pachot
    Franck Pachot Member Posts: 912 Bronze Trophy
    edited Mar 30, 2018 4:52PM

    Hi,

    >> A path without GUID, and using OMF.

    By definition, OMF will use GUID. Why do you want something else? The GUID ensures that you have no problem when renaming, cloning, plugging PDBs.

    Regards,

    Franck.

  • Unknown
    edited Mar 30, 2018 5:35PM
    A path without GUID, and using OMF.

    Sorry - but that doesn't even make ANY SENSE.

    Have you read the Oracle docs about OMF?

    https://docs.oracle.com/database/121/ADMIN/omf.htm#ADMIN003

    With Oracle Managed Files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level.

    See the above where it says 'database automatically creates, names, and manages ...'?

    It would NOT be an 'oracle managed file' if the user is involved in naming the file.

    The VERY DEFINITION of OMF means Oracle will name the files.

    Read that entire doc chapter. And especially read this section

    17.3.2 How Oracle Managed Files Are Named

    The file names of Oracle Managed Files comply with the Optimal Flexible Architecture (OFA) standard for file naming.
  • mantovam
    mantovam Member Posts: 46
    edited Mar 30, 2018 11:21PM

    Hi rp0428

    I read and know about OMF.

    I already use this in database, but the GUId path is only used in PDB.

    But in some situations like when you transform a database nocdb to pdb ,that are in same server ASM using nocopy , you stay with the datafile in OMF but without GUID.

    I want know if have a parameter to indicate a path and try avoid create guid number for this command:

    CREATE PLUGGABLE DATABASE pdbtest FROM [email protected]_non_cdb_test

    Tks

  • Unknown
    edited Mar 30, 2018 11:38PM

    And I already answered that and provided the doc quote to support it.

    If you want to name your own files then don't use OMF.

This discussion has been closed.