2014/08/28

OTN Article: Oracle Database 12c: Que sucede en un CDB cuando uno de los PDB obtiene un problema? (in Spanish Language)

OTN - Oracle Technology Network Latina America continue publish our articles. Our 8th technical article published on OTN in Spanish Language at 28th August. This article entitled : Oracle Database 12c: ¿Que sucede en un CDB cuando uno de los PDB obtiene un problema? written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Bruno Nuñez (OCE).

It is a link of article: http://www.oracle.com/technetwork/es/articles/database-performance/oracle-database-12c-cdb-problem-pdb-2279196-esa.html







Thanks to my friends, Joel and Bruno, for their all efforts and thanks to OTN. 

Regards
Mahir M. Quluzade

2014/08/21

OTN Article : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado (in Portuguese Language)


OTN - Oracle Technology Network Latina America continue publish our articles. Our 7th technical article published on OTN in Portuguese Language at 20th August. This article entitled : Oracle Database 12c, O que acontece em um CDB quando um PDB tem ser recuperado written by Joel Perez (Oracle ACED), Mahir M. Quluzade (OCE) and Rodrigo Mufalini (Oracle ACE) .


It is a link of article: http://www.oracle.com/technetwork/pt/articles/database-performance/cdb-quando-pdb-tem-ser-recuperado-2270042-ptb.html




Thanks to my friends, Joel and Rodrigo, for their all efforts and thanks to OTN. 

Regards
Mahir M. Quluzade

2014/08/20

OTech Magazine Issue #4: Summer 2014 Published


OTech Magazine - The independent magazine for Oracle professionals. Yesterday fourth issue of the OTech Magazine published.



 In this issue also included my article: Oracle Database 12c: Cross Platform Transport non-CDB to PDB using RMAN Backup Sets




You can download online OTech Magazine #4 Isssue - Summer 2014

Summary of article

We can create a PDB using upgraded database (non-CDB) and can be adopt the 12.1 non-CDB into a CDB as a PDB. This article covers steps for cross-platform data transport of non-CDB to other platform and adopt the transported non-CDB into a CDB as a PDB. If 12.1 non-CDB and CDB running on same platform, then easily plug-in the non-CDB into a CDB as a PDB so, there is no need for any conversion of platform on non-CDB. If platforms are different, then we need cross-platform data transport of non-CDB with RMAN. Prior to Oracle Database 12c (12.1) RMAN only used image copies for cross-platform data transport. After 12.1 RMAN can be use backup sets for cross-platform data transport of databases. So RMAN allows following methods to cross-platform transport of databases with Oracle Database 12c (12.1):

  • Transport database using image copies
  • Transport database using backup sets

In this article I used method Transport database using RMAN backup sets. You can read more about Cross - Platform Database Transport from my articles on OTN (Part 1, Part 2 - in Portugalese Language)

Note: Oracle Database 12c Release 1 (12.1.0.1) used for this article. 

Updates related this article:

If you are using Oracle Database 12c Release 1 (12.1.0.2) then you can use new feature of multitenant - PDB Remote Clone. So,the new release of Oracle Multitenant fully supports remote full and snapshot clones over a database link. A non-multitenant container database (CDB) can be adopted as a pluggable database (PDB) simply by cloning it over a database link. You can read about this new feature in here


You can download online OTech Magazine #4 Isssue - Summer 2014

My special thanks to organizer of OTech Magazine Douwe Pieter van den Bos for all efforts.

Regards
Mahir M. Quluzade.


2014/08/01

Oracle Multitenant - PDB State Management Across CDB Restart (12.1.0.2.0)

Oracle Database 12c Release 1 (12.1.0.2.0) already released at July 22, 2014.
You can download new release from here.

Oracle Multitenant option also supports some news in Oracle Database 12c Release 1 (12.1.0.2.0).
This article covers PDB State Management in Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2) .

By default, any pluggable database (PDB) are not open in READ WRITE mode, when Multitenant Container Database (CDB) restarts. You can see this also from following example:

[oracle@oel62-ora12c2 ~]$ export ORACLE_SID=prmcdb
[oracle@oel62-ora12c2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Aug 1 14:14:59 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

SQL> select cdb,name from v$database;        

CDB NAME
--- ---------
YES PRMCDB

SQL> select name, open_mode from v$pdbs;

NAME          OPEN_MODE
------------------------------ ----------
PDB$SEED         READ ONLY
PRMPDB01         READ WRITE
PRMPDB02         READ WRITE
PRMPDB03         READ WRITE