Export from a Non-CDB and Import in PDB

Introduction of Multitenant Architecture A logical backup taken from NON-CDB database can be easily imported into a pluggable database without any overhead. Let us see the example : Step 1: Check the database status SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO SQL> Step 2 : Create the […]

Read More

Plugging Non-CDB to CDB

In this article, we will see how we can plug the Non-CDB database as a Pluggable Database in a Container Database. Step 1: Check non-cdb Database SQL> SELECT NAME,OPEN_MODE,CDB FROM V$DATABASE; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO Step 2: Gracefully shut down Non-CDB database and open it in READ ONLY stage […]

Read More