In Oracle 12c Release 1 Undo tablespace was always Shared across PDBs. Rollback segment of each pdb was written in Undo tablespace which was created under the Container Root database. Oracle 12.2 comes with a new Feature that allows Local Undo creation and Shared undo creation. Local Undo tablespace to PDB helps us in the […]
All posts by Jagruti Jasleniya
Jagruti Jasleniya
Export from pdb and import into non-cdb
In a previous post, we have seen how we import backup from non-cdb to pdb. Export from pdb and import into pdb In this post, we will see how we can import backup taken from the pluggable database and restore it to the non-cdb database. Step 1 : Connect to pluggable database : SQL> alter […]
Export from pdb and import into pdb
In this post, we will see how we can take an export from one pdb and import into another pdb. Step 1: Connect to pdb from where you want to take export : SQL> alter session set container = orclpdb; Session altered. SQL> SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- […]
Unplug and plug an application container
In these posts, we will see how we can unplug the application container and plug it into different CDB. Step 1: Unplug application container. SQL> alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’; alter pluggable database app_pdb unplug into ‘/u02/app_pdb.xml’ * ERROR at line 1: ORA-65025: Pluggable database APP_PDB is not closed on all instances. It […]
Manage common and local users, roles, privileges and profiles in PDBs
Introduction of Multitenant Architecture Common users and Local users: This concept came with Oracle Database 12c. Common Users: a Common user is a user which have the same username and password authentication across PDBs of CDB. Common users are created at CDB level and the common user can connect to the root and perform operations. […]
Manage common and local objects in application containers
Introduction of Multitenant Architecture With Oracle 12c Oracle introduced the concept of common objects which avoids redundancy of metadata and data. Which makes CDB maintenance and up-gradation easy. Common objects exist in Oracle-supplied schemas and therefore cannot be user-defined. In the Application container, we can create metadata-linked or data-linked common objects. There can be following […]
Backup CDB and PDBs
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 […]
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 […]
Changing Instance Parameter in Pluggable Database
Introduction of Multitenant Architecture As we know in Multi-tenant architecture we have only one instance at container level hence we have only one spfile for Container Database. So value we set in parameters are associated in CDB$ROOT so applied to cdb root and serve as default parameters for all other containers; Although we can set […]
Pluggable Database Modes and PDB Settings
In this Article, we will see how we can open a Pluggable Database in different modes and changing the setting of particular pdb. Pluggable Database Modes : Open Pluggable Database in Restricted Mode First what is restricted mode : All user having create session privilege can connect to normally opened database. But when your database […]