Category Archives: Oracle Database

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.Many companies has implemented their data in Oracle. Most of them are mission critical. So Oracle database concept need to be very clear to manage these mission critical things. At the same time Oracle database needs to deliver high performance also. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Below section I have tried to present all the important features in Oracle Database management

How to remotely clone a PDB or non-CDB in Oracle Database 12.1

Many times, we may need to copy the remote PDB to Local PDB for testing purpose. The case would be copying Production PDB to Development PDB box. Some times , we may want to migrate the non-CDB to PDB to make sure Multitenant features in the Oracle database Restriction for doing this 1)The default tablespaces for each common user in the remote PDB must exist … Continue reading How to remotely clone a PDB or non-CDB in Oracle Database 12.1 »

Hot PDB cloning in Oracle database 12.2

In Oracle database release 12.1, in order to clone a PDB, The source PDB must be quiescent(read only mode) for the duration of the clone operation. So it was called a “cold clone” operation because it involved an outage (from a transactional perspective) in the source database. This applies for both the same CDB clone or Remote CDB clone. Related Article Oracle database 12c:How to … Continue reading Hot PDB cloning in Oracle database 12.2 »

Refreshable PDB in Oracle Database 12.2

Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2 »

PDB Relocate in Oracle database 12c Release 2

A pluggable database is a self-contained, fully-functional Oracle database. We often need to move the pluggable database from one CDB to another CDB. This will be a unplug/plug operation where outage will depend on the location of source and destination CDB 1) When moving between servers with shared storage, such as is typically the case in Cloud environments when the PDB is being moved for … Continue reading PDB Relocate in Oracle database 12c Release 2 »

RMAN connection decoded

RMAN is a important tool used in Backup and recovery. Whenever you use RMAN tool in $ORACLE_HOME/bin and connect to database, it makes multiple connection to the database.Here are RMAN connection decoded Whenever we make RMAN connection to database for backup with or with out catalog,many processes are spawned and worked upon. RMAN always spawns TWO processes (sessions) when connected to a target database: • 1st … Continue reading RMAN connection decoded »

How to delete Virtual Machine from VirtualBox

Power off the Virtual Machine which you want to delete from the Virtual box 2) Select the VM to be deleted and then Click Machine on the top machine and choose remove from drop down menu 3) Below screen will come up Use delete all files option to remove the file which contains the virtual machine hard disk. This will free up all the space … Continue reading How to delete Virtual Machine from VirtualBox »

Step by Step instructions for Oracle Virtual Box Installation

VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use VirtualBox runs on Windows, Linux, Macintosh, and Solaris hosts and supports a large number of guest operating systems including but not limited to Windows (NT 4.0, 2000, XP, Server 2003, Vista, Windows 7, Windows 8, Windows 10), DOS/Windows 3.x, Linux (2.4, 2.6, 3.x and 4.x), Solaris and OpenSolaris, OS/2, … Continue reading Step by Step instructions for Oracle Virtual Box Installation »

Oracle Recovery Manager :RMAN cheatsheet

Oracle Recovery Manager(RMAN) is an important component of Oracle Database Software . It is a effective way to do the backup and recovery of the Oracle database. Oracle has added new features in RMAN in every new release. Here are some of the article,I have written on RMAN to understand it RMAN benefits over manual backup How to recover database using RMAN How to debug Oracle … Continue reading Oracle Recovery Manager :RMAN cheatsheet »

Oracle Create table Syntax,Tip and Examples

This article talks how to create table in Oracle,create table syntax in oracle,oracle create table example, Oracle is the most RDBMS used everywhere for system Table of content What is Oracle database Table How to create table in oracle create table syntax in oracle Privilege required to create table Other characteristics associated with table How to modify the oracle database table Creation of table using sub … Continue reading Oracle Create table Syntax,Tip and Examples »

Latches and Mutex

INTRODUCTION To LATCH Latches are low level serialization mechanisms used to protect shared data structures in the SGA. The implementation of latches is operating system dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of a lock that can be very quickly acquired and freed. Latches are typically used to prevent more … Continue reading Latches and Mutex »

Cluster command in Oracle clusterware 10g , 11g and 12c

Oracle clusterware is the clusterware technology from oracle to Manage Oracle RAC database on various platform.Oracle  has provide cluster utilities to manage it. Here are some of the useful Cluster command  in 10g ,11g and 12c  CRSCTL Cluster Control utility performs various administrative operation of oracle clusterware. It is located in $ORA_CRS_HOME/bin and must be executed by the “root” user. Starting and stopping Oracle Clusterware … Continue reading Cluster command in Oracle clusterware 10g , 11g and 12c »

How to delete duplicate rows from Oracle table

Last updated on December 22nd, 2017 at 06:14 pmWe often need to find  and delete duplicate rows from oracle table due to many reasons in the database. We need to delete to clear off the data issues often. There are many ways to oracle delete duplicate rows but keep original .I would be showing off few  faster method to achieve it in this post. Please note … Continue reading How to delete duplicate rows from Oracle table »