Oracle Active Data Guard Overview & Architecture

We have seen 3 types of Standby Databases

  1. Physical Standby Database
  2. Logical Standby Database
  3. Snapshot Standby Database

To know more about it Oracle Dataguard

Oracle 11g comes with a new option : Oracle Active Data Guard.

Oracle Active Data Guard is an optional license for Oracle Database Enterprise Edition. Active Data Guard enables advanced capabilities that that extend basic Data Guard functionality. Oracle Active Data Guard allows us to use real time query the standby database.


Converting a Snapshot Standby Database to a Physical Standby Database

In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby.

Prerequisites : Snapshot database is already exists

Primary Database Snapshot Standby database
mgr mgr

Step 1 : Check Primary Database Information :

SQL> select name,open_mode,database_role from v$database;

--------- -------------------- ----------------

Step 2 : Check Snapshot Database Information :

SQL> select name,open_mode,database_role from v$database;


Converting a Physical Standby Database to a Snapshot Standby Database

In the previous post, we can read about Snapshot Standby Overview. In this post, we can convert to Snapshot Standby.

Prerequisites :

Physical Standby Database is already created and synchronized with Primary Database .

Database Details :

Step 1: Check Primary database :

[oracle@localhost admin]$ sqlplus / as sysdba

SQL*Plus: Release Production on Fri Apr 27 15:09:14 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g  (more...)

Activating a Snapshot Standby Database:Issues and Cautions and Target Restriction

We have already seen overview of snapshot standby database.
But while converting snapshot standby database few things we need to consider.
  1. Corruption of log files : As we already know snapshot database accepts redo log files from primary when it is converted to snapshot mode but it does not apply redo log to snapshot standby. So, if there is a corruption of redo log file at the standby database has occured , we can not (more...)

Snapshot Standby Databases: Overview & Architecture

Snapshot Standby Database :

We have already seen types of standby database in Data Guard. Oracle Dataguard

In this article we are going to see Snapshot Standby Database in deep.

In snapshot standby type database stays in a read,write mode that is fully update-able database. Snapshot standby database is created by converting physical standby database into a snapshot standby database.

When standby database is converted into a snapshot database , it receives redo data but (more...)

SQL Loader in Oracle

Today we are going to learn about “SQL Loader”. The journey of Oracle Database does not end here.  Let’s have look at the technical definition of SQL Loader.

what is SQL Loader?

The primary method for quickly populating Oracle tables with data from external files is called SQL*Loader. From its powerful data parsing engine that puts a little limitation on the format of the data in the datafile. SQL*Loader is invoked when you specify the (more...)

Managing Role in Oracle

Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases.



Let’s start with roles in Oracle.

Creating a Role:

create role OracleHelp;

Assign Privilege to a role:

grant create session,create table  (more...)

Flashback in Oracle

We are going to have look at another part of the Oracle database. Flashback is going to be the topic of our discussion of today. Let’s start with its introduction after that with its example.

Being DBA we have to make us familiar with Flashback technology. It is considered as a good feature of Oracle Database.

What is flashback technology? 

Let’s have a technical definition of flashback technology.

Oracle Flashback Technology is a group of Oracle (more...)

Loading Tables with Oracle GoldenGate and REST APIs

