iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Oracle 12c New Features (Part III)

Online Oracle Training

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 26

Steps to create a logical standby database on the Oracle 12c Multitenant Architecture (CDB)

More

 

 

LESSON 27

How to clone a pluggable database (PDB) from one container database to another or itself

Assumptions:
Container databases:
MYCDBX From container we clone a pluggable database
MYCDBY To container we clone a pluggable database

Pluggable database:
MYPDB1 the pluggable database from the MYCDBX container
MYPDB1_CLONE a pluggable database we clone to MYCDBY container

MYCDBX container
MYPDB1 pluggable database --> cloning and name it MYYPDB1_CLONE in MYCDBY container

More

 

 

.Part I      .Part II     .Part III

Good Luck!!!!

 

Google
 
Web web site