RMAN clone from data guard DR to different host and different backup location
This document describe the step to clone database in another host using RMAN from DR (Data gurad) .We need not…
7 years ago
Oracle Optimizer Cost Calculation from explain plan
This post video provide you basic method how oracle calculate cost from explain plan it derives
7 years ago
Oracle Database 12c Release 1 (12.1) RAC GRID Infrastructure RHEL Redhat linux 7 VirtualBox
Introduction This document will help to guide you for installation of Oracle 12cR1 RAC grid infrastructure on Virtual Box which…
7 years ago
Database Link Oracle to Heterogeneous Database Systems SAP HANA
1 Background Often in many IT projects (involving Oracle as the primary RDBMS), we face an issue of bringing data…
7 years ago
RMAN cloning oracle 12c database RAC to single instance from tape backup to another host in new database name
1.Copy the init parameter file from source . 2.In target place this init file to $ORACLE_HOME/dbs 3.Change following parameter in…
7 years ago
Database proactive patching step (PSU) 26635880 for 12.1.0.2 October 2017
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…
7 years ago
Oracle database instance recovery is taking too much time after shutdown immediate
1.We were going to open DB after shutdown immediate but it went hang.In alert log , we could only notice…
7 years ago
Schedule Start & Stop RDS Instances and Save Money
Introduction If RDS Instances is AWS keep running without 24×7 usage, it can cost you very high in AWS billing.…
7 years ago
Troubleshoot connection issue using standalone jdbc driver to oracle
Hi All Please download following file from Google drive and keep in unix directory say /home/oracle //drive.google.com/open?id=0B8-3R318F39hQUJOcnVPMUdrNzg The files to…
7 years ago
Different restore and recovery scenario for PDB and CDB in Oracle 12c
Introduction The next document will describe the steps to restore scenario for CDB and PDB using Data protector and RMAN…
7 years ago