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

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. 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