Blogs

Drop default TEMP tablespace and recreate !!!

On March 13, 2017, Posted by , In ORACLE, With No Comments

There may be scenarios when you want to resize your default temporary tablespace because of multiple reasons. In this article, we would be dropping the default TEMP tablespace since we want to resize it. You can perform below steps to drop default TEMP tablespace and recreate. ======================================================================================================   – Create…

12c Dataguard Broker Configuration !!!

On December 6, 2016, Posted by , In Dataguard,ORACLE, By ,, , With No Comments

This article is a continuation to our previous article i.e. 12c RAC to RAC Dataguard configuration. In this post, we will see the 12c Dataguard Broker configuration steps. To configure a dataguard broker, we need to use the dgmgrl command which is a command line interface. ======================================================================================================   Perform the…

12c RAC to RAC Dataguard configuration !!!

In this article, we will see the steps to configure 12c RAC to RAC Dataguard configuration. Here our Primary and Standby databases – both will be RAC database. Here, the Primary database data files are stored on ACFS file system whereas for Standby database we will be using ASM as…

Creating and Managing ACFS filesystems in Linux !!!

On November 5, 2016, Posted by , In 12c,LINUX, By ,, , With No Comments

In this article, We will see the different commands for Creating and Managing ACFS filesystems in Linux. But before proceeding below are some features of ASM Cluster File System (ACFS). An Oracle ACFS file system communicates with Oracle ASM and is configured with Oracle ASM storage. Oracle ACFS supports Oracle…

Migrate database from 32 bit to 64 bit !!!

On October 9, 2016, Posted by , In ORACLE,RMAN, By ,, , With No Comments

In this article, we will see the steps to migrate database from 32 bit to 64 bit OS using RMAN. Operating System (OS) will be same for both source and target servers, except that the source server is 32-bit whereas the target server is a 64-bit architecture. Below is information…

UNNAMED datafile issue on Standby Database !!!

On October 3, 2016, Posted by , In ORACLE, By ,, , With No Comments

In this article, we will see the steps to resolve UNNAMED datafile issue on Standby Database. Primarily there are 2 reasons for UNNAMED file getting created on Standby database. 1. Insufficient available space on filesystem/disk group for the datafile to be created on standby database. 2. If “standby_file_management” parameter is…

Extend an existing filesystem using LVM !!!

On October 2, 2016, Posted by , In LINUX, By ,, , With No Comments

In this article, we will see the steps to extend an existing filesystem using LVM i.e Logical Volume Manager. LVM comprises of three parts, – Physical Volumes (PVs) – Volume Groups (VGs) – Logical Volumes (LVs) PVs are the actual physical disks. VGs act as a container for the physical…

Configure NFS disks using NetApp Ontap Simulator 8.3.2 !!!

In previous article, we saw the steps to configure NetApp Simulator 8.3.2 RC1 and then how to configure iSCSI disks. In this article, we will see how to configure NFS disks using NetApp Ontap Simulator 8.3.2. Reference: NFS configuration guide from NetApp Inc ======================================================================================================   – Follow the below steps…

Convert Single Instance database to RAC database !!!

On April 17, 2016, Posted by , In 10g,11g,12c, By , , With No Comments

This article is a continuation to our previous article where we have seen how to clone a database using RMAN Active Database. Now here we will see the steps to convert single instance database to RAC database. ======================================================================================================   • Follow below steps to convert the Single Instance database to…

Clone DB using RMAN Active Database duplication feature !!!

In this article we will see the steps to clone DB using RMAN Active Database duplication feature. Here, the source and target databases are on different server but sharing same disk groups. ======================================================================================================   • Follow below steps to clone database Here, source and target databases version is 12.1.0.2. Below…