Data loading:- create table t(c1 char(2000),c2 char(2000)); insert into t select ‘A’,’B’ from dual connect by rownum<1000000; commit; the data loading of 8 GB data took 160 sec . Now redo generation rate by 2 nodes RAC database as calculated by following example is:- SYS@EBILPD11> select thread#,sequence#,blocks*block_size/1024/1024 MB,(next_time-first_time)*86400 sec, blocks*block_size/1024/1024/((next_time-first_time)*86400)… Continue Reading Case Study on Network Bandwidth Calculation in 12c dataguard environment and testing with redo generation rate

Following article will describe how to start EC2 Instances on schedule using Lambda and send the public IP  instantly to multiple recipients over email using SNS. This activity will help to schedule start EC2 instances on a particular time during weekdays and send the public IP of the instances to… Continue Reading Lambda to Start EC2 Instances on schedule and send instant public IP over email to multiple recipients using SNS

This document describe the step to clone database in another host using RMAN from DR (Data gurad) .We need not to connect to source database.Moreover we will use different location for backup. A. Please follow below step for pre-requisites setup mentioned in below url 1.Copy the init parameter file from… Continue Reading RMAN clone from data guard DR to different host and different backup location

Introduction This document will help to guide you for installation of Oracle 12cR1 RAC grid infrastructure on Virtual Box which is very popular because of shared storage simulation feature. Below is overall requirement in nut-shell. Hostname:-rac1 Physical IP:-192.168.56.101 Private IP:-192.168.100.101 Virtual IP:- 192.168.56.103 Hostname:-rac2 Physical IP:-192.168.56.102 Private IP:-192.168.100.102 Virtual IP:-… Continue Reading Oracle Database 12c Release 1 (12.1) RAC GRID Infrastructure RHEL Redhat linux 7 VirtualBox

1 Background Often in many IT projects (involving Oracle as the primary RDBMS), we face an issue of bringing data from disparate systems. Now, the problem can be solved by implementing any ETL solution which has the required connectors/drivers to connect to different heterogeneous database systems and pull the required… Continue Reading Database Link Oracle to Heterogeneous Database Systems SAP HANA

1.Copy the init parameter file from source . 2.In target place this init file to $ORACLE_HOME/dbs 3.Change following parameter in init file to make it compatible to single instance. Replace original instance name to target name in pfile .For my case it should EBILTST as target. ##Remove following parameters## EBILDR12.__data_transfer_cache_size=0… Continue Reading RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name

PSU patching for 12.1.0.2:-   First Identify the patch to be downloaded:- Oracle 12.1.0.2 proactive DB patching . Patch number:-26635880.We needed to apply in RHEL 7 64-bit. Please download this patch from Oracle support. We need to follow below link for details of steps:- https://updates.oracle.com/Orion/Services/download?type=readme&aru=21529863   We need to download… Continue Reading Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017

1.We were going to open DB after shutdown immediate but it went hang.In alert log , we could only notice following message for 40 minutes.   Completed: ALTER DATABASE MOUNT Tue Oct 31 01:08:39 2017 ALTER DATABASE OPEN Beginning crash recovery of 1 threadsparallel recovery started with 9 processes Started… Continue Reading Oracle database instance recovery is taking too much time after shutdown immediate

Introduction If RDS Instances is AWS keep running without 24×7 usage, it can cost you very high in AWS billing. Take following example how idle RDS instances can cost you:- Lets take a medium sized RDS instance db.m4.xlarge (4CPU and 16GB RAM) in Sydney region for MySQL engine costs $0.492… Continue Reading Schedule Start & Stop RDS Instances and Save Money