KTEXPERTS – Page 65 – KNOWLEDGE SHARING PLATFORM

ORACLE – Creating a Data Guard Physical Standby environment – Part2

7 years ago by SUMAN MORAOracle Dataguard

Continuation to the Data Guard Physical standby creation ORACLE – Creating a Data Guard Physical Standby environment – PART1 Enable Archiving On 10g you can enable archive log mode by mounting the database and executing the archivelog command:

SQL> startup mount;

ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 75499088 bytes
Database Buffers 205520896 bytes
Redo Buffers 2973696 bytes
Database mounted. 

SQL> alter database archivelog;
Database altered.

SQL> alter database open;
Database altered.

SQL> archive log list Archive Mode
Database log mode 
Automatic archival Enabled
Archive destination /test/PRIMARYDB/archdest/arch
Oldest online log sequence 92
Next log sequence to archive 94
Current log sequence 94

SQL> startup mount;

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 75499088 bytes

Database Buffers 205520896 bytes

Redo Buffers 2973696 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list Archive Mode

Database log mode

Automatic archival Enabled

Archive destination /test/PRIMARYDB/archdest/arch

Oldest online log sequence 92

Next log sequence to archive 94

Current log sequence 94

Set… Read More

ORACLE – Creating a Data Guard Physical Standby environment – PART1

7 years ago by SUMAN MORAOracle Dataguard

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

Multi-tenant Database Introduction

7 years ago by SUMAN MORAOracle 12C New Features

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

ORACLE – Introduction to Oracle Data Guard

7 years ago by SUMAN MORAOracle Dataguard

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

ORACLE: Cross Platform Transportable Tablespace

7 years ago by SUMAN MORAOracle DB Admin

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

Oracle : DATABASE CREATION

7 years ago by SoundharyaOracle DB Admin

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

How to Configure a Galera Cluster with MySQL

7 years ago by Abdul ManafMySQL

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

How to Set Up Master Slave Replication in MySQL

7 years ago by Abdul ManafMySQL

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

Oracle : TRANSPORTABLE TABLESPACE IN ORACLE

7 years ago by SoundharyaOracle DB Admin

TRANSPORTABLE TABLESPACE IN ORACLE Transportable Tablespace is used to move large amount of data between… Read More

HADOOP ECOSYSTEM

7 years ago by Neeraj SharmaBig Data Hadoop

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