Introduction of Multitenant Architecture In this article, we will see how we can take RMAN backup of whole CDB and for the single pluggable database. To take RMAN backup of the whole CDB we can simply take backup by connecting to target as container database and backup database command. Let us see by example : CDB […]
Articles Tagged: CDB
Startup and Shutdown CDB and PDBs
In previous post we have seen various ways to connect with CDB and PDB. Establish Connection in CDB and PDB In this post we will see how we can Start and shutdown particular PDB and how to Start and shut down whole CDB. 1. How to Start Pluggable database There are two ways possible a) […]
Establish Connection in CDB and PDB
When it comes to Multi-tenant architecture, one question that comes to our mind is how to connect to container database and pluggable database. Today we will see all possible way to connect to the container database. Obviously, we connect database using service name for the non-local connection. When we create CDB, a service is created […]
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 […]
Manually Create and configure CDB database and PDB database
In the previous article, we can see that the architecture of multitenant. In this post, we will configure manually CDB and PDB. Introduction of Multitenant Architecture Step 1: create initmycdb.ora [oracle@localhost ~]$ cd $ORACLE_HOME/dbs [oracle@localhost dbs]$ cat initmycdb.ora db_name=mycdb CONTROL_FILES=’/u02/oradata/mycdb/control01.ctl’,’/u02/oradata/mycdb/control02.ctl’ ENABLE_PLUGGABLE_DATABASE=TRUE DB_CREATE_FILE_DEST=’/u02/oradata/’ DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’ DB_BLOCK_SIZE=8192 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undotbs USER_DUMP_DEST=’/u01/oracle/admin/mycdb/adump/’ Step 2: Create necessary directories. [oracle@localhost dbs]$ mkdir […]
Describe the CDB root and pluggable database containers
In the previous article, we have explored Multitenant architecture. Introduction of Multitenant Architecture We have heard this word container database and pluggable database many times after 12c came into the market. Today we will see what does it mean by a pluggable database and container database. Container Database and Pluggable Database : In a multi-tenant […]