Oracle12c Multitenant Architecture
Multitenant Container (CDB) and
Pluggable Databases (PDBs)
LESSON 17
How to manage roles in a CDB (Multitenant Container) and PDBs (Pluggable
Databases)
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.
More …
Notice that you cannot have
any local role in the root container (only common role in the root container).
More …
LESSON 18
Backup,
Recovery and Flashback
How to
perform cold backup on CDB using RMAN
More …
Performing
the whole CDB full backup
More …
Performing a
whole PDB backup
More …
Performing a
PDB backup of the tablespace mytbs
More …
LESSON 19
How to
perform recovery from missing of data
Recover the
SYSTEM tablespace of mycdb
More …
Recover the
whole mypdb1 pluggable database
More …
Recover the
whole tablespace mytbs from mypdb1 pluggable database
More …
Recovery from
missing control files
More …
Reclaiming
space on the recovery area by deleting backupset, obsolete objects and
archivelog files
More …
Recovery from
missing SYSAUX of your CDB
More …
Recovery from
user deleted records not knowing using Point-In-Time Recovery (PITR)
More …
LESSON 20
Glory of Flashback
Why 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
to be.
More …
In this lesson, we show you
how to use flashback and use the resetlogs option when you want to open your
database.
More …
How to turn on your database
flashback
More …
Check to see if your flashback
is on using the V$DATABASE view
More …
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.
More …
Check the database before you
open it with the RESETLOGS option.
More …
LESSON 21
How to move data file online
You can move a data file from
one location to another without offline the tablespace or data file.
More …
LESSON 22
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.
More …
How to enable the unified
auditing
More …
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.
More …
LESSON 23
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.
More …
LESSON 24
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).
More …
What is the share?
More …
Create the resource manager
plans and associated directives for mypdb1 and mypdb1 and call
them “my_plan.”
More …
LESSON 25
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
More …
Enable the DDL logging.
More …
You need to use the adrci tool
to view the content of the DDL log file.
More …
LESSON 2