Re: Curious question - naming CDBs and PDBs

I have a related question. How do people plan to name PDB datafiles directories/files, when there is a plan to use the unplug/plug method for upgrading PDB-s in the future (or at least keep the possibility to move PDB-s to a different container)?
Using OMF does not seem like a good idea, because then PDB-s are stored directly under CDB directories and PDB is referenced by GUID, not PDB name.

For small test environments I currently moved away from OMF and created a separate ACFS filesystem for each PDB "flavour": /oradata/devdb/
/oradata/qadb/

Little more manual work, but then it is easy to snapshot and clone each PDB "flavour" independently.
But in production I would like to skip ACFS and use ASM directly, but there OMF file naming is mandatory.

Ilmar

On Friday, 15 July 2016, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:

> Out of curiosity, how do you guys name your CDBs and PDBs in relation to
> each other?
>
> For example, prior to 12c I might have TV Shows Databases called TVDEV,
> TVTST, TVPROD.
>
> In the CDB/PDB world, I would assume I would name my PDBs TVDEV, TVTST,
> TVPROD and I would NOT have them in the same container as they would exist
> on dedicated dev, test, prod servers.
>
> So I'm what some of you guys are doing - I realize the CDB is the instance
> name so for single PDB tenant databases, I would probably call both the
> container and the PDB TVPROD (but I'm betting they have to be different
> names?)
>
> In a world of disparate PDBs in one container, I might call my container
> MISHMASH since the container may not really relate to the individual PDBs
> it contains.
>
> Chris
>
>
>

-- 
Ilmar Kerm

--
http://www.freelists.org/webpage/oracle-l