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@xxxxxxxxx>
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