Oracle Multitenant - PDB Clone New Features (12.1.0.2.0) - Part II

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

With this new release coming some new features. This article series covers PDB Clone new features of Oracle Multitenant option of Oracle Database 12c Release 1 (12.1.0.2.0). 

This article is in four parts: 
  1. Excluding Data When Cloning a PDB
  2. Non-CDB Adopt to CDB as a PDB.
  3. PDB Subset Cloning 
  4. PDB Snapshot Cloning (as soon)

Part II. Non-CDB Adopt to CDB as a PDB.

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.

This feature further improves rapid provisioning of pluggable databases. Administrators can spend less time on provisioning and focus more on other innovative operations. Follow examples:

I'll create a PDB using database link from following non-CDB: 



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

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 24 12:14:06 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
--- ---------
NO  PRMDB


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/prmdb/system01.dbf
/u01/app/oracle/oradata/prmdb/sysaux01.dbf
/u01/app/oracle/oradata/prmdb/undotbs01.dbf
/u01/app/oracle/oradata/prmdb/users01.dbf

My Multitenant Container Database as below: 

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

SQL*Plus: Release 12.1.0.2.0 Production on Thu Jul 24 12:22:42 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

SQL> select file_name from cdb_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/prmcdb/system01.dbf
/u01/app/oracle/oradata/prmcdb/sysaux01.dbf
/u01/app/oracle/oradata/prmcdb/undotbs01.dbf
/u01/app/oracle/oradata/prmcdb/users01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb02/system01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb02/sysaux01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb02/prmpdb02_users01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb01/sysaux01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb01/system01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb01/prmpdb01_users01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb01/appdata01.dbf

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/prmcdb/prmpdb03/appdata01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb03/prmpdb03_users01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb03/sysaux01.dbf
/u01/app/oracle/oradata/prmcdb/prmpdb03/system01.dbf

15 rows selected.

We need create a database link to non-CDB in CDB. User of database link must be granted CREATE PLUGGABLE DATABASE privilege
and before create PDB, non-CDB must be opened read-only mode.

On non-CDB:
SQL> conn / as sysdba
Connected.

SQL> create user pdbcreator identified by pdbcreator; 

User created.

SQL> grant create session, resource, create pluggable database to pdbcreator;

Grant succeeded.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area  830472192 bytes
Fixed Size      2929840 bytes
Variable Size    599788368 bytes
Database Buffers   222298112 bytes
Redo Buffers      5455872 bytes
Database mounted.

SQL> alter database open read only;

Database altered.

Create a database link in CDB to non-CDB and create a pluggable database via this database link:

On CDB:
SQL> create database link prmdb connect to pdbcreator identified by pdbcreator
  2  using 'prmdb';

Database link created.

SQL> create pluggable database prmpdb04 from NON$CDB@prmdb 
  2 file_name_convert=('/u01/app/oracle/oradata/prmdb','/u01/app/oracle/oradata/prmcdb/prmpdb04');

Pluggable database created.

[oracle@oel62-ora12c2 prmcdb]$ pwd
/u01/app/oracle/oradata/prmcdb
[oracle@oel62-ora12c2 prmcdb]$ ls -l
total 1903672
-rw-r----- 1 oracle oinstall  17973248 Jul 24 12:27 control01.ctl
drwxr-x--- 2 oracle oinstall      4096 Jul 23 18:03 pdbseed
drwxr-x--- 2 oracle oinstall      4096 Jul 24 09:47 prmpdb01
drwxr-x--- 2 oracle oinstall      4096 Jul 23 18:22 prmpdb02
drwxr-x--- 2 oracle oinstall      4096 Jul 24 10:50 prmpdb03
drwxr-x--- 2 oracle oinstall      4096 Jul 24 12:27 prmpdb04
-rw-r----- 1 oracle oinstall  52429312 Jul 24 12:27 redo01.log
-rw-r----- 1 oracle oinstall  52429312 Jul 24 10:52 redo02.log
-rw-r----- 1 oracle oinstall  52429312 Jul 24 12:10 redo03.log
-rw-r----- 1 oracle oinstall 713039872 Jul 24 12:25 sysaux01.dbf
-rw-r----- 1 oracle oinstall 828383232 Jul 24 12:25 system01.dbf
-rw-r----- 1 oracle oinstall 206577664 Jul 24 12:26 temp01.dbf
-rw-r----- 1 oracle oinstall 225452032 Jul 24 12:25 undotbs01.dbf
-rw-r----- 1 oracle oinstall   5251072 Jul 24 12:15 users01.dbf
[oracle@oel62-ora12c2 prmcdb]$ cd prmpdb04
[oracle@oel62-ora12c2 prmpdb04]$ ls -l
total 1479768
-rw-r----- 1 oracle oinstall 681582592 Jul 24 12:28 sysaux01.dbf
-rw-r----- 1 oracle oinstall 828383232 Jul 24 12:28 system01.dbf
-rw-r----- 1 oracle oinstall  62922752 Jul 24 12:28 temp01.dbf
-rw-r----- 1 oracle oinstall   5251072 Jul 24 12:28 users01.dbf

SQL> select name, open_mode from v$pdbs;

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

Pluggable Database created successfully

We created the PDB from a non-CDB, therefore we must be run the @ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script in new PDB. This script must be run before the PDB can be opened for the first time.

SQL> alter session set container = prmpdb04;

Session altered.

The script opens the PDB, performs changes, and closes the PDB when the changes are complete.

SQL> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql

.....

PL/SQL procedure successfully completed.

SQL> 
SQL> 
SQL> WHENEVER SQLERROR CONTINUE;
SQL> 
SQL> 
SQL> alter database open;

Database altered.

SQL> conn mahir/mahir@prmpdb04;
Connected.
SQL> select *  from dt;

D
---------
23-JUL-14
22-JUL-14
21-JUL-14

3 rows selected.
Script executed successfully and PDB opened.

SQL> conn / as sysdba
Connected.
SQL> 
SQL> select name, open_mode from  v$pdbs;   

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

5 rows selected.

Cloning a Remote PDB or Non-CDB the source and target platforms must meet these requirements:

  • They must have the same endianness.
  • They must have the same set of database options installed.


I had created the PDB from non-CDB on same platform, so same endianes platforms.

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 12c Release 2 - SQL*Plus History Command

Image
As you know that we can repeat our previous SQL*Plus commands in Windows CMD. But in UNIX based systems not supported command line history of SQL*PLus.  For this reason in UNIX and Linux, we used  rlwrap  utility to see the SQL*Plus command line history and quickly recall previous SQL*Plus commands. With seconds release of Oracle Database 12c coming SQL*Plus  history  command for the history of the command line in Linux. I want to share some example for this command: Before using History we must enable history command as below: SQL> set history on The syntax of HISTORY command as bellow SQL> help history HISTORY ------- Stores, lists, executes, edits of the commands entered during the current SQL*Plus session. HIST[ORY] [N {RUN | EDIT | DEL[ETE]}] | [CLEAR] N is the entry number listed in the history list. Use this number to recall, edit or delete the command. Example: HIST 3 RUN - will run the 3rd entry from the list. HIST[ORY] without any option
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