Oracle Pluggable Database - 12c

Schema Consolidation/Database Consolidation & Non-Production Fast Cloning:

Schema Consolidation/Database Consolidation:

In the database farm, As a part of Cost control, Organization  is looking for consolidating multiple  single databases into a single server or build huge database in a single server to support multiple application.

Non-Production Fast Cloning:

It is a big challenge for DBAs to do build test environment  when database is very big,ETA to setup is very less and Arranging Storage capacity  .
We use several options depends the feasibility like RMAN Active Duplicate database, Standby setup, BCV …… and Finally Delphix.!

Are they most cost effective/effective methods? of course ,we say yes until we hear about the Oracle Open world 2012 news . Oracle also thought about the same challenges and introduced some interesting new features in their upcoming 12c.

Oracle Pluggable Database & Fast Cloning

In Open World 2012, Oracle revealed the following  interesting feature in Oracle 12c

·         Pluggable Database.

·         Fast cloning

Oracle Pluggable Database

This Feature allows to run multiple databases under one instance or Container, is called multi-tenancy.

Separated Database metadata and user DBs Metadata

The new database design splits the database into two physical entities. One is root or container database ( CDB- Container database)  which contains the metadata required to run the database itself. The second entity will be user's database ( PDB- Pluggable database)  and its metadata, with this Oracle's metadata has been separated from users metadata.

We are all  looking for multiple databases on a single server or build huge database that supports multiple application. Both can be achieved with this new feature.

Key Points about this feature

•       Once container can have 250 user databases.
•        New admin role is introduced CDB Administrator - To manage CBD database
•         Only way to connect PDB is through Service
•          Can convert non CDB to Pluggable database into a CDB quickly
•          With this Can easily

    Migrate databases to new platform

  Migrate databases to new hardware

  Migrate databases to new DB releases

  Move databases to different systems

  Move databases to different CDB

Fast Cloning:

When we have pluggable database setup in a container,  Oracle says that cloning takes few mins to clone a PDB with the same CDB or into another CDB.

Just run the below command with some preparatory work, it creates a clone copy in few secs.

create pluggable database C01P02P  from C01P01P  file_name_convert = ('/c01p01p', '/c01p02p')

Oracle use Vfabric Data Director technology for provisining, backup & clone. Need to understand the funda behind this....!