Blog - comments

Hi Helmy, If you use the GUI to create the availability group, it requires you have the same path / ...

could you please share the needed class files (or the D2.jar) it seems, this class is missing

me
but when i am gonna create an AG the following error shown >> the following folder locations do not ...
Helmy Mohamed
Nice one! I like the outfit of the characters. Wish i could do the same thing too but im not that te...
utah

Can someone please forward me all the netbackup commands with detail information I want CLI.

Shekhar D
Blog Pierre Sicot OOW Day 3: Playing with Oracle 12c - new features pluggable & multitenant database

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Technology Survey

OOW Day 3: Playing with Oracle 12c - new features pluggable & multitenant database

For the third day at the OOW, we had the opportunity to "play" with the beta 2 of the upcoming Oracle database release "Oracle Database 12c". This was a Hands-on-Lab session with about 60 participants with at each seat place an Oracle VM guest running on Oracle Linux 5. The goal of this session was to demonstrate the new database feature pluggable database announced by Larry as a multitenant database.

OracleLogo

Let's start with some generalities about the technology. A single database container (CDB) can contain several pluggable databases (PDB).

  • You can unplug a PDB from a CDB to another CDB
  • PDB's can be cloned inside the CDB
  • Management of PDB (clone/creation/plug/unplug/drop) are implemented as SQLs
  • All Oracle database options/features are available on the PDB level

Benefits of pluggable databases

  • Extremely fast PDB-provisioning (clone inside the CDB)
  • Database patch/upgrade management very quick as CDB is a single point of installation
  • RMAN backup at CDB level
  • Etc.

Some technical background

  • Each PDB has its own data dictionary
  • Data Guard configuration on CDB as whole
  • RMAN point-in-time recovery at PDB level (while other PDB's remains open)
  • Flashback of a PDB should be available for Oracle 12c Release 2

In fact, we had a network outage during the session... We could only create a PDB inside an existing CDB clone online in that PDB. Then, unplug the PDB clone and plug it in another CDB (offline).

This Oracle Database 12c features looks really promising... can't wait to play with it on productive systems :-)

Enjoy Oracle "Multitenant" Database 12c!

Rate this blog entry:
2

Pierre Sicot is Senior Consultant at dbi services. He has more than fifteen years of experience in Oracle database administration, engineering, and optimization. His specialty is the installation, migration, optimization, and security of Oracle databases in production environments. Prior to joining dbi services, Pierre was consultant at Trivadis in Lausanne. He also worked at ilem Group as a database administrator and also as a Consultant for different customers. Pierre holds a engineering diploma of ESME Sudria in France. His branch-related experience covers Energy, Banking, Public Administration, etc.

Comments

  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Tuesday, 02 September 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter