What is CDB?
CDB is short for container database, container database in 12c is similar to similar to normal 11g DB having all the files like controlfile, redolog file,temp files, undo and datafiles. It contains the meta data of those objects which may be owned by portable DB with in that CDB and are visible to all PDBS depending about the right and privileges.
What are PDBs?
PDB is short for portable databases, and it contains all those information related to itself, there is no controlfile, redolog files specifically for the pdbs but it have its own datafiles and tempfiles containg data about the PDB, from 12.2 onwards it has its undo file.
Checking the BG process for a CDB:
The background process for CDB can be checked at os level:
$ps -ef|grep cdb_name
if we grep the CBD name, command result no BG processs, it means the DB services are not yet started.
Starting up the DB
$ sqlplus / as sysdba
sql> startup;
Once the DBs are up, lets check the services:
Viewing the PDB Name:
Status of PDBS:
By default when you retart the CDB, the default status of PDB will be mount. i.e
we have to issue below command to convert PDB from mount to read write:
alter pluggable database pdb1 open;
Now checking the status, now its ready to use and operations can be performed on it:
PDB can be connected after creating service (already discussed my earlier blog), show as:
CDB is short for container database, container database in 12c is similar to similar to normal 11g DB having all the files like controlfile, redolog file,temp files, undo and datafiles. It contains the meta data of those objects which may be owned by portable DB with in that CDB and are visible to all PDBS depending about the right and privileges.
What are PDBs?
PDB is short for portable databases, and it contains all those information related to itself, there is no controlfile, redolog files specifically for the pdbs but it have its own datafiles and tempfiles containg data about the PDB, from 12.2 onwards it has its undo file.
Checking the BG process for a CDB:
The background process for CDB can be checked at os level:
$ps -ef|grep cdb_name
if we grep the CBD name, command result no BG processs, it means the DB services are not yet started.
Starting up the DB
$ sqlplus / as sysdba
sql> startup;
Once the DBs are up, lets check the services:
Checking the Name and its status whether it CBD or Conventional DB:
Viewing the PDB Name:
Status of PDBS:
By default when you retart the CDB, the default status of PDB will be mount. i.e
we have to issue below command to convert PDB from mount to read write:
alter pluggable database pdb1 open;
Now checking the status, now its ready to use and operations can be performed on it:
PDB can be connected after creating service (already discussed my earlier blog), show as:
