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 SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; create password file and service D:\> orapwd file=D:\oracle\product\10.2.0\db_1\database\PWDdba71.ora password=sys entries=10 D:\> oradim -new -sid dba71 -intpwd sys -maxusers 10 -startmode auto -pfile […]

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 SQL> archive log list; Database log mode              No Archive Mode Automatic archival             Disabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     2 Current log sequence              4 List the tablespaces SQL> select name from v$tablespace; NAME —————————— […]

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 SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO SQL> Step 2 : Create the […]

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