Mohammad Samad

Author's posts

Jun 12 2020

Configure Oracle 12c RAC to RAC Data Guard (DR) on Linux

We will discuss how to configure RAC to RAC Data Guard on Linux. If you follow all below steps you will able to configure the two node (or multi node) DR. Overview: A Data Guard configuration consists of one production database and one or more standby databases. The databases in a Data Guard configuration are connected by Oracle …

Continue reading

Jun 10 2020

Change Archive Log Mode in Oracle Database

In this topic, I will show how to change Archive Log Mode in Oracle Database. Enable Archive Log Mode in RAC: Archive Log Status:

Continue reading

May 27 2020

Install Oracle Software in Silent Mode

All kind of installations and configurations for Oracle RAC or Database, can be performed either using GUI or Silent mode. GUI mode is more easier as it shows all option (with details) step by step but it may not possible for all the cases or may not support on environment or may need to install …

Continue reading

May 22 2020

Creating a new file system for an existing Linux virtual machine

This article provides steps to create a new file system for an existing Linux virtual machine. Create a partition on new disk:

Continue reading

May 12 2020

Database Backup Script using RMAN

A backup is a copy of data. This copy can include important parts of the database, such as the control file and datafiles. A backup is a safeguard against unexpected data loss and application errors. If you lose the original data, then you can reconstruct it by using a backup. So taking database backup is …

Continue reading

May 02 2020

Automatic Storage Management (ASM)

In this topic, I will discuss how to manage ASM in Oracle including following items. Important queries to manage or monitor ASM. Create ASM DISKGROUP Manage Existing Diskgroup (add / drop disk) Tuning I/O Performance in Oracle ASM Mapping ASM Disk with Physical DISK ASM REDUNDANCY Level: NORMAL REDUNDANCY – Two-way mirroring, requiring two failure groups. …

Continue reading

Apr 14 2020

Oracle Database 12c R1 (12.1) RAC installation

Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. Below high level steps will perform to configure / install Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC Install Oracle Linux 5.7 Install GI (Grid Infrastructure) Configure ASM Install Oracle Database Binary Create Database …

Continue reading

Apr 13 2020

Create and Manage Partition Table in Oracle

Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. 

Continue reading

Apr 12 2020

USABLE_FILE_MB is showing negative values in V$ASM_DISK View

REQUIRED_MIRROR_FREE_MB value in V$ASM_DISKGROUP indicates how much free space is required in an ASM disk group to restore redundancy after failure of an ASM disk or ASM failure group. USABLE_FILE_MB value indicates how much space is available in an ASM disk group considering the redundancy level of the disk group. We need 3614 MB space …

Continue reading

Apr 08 2020

Configure Resource Manager on Container Database

The following issues DBAs may face in oracle databases but we can overcome these issues by using Resource Manager: Excessive overhead: Excessive overhead results from operating system context switching between Oracle Database server processes when the number of server processes is high. Inefficient scheduling: The operating system deschedules database servers while they hold latches, which …

Continue reading