Recently encountered a issue where we had to rename a diskgroup for 11gR2 RAC containing OCR and Voting Disk. Luckily we had not created any database yet, only installed Oracle Database binaries. In this blog, we will see the steps to Rename DiskGroup containing OCR and Voting Disks. Below are…

In this article, we will create a new Pluggable database using DBCA. Here we have one Container database already created. ====================================================================================================== Follow below steps to create a new multitenant PDB using DBCA. Login as oracle user and run dbca $ dbca – Database Operation Select “Manage Pluggable Databases” and…

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…

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…

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…

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…

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…

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…

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…