Flashback PDB in Oracle 12cR2

After the introduction of multitenant architecture with Oracle 12cR1, the flashback database feature became irrelevant as it was limited to the root container which resulted in affecting all the PDBs associated with that root container. But with the new release 12cR2, flashback now supports pluggable databases as well. Now we’ll demonstrate how to flashback a…

Installing 12c RAC on Oracle Linux 7

Without further ado, following are the steps to construct your own lab with a 2 node 12c RAC on Linux 6 using Oracle Virtual Box. You can download the required software from below links:- Oracle Linux 7 Oracle VirtualBox Grid Infrastructure 12cR1 Oracle 12cR1 To give you an overview, this is what we are going to…

Installing 12c RAC on Oracle Linux 6

Without further ado, following are the steps to construct your own lab with a 2 node 12c RAC on Linux 6 using Oracle Virtual Box. You can download the required software from below links:- Oracle Linux 6 Oracle VirtualBox Grid Infrastructure 12cR1 Oracle 12cR1 To give you an overview, this is what we are going to…

Oracle Books

This post is to share the links for Oracle books for better understanding of Oracle Internals and other exam guides to prepare for Oracle exam. Oracle 12c Books:- OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) OCA Oracle Database 12c Installation…

12c New Features – Database In-Memory

Here comes the most awaited feature with the release of 12.1.0.2 patchset – Database In-Memory. In this post we will first dwell upon the internals of this feature and then enable this feature in our test environment to benchmark the performance gain. This article assumes that the reader is well aware of the Oracle 11g Memory…