Prepare by:  Nurullah Sharif Scope: Point in Time Recovery   Duplicate database until Point in Time recover, using backup location. #PointInTimeRecovery #DuplicateDatabase #RestoreDatabaseUsingBackupLocation   We are using full backup of 28-11-2017 and archivelog backup of 29-11-2017   Step 1: Take full backup and archive log backup. On target database :… Continue Reading Duplicate database until Point in Time recover, using backup location from RAC to single instance

Oracle introduced PDB from 12c to minimize following drawbacks in 11g   In 11g,sometimes we need to create numerous databases in single host which resulted below side effects and eventually slowed down whole system. 1.Too many background processes. 2.High shared memory. 3.Many copies of oracle metadata. Now We will delve… Continue Reading CDB and PDB concepts in Oracle 12c

———-Progress index creation————– set lines 200 col “Index Operation” for a60 select sess.sid as “Session ID”, sql.sql_text as “Index Operation”, longops.totalwork, longops.sofar, longops.elapsed_seconds/60 as “Runtime Mins”, longops.time_remaining/60 as “ETA Mins” from v$session sess, v$sql sql, v$session_longops longops where sess.sid=longops.sid and sess.sql_address = sql.address and sess.sql_address = longops.sql_address and sess.status =… Continue Reading Index creation progress in oracle

Prerequisites for Upgrading to Enterprise Manager Cloud Control 13c Release 2 1.First latest PSU patch needs to be applied in GRID and ORACLE home. In my case latest patch of that time was as below Patch 24412235: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.161018 (OCT2016) Prepatch operation log file location: /u01/app/product/12.1.0/grid/cfgtoollogs/crsconfig/hapatch_2016-12-19_01-58-57PM.log… Continue Reading Step by step Upgrade cloud control from 13cR1 to 13cR2 (13.2.0.0.0)

Time stamp problem:- sqlplus system/****@ORCL SQL>alter session set nls_date_format=’dd-mm-yyyy hh:mi:ss’; SQL>select instance_name from v$instance; SQL>select   sysdate,   current_timestamp,   systimestamp,   localtimestamp from   dual; The above query will show different time . How to Fix:- 1.1                               Stop the apps and DB cluster/HAS. su – root cd /orasw/app/grid/product/11.2.0/grid/bin ./crsctl… Continue Reading Oracle time stamp showing wrong timezone connecting TNS remote

Following topic will discuss how to Backup and Restore PostgreSQL Databases directly in S3. This topic will help you to leverage AWS S3 -IA storage to use as Backup Storage for any number of PostgreSQL databases running under an instance. This topic will cover PostgreSQL Instance running on EC2 or… Continue Reading PostgreSQL Database Backup to S3 and Restore from S3 using simple shell script

OVERVIEW OF SQL Please create the scott schema from the following GITHUB repository https://github.com/oracle/dotnet-db-samples/blob/master/schemas/scott.sql EXECUTING SELECT STATEMENT SQL> SELECT * FROM DEPT; DEPTNO DNAME LOC ———- ————– ————- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON HANDLING NULL VALUES SQL> SELECT EMPNO,ENAME,NVL(MGR,0) FROM EMP; EMPNO… Continue Reading BASIC SQL REFERENCE FOR ORACLE DBA

We faced this error during Oracle12cR2 installation. During our installation of oracle 12.2 in new home on existing Oracle 11g installation,we faced the error   LOG INFO: Executing [/opt/oracle/product/12.2.0.1/db1/bin/diagsetup, clustercheck=false, basedir=/opt/oracle/product, oraclehome=/opt/oracle/product/12.2.0.1/db1] /opt/oracle/product/12.2.0.1/db1/bin/diagsetup WARNING: java.lang.UnsatisfiedLinkError: /opt/oracle/product/12.2.0.1/db1/oui/lib/linux64/liboraInstaller.so: /opt/oracle/product/12.2.0.1/db1/oui/lib/linux64/liboraInstaller.so: undefined symbol: JNU_ThrowByName WARNING:        at java.lang.ClassLoader$NativeLibrary.load(Native Method) WARNING:        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941) WARNING:        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1824)… Continue Reading Error undefined symbol: JNU_ThrowByName during oracle 12c R2 installation

This document describes process to add additional swap space in RHEL 7. 1.First partition your newly added disk [root@LinuxAcademy dev]# gdisk /dev/xvdf GPT fdisk (gdisk) version 0.8.10 Partition table scan: MBR: not present BSD: not present APM: not present GPT: not present Creating new GPT entries. Command (? for help):… Continue Reading Add additional swap space in RHEL 7

This document describes the procedure to extend your existing mount point after adding the disk in RHEL 7 using LVM. 1.Please create partition on newly added disk [root@linuxacademy1 ~]# gdisk /dev/xvdf GPT fdisk (gdisk) version 0.8.6 Partition table scan: MBR: not present BSD: not present APM: not present GPT: not… Continue Reading Extend LVM after adding new disk to the server Linux