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. […]

Read More

Recreate Database Using Only Datafile and Logfile

Let’s have look on the steps are used by Oracle DBA  for “Recreate Database Using Only Datafile and Logfile”. Backup of the control file in trace

create password file and service

set the environment and start the database in nomount

Create the controlfile

NOTE- If you want to set the new name […]

Read More

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 […]

Read More

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 […]

Read More

Recover From Redo Log File

This post explains about the steps are used by DBA for recovery From Redo Log File. Check the archive log status

List the tablespaces

Create new tablespace and create a table with some dummy data

Shutdown the database

Delete the datafile and try to start the database

Recreate the datafile and […]

Read More

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

Step 2 : Create the directory

Step 3 : Backup using expdp

Step 4 : Connect to CDB […]

Read More

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 […]

Read More

Oracle Database 18c New Features Book

Written by Oracle Certified Master Skant Gupta and Oracle Certified Master & Oracle ACED Joel Pérez describes the myriad new and enhanced capabilities available in the latest Oracle Database release. This book is meticulously planned for the audience keen to learn all about the amazing new features being offered by Oracle Database 18c. You must […]

Read More