In this article you will get to know the step by step installation of Recovery Catalog Database Using RMAN utility. By default, RMAN connects to the target database in NOCATALOG mode, meaning that it uses the control files in the target database as the sole… Read More
Dear Readers, In this article, we will see the step by step Configuration of Oracle DGMGRL Utility. let’s start the step by step Oracle DGMGRL Utility configuration. Step 1 :First we should check the DB name, DB unique name, open_mode, database_role of both the servers Primary… Read More
Dear Readers, In this article, you will get to know the Oracle Physical Standby Dataguard step by step configuration in 11g. Required Parameters to configure the Oracle Physical Standby Dataguard setup:- DB_NAME= It should be the same on the primary and standby side. DB_UNIQUE_NAME= Must be different on the primary… Read More
Dear Readers, In this article we will get to know how we can perform step by step Switchover and Switchback configuration in Oracle 11g. Switchover: – A switchover is a technique through which the roles reversal is possible between the primary database and standby database. At the time… Read More
Python Scripting for Oracle databases. Dear Readers, Please check below YouTube video links for establishing python scripts for Oracle databases. Link 1 : How to launch EC2 instance with RHEL 7.5 AMI Link 2: installation of Oracle 12cR1 Database software on AWS EC2 instance Link… Read More
Dear Readers, In this article, we will see Installation of Virtual Box Guest additions on Oracle Enterprise Linux 8.1 Today we will understand the step by step Installation of Virtual Box Guest additions on Oracle Enterprise Linux 8.1. To complete this configuration we need to… Read More
Dear Readers. In this article ,we will see MySQL Migration from SUSE (M & S) to RHEL (M & S) through Cascading Slaves. Environment : Mysql version : 5.7.13-enterprise-commercial awsserver1: Suse Master awsserver2: Suse Slave Replication exists between awsserver1 and awsserver2, and is the current… Read More
Dear Readers, In this article, we will see TERADATA SPACE CONCEPTS AND SPACE UTILITIES There are three types of spaces available in Teradata. Permanent Space Permanent space is the maximum amount of space available for the user/database to hold data rows. Permanent tables, journals, fallback… Read More
Dear Readers, In this article , we will see JOIN INDEXES IN TERADATA. A join index is an indexing structure containing columns from multiple tables, specifically the resulting columns from one or more tables. Rather than having to join an individual table each time the… Read More
Dear Readers, In this article, we will see Transient Journaling in Teradata Transient Journaling Journals Journals are kept on the system to provide data availability in the event of a component or process failure in the system: Recovery journals Permanent journals Recovery Journal The Teradata… Read More
Dear Readers , In this article, we will see Hash indexes in Teradata. Hash indexes are file structures that share properties in common with both single-table join indexes and secondary indexes. From an architectural perspective, the incorporation of auxiliary structures as a transparently embedded element… Read More
SHOW LOCKS UTILITY Dear Readers, In this article , we will see show locks utility in Teradata. What is SHOWLOCKS ? When a table or database is being backed up, it places a HUT lock on the object, which is released when it finishes backup… Read More
Dear Readers, In this article, we will understand the Oracle to SQL Server Migration Issues which I have faced during the migrationactivity. We will look at the resolution of the below issues one by one. Issue 1)A network-related or instance-specific error occurred while establishing a… Read More
Dear Readers, Today we will see the step by step installation of Oracle Enterprise Linux 8.1 Installation. To complete this configuration we need to follow below steps. Download the Oracle Virtual Box software. Download the Oracle Enterprise Linux 8.1 ISO image. Installation of Virtual Machine… Read More
ACCESS RIGHTS IN TERADATA Hi Readers, This article contains types of access(Privileges) in Teradata. What is a privilege ? A database privilege is a permission to access or to manipulate a database object or data. Privileges are sometimes called access rights, permissions, or authorizations. Privileges… Read More
Dear Readers, In this article, we will learn about Partitioned Primary Index in teradata. Partitioned Primary Index A primary index can be either Partitioned OR Non-partitioned Primary indexes for join and hash indexes can also either be hash- or value-ordered, while primary indexes for all… Read More
Dear Readers, In this article, we will learn about COMPRESSION IN TERADATA. We all know that now-a-days how many transactions are happening per day in this digital world. To store those data in data warehouse we need more storage disk. So everyone is looking for… Read More
Dear Readers, In this article, we will learn about BLOCK LEVEL COMPRESSION IN TERADATA. Block Level Compression (BLC) is a space reduction technique in Teradata. It has been introduced in 13.10 and is used to apply compression to all the permanent data blocks in a… Read More
PERMANENT JOURNAL Dear Readers, In this article, we will learn about PERMANENT JOURNAL IN TERADATA The permanent journal in Teradata provides the capability to capture the snapshot of permanent tables before and after applying changes using DML statements like insert, delete and update. Copies of… Read More
NOPI( NO PRIMARY INDEX) table in Teradata Dear Readers, In this article, we will learn about No Primary key indexes in Teradata As the name suggests, No primary index table means there is no primary index defined on Teradata table. This feature has been introduced… Read More
