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.


Location: Baku, Azerbaijan

Comments

Post a Comment

Popular posts from this blog

Oracle Data Guard 11g - How to safely remove a Data Guard Broker configuration?

Image
When you need safely remove broker-managed Data Guard Configuration then, oracle recommend following steps… You know dg_broker_start parameter is TRUE and data guard configuration information contains in broker configuration files dg_broker_config_file1, dg_broker_config_file2 with broker-managed Data Guard Configuration. Following steps I use on my test machines witch is running on Oracle Virtual Box. I captures video on this machines, too. Primary and Standby Database running on Oracle Linux Server 6.2 and installed Oracle Database 11g Release 2 (11.2.0.3). DG – is my breoker-managed Data Guard configuration. admdb is primary database, stldb – is standby database. DGMGRL> show configuration Configuration - dg Protection Mode: MaxPerformance Databases: admdb - Primary database stldb - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS Archive log destinations like as SQL> show parameter log_archive_dest_ NAME
Read more

Oracle Database 18c - Install On-Premises for Linux

Image
Oracle Database 18c was available on Oracle Cloud. Now everybody can download Oracle Database 18c On-Premises for Linux ( LINUX.X64_180000_db_home.zip ) Oracle change a little on installation file. OUI does not copy files to Oracle Home You just extract the zip file to Oracle Home directly and OUI only linking binaries. I installed Oracle Database 18c on Linux 7.1. Before installation, I set Oracle environments such as (ORACLE_HOME, ORACLE_BASE). You can add these settings in oracle user .bash_profile. You can watch my little installation video: You can also read all about the new features in the 18c documentation Best Regards Mahir M. Quluzade Oracle ACE
Read more

Cluvfy error : Framework setup check failed on all the nodes

Hi As you know Oracle recommends before installation Oracle Real Application Clusters 11g Release 2 run Cluster Verification utility with stage previous and post installation cluster ware or database. Cluster verification utility help you for getting error before and after installation Oracle Grid Infrastructure and Real Application Clusters Database. I getting following error : [grid@oel62-rac1 grid]$ ./runcluvfy.sh stage -pre crsinst -n oel62-rac1,oel62-rac2 –verbose ….. Checking user equivalence... Check: User equivalence for user "grid"   Node Name                             Status                    ------------------------------------  ------------------------   oel62-rac2                            passed                    oel62-rac1                            passed               Result: User equivalence check passed for user "grid" Verifying node connectivity Version of exectask could not be retrieved from node &q
Read more