Oracle12c Multitenant Architecture
Multitenant Container (CDB) and
Pluggable Databases (PDBs)
How to manage roles in a CDB (Multitenant Container) and PDBs (Pluggable
The same as users, you can
have common roles or local roles in your pluggable databases. A common role
has to start with c## or C## prefix. All roles in the root container are
common. You cannot have local role in the root container. A common role will
be created in the root container and can be used in all PDBs. They can be
modified at a PDB level. A common role cannot be created in a pluggable
database. A local role can only be created in PDBs.
Notice that you cannot have
any local role in the root container (only common role in the root container).
Recovery and Flashback
perform cold backup on CDB using RMAN
the whole CDB full backup
whole PDB backup
PDB backup of the tablespace mytbs
perform recovery from missing of data
SYSTEM tablespace of mycdb
whole mypdb1 pluggable database
whole tablespace mytbs from mypdb1 pluggable database
missing control files
space on the recovery area by deleting backupset, obsolete objects and
missing SYSAUX of your CDB
user deleted records not knowing using Point-In-Time Recovery (PITR)
Glory of Flashback
If you have enough space, make
sure to turn on your flashback. It will save you lots of time in times of
crises. Make enough space based on your retention time. Also, when you perform
flashback do not resetlogs unless you are convince that you are where you want
In this lesson, we show you
how to use flashback and use the resetlogs option when you want to open your
How to turn on your database
Check to see if your flashback
is on using the V$DATABASE view
It is possible that you have
received a wrong time so do not resetlogs unless you are sure.
To flashback, you need to shut
down and start the database with the MOUNT option.
Check the database before you
open it with the RESETLOGS option.
How to move data file online
You can move a data file from
one location to another without offline the tablespace or data file.
What the Unified Audit is
Assuming that you have a
requirement to audit Data Pump export/import and RMAN at your work, then you
need to enable unified audit and configure.
How to enable the unified
To enable the unified
auditing, you need to shut down all the database components and use the make
command to rebuild the oracle library binary to perform the unified auditing.
How to recover a missing table using RMAN backup
You have a user that dropped
its table at 8:30am on March 3, 2014. He comes to you and asks you to recover
the lost table using RMAN backup.
How to use the resource manager plans and associated directives to limit
CPU resources between PDBs
Sometime you need to allocate
more CPU resources to one PDB and less to another. This lesson will
demonstrate how to do that.
Let us assume we need to
allocate more CPU resources to the pluggable database mypdb1 (OLTP) since it
needs to have a high performance and less CPU resources to the pluggable
database mypdb2 (Data Warehousing).
What is the share?
Create the resource manager
plans and associated directives for mypdb1 and mypdb1 and call
How to view ADR DDL log file
If you want to view all DDL
statement, you can use the ADR DDL log file. But before using this feature,
you need to enable this feature by changing the ENABLE_DDL_LOGGING
instance parameter to TRUE
Enable the DDL logging.
You need to use the adrci tool
to view the content of the DDL log file.