Creating a Data Guard Physical Standby environment Once you have your primary database up and running these are the steps to follow. Enable Forced Logging Create a Password File Configure a Standby Redo Log Enable Archiving Set Primary Database Initialization Parameters… Read More
Dear Readers, In this article, we will see the following Multitenant Database Introduction A Container database (CDB) is made up of the following containers: There is one root container which stores the Oracle supplied metadata like the PL/SQL data dictionary packages and the common users.… Read More
Introduction to Oracle Data Guard Data Guard gives us the high availability, data protection and disaster recovery for the data. Configuring one or more standby databases for the production database can help in surviving the disasters and data corruptions. The Oracle Data Guard can… Read More
Cross Platform Transportable Tablespace Transportable Tablespace is used to move a large amount of data between databases where the tablespace is copied from source database to the target database. A Tablespace can be Transport between databases on the same Platform from version 8i.… Read More
DATABASE CREATION Oracle Database can create by using the following 3 methods Manual database creation OMF method (Oracle Managed database Files) DBCA method (Database Configuration Assistance) Steps to create database in manual method. Declare or specify variables or set up environmental variables:… Read More
Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are already available to continue serving. Clusters come in two general configurations, active-passive and active-active. In active-passive clusters, all writes are… Read More
About MySQL replication MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database. Advantages of replication in MySQL include: Scale-out solutions – spreading the load among… Read More
TRANSPORTABLE TABLESPACE IN ORACLE Transportable Tablespace is used to move large amount of data between… Read More
Hadoop has many distributions and every distribution has a stack or you can say a collection of technologies/framework that work in conjunction with Hadoop and is knows as HADOOP ECOSYSTEM. Below is the hadoop ecosystem. Please note there are a plethora of technologies and distributions… Read More
MySQL Replication Setup Replication in MySQL. You will have to setup Master and Slave server. All read-writes to the DB could go to your Slave Server. Advantage of having Replication is you can take a backup from your slave server without interrupting Master server,… Read More