With Oracle GoldenGate 12c (, you can now quickly load empty target tables with data from your source database. You could always do this in previous releases of Oracle GoldenGate, but the process has now been simplified using REST APIs and some scripting know-how. In this post, I’m going to show you, high level, how you can use the REST APIs and a bit of scripting to do an initial load (more...)

BCOUG Tech Day 18 Summary

On April 27th (2018) we had our first BCOUG Tech Day conference! If you are reading this and you’re part of an OUG board, you know how stressful and how much work it is to organize such an event. But the bottom line: it was very successful! I decided to write this post for a … Continue reading BCOUG Tech Day 18 Summary

Filtering outliers from Oracle APEX activity logs

Last year I described a simple test case that described how to remove outliers from a fictional dataset using the STDDEV() analytical function .

I want to follow this up with a practical case using one of my favourite data sets - the apex_workspace_activity_logs that record who opened what page, in what context, and how long it took to generate.

I've been keeping an eye on the performance of a particular page, (more...)

Thinking About Oracle Cloud Applications Support

Last week Oracle announced a revision to their Cloud Applications Support . At first glance it looks great, anything that gives the customer more is welcome.

I haven't seen a lot of commentary on this but I like this from Denis Beagle from my friends at Diginomica oracle-announces-autonomous-services-media-day, he talks about it being paid for from the actual subscription costs. I totally agree with that statement but actually think Oracle is moving some of the (more...)

LEAP#389 Two-Stage Amp Design

Reviewing techniques for two-stage CE amplifier design. My calcs are a bit off (under-estimated gain), but I got a workable Class A amplifier out of it! As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo on GitHub hero_image

Dynamische Linesize-Einstellung für sqlplus

Die Welt hat vielleicht nicht darauf gewartet, ich aber ganz gewiß: wie Laurent Schneider erläutert, gibt es mit Oracle 18.1 eine dynamische linesize für sqlplus. Diese orientiert sich an der Größe des Shell-Fensters. Hätte ich diese Option von 15 Jahren bekommen, hätte ich dadurch in Summe mehrere Wochen einsparen können, nehme ich an.

VBCS Goes Technical – but i still love it

Last weekend VBCS was upgraded and in this new version (18.2.3) it is so much more technical to look at.

I first saw this release at the PaaS Forum in March and was deflated, I loved that the product was so easy to use and felt that it did have a market in the system support teams as EBS customers moved to Cloud Applications.

The Product Management team were very helpful, at the PaaS (more...)

KeePass 2.39.1

I just noticed KeePass 2.39.1 was released about a week ago.

Downloads and Changelog available from the usual places.

You can read about how I use KeePass and KeePassXC on my Mac, Windows and Android devices here.



KeePass 2.39.1 was first posted on May 14, 2018 at 8:51 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not (more...)

Creating an Oracle Rest Data Services Docker image

Oracle has added Oracle Rest Data Services (ORDS) to the Docker build files family on GitHub, which means that you can now easily dockerize ORDS. If you don’t know yet what ORDS is, it’s a free technology from Oracle that allows you to REST-enable your Oracle databases. More specifically, with ORDS you can just fire … Continue reading "Creating an Oracle Rest Data Services Docker image"

PostgreSQL Calling File

Somebody asked: How do you run a script file from PostgreSQL’s psql prompt? I created two files to answer the question. Here are the two files:

Static File

SELECT 'Hello World!';

Dynamic File

SELECT 'Hello ['||current_user||']!';

It’s a simple solution, you put a \i or \include before the script file name, like:

\i helloworld.sql


\include hellowhom.sql

I hope this helps those trying to call SQL script files from an interactive psql session.

From file names to directory hierarchy

I had a fun request come in from a colleague the other day.  They had a simple list of fully qualified file names and they needed to present that data in the familiar hierarchical tree layout. 

To demonstrate, I took a little trip down memory lane Smile and grabbed a subset of presentations I’ve done over the years.

SQL> create table t ( fname varchar2(1000));

Table created.

SQL> insert into t values ('C:\Users\Connor\Presentations\2002\scene_200205. (more...)

Ubuntu 16.04: Installation of chrome-browser fails with libnss3 (>= 2:3.22)

On my old laptop with ubuntu 16.04 i tried to install "chrome-browser":
# dpkg -i google-chrome-stable_current_amd64\ \(1\).deb 
Vormals nicht ausgewähltes Paket google-chrome-stable wird gewählt.
(Lese Datenbank ... 137351 Dateien und Verzeichnisse sind derzeit installiert.)
Vorbereitung zum Entpacken von google-chrome-stable_current_amd64 (1).deb ...
Entpacken von google-chrome-stable (64.0.3282.186-1) ...
dpkg: Abhängigkeitsprobleme verhindern Konfiguration von google-chrome-stable:
 google-chrome-stable hängt ab von libnss3 (>= 2:3.22); aber:
  Version von libnss3:amd64 auf dem System ist 2:3.21-1ubuntu4.