Goldengate REPORTING P2

Previous post for Goldengate REPORTING

Goldengate reporting has to be the least implemented functionality until it is needed and often in hindsight.

Here is an example of what I would normally implement.

STATOPTIONS RESETREPORTSTATS
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 15 MINUTES, RATE
DISCARDROLLOVER AT 00:01 ON SUNDAY

If business only cares about monthly data, then would not make sense to collect daily nor would it make sense for business to request such.

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.

(more...)

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;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  READ WRITE	       PRIMARY

Step 2 : Check Snapshot Database Information :

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

NAME	  OPEN_MODE	       DATABASE_ROLE
 (more...)

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 11.2.0.4.0 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 (12.3.0.1.x), 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

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.

Cheers

Tim…


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...)

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>
SQL> insert into t values ('C:\Users\Connor\Presentations\2002\scene_200205. (more...)

Oracle Code : Warsaw – The Journey Home

I woke up at silly o’clock to begin my journey home. I checked out of the hotel and got a taxi to the airport, where I breezed through check-in and security and found myself at the boarding gate 2 hours before the flight. Another hour in bed would have been nice… 🙂

As usual, out came the laptop and I played catch-up on the blog and some of the other stuff I had missed during the (more...)

Oracle Code : Warsaw

Oracle Code : Warsaw started for me with my first presentation of the day as I was in the first block after the keynotes…

My first session was about Analytic Functions. It’s a little difficult to predict the makeup of the Oracle Code crowds. In some cities you get predominantly Oracle developers, while in others it’s the opposite. As a result, you never know how what you are doing will be received until you get (more...)

Patch Recommendations for Oracle Database 12cR1 and Cloud Control 13cR2

During my consulting engagements I see a lot of systems and many bugs. Most of the time, there is already a patch available to avoid the bug. I have collected all the recommended patches for the Oracle Database 12.1.0.2 (SE2 and EE) and Oracle Enterprise Manager 13cR2. This should help to avoid most critical known issues. Versions 12.2.0.1 and 18c will be added later this year.

Patch Recommendations

Skip Scan 3

If you’ve come across any references to the “index skip scan” operation for execution plans you’ve probably got some idea that this can appear when the number of distinct values for the first column (or columns – since you can skip multiple columns) is small. If so, what do you make of this demonstration:


rem
rem     Script:         skip_scan_cunning.sql
rem     Author:         Jonathan Lewis
rem     Dated:          May 2018
rem

begin
        dbms_stats.set_system_stats('MBRC',16);
        dbms_stats.set_system_stats('MREADTIM',10);
        dbms_stats.set_system_stats('SREADTIM',5);
         (more...)

DataGuard Convention

Good convention and implementation make life and automation so much simpler and more time for golfing.

I have seen some really poor and really good implementation and here’s a good one.

Wish I can take credit for it and unfortunately I cannot.

The scripts were created by whoa.

Scripts an be run from primary or standby for any instances provided profile to source database environment exists on host.

Use ORACLE_UNQNAME for DataGuard Environment

====================================================================================================
+++  (more...)

Oracle Code : Warsaw – The Journey Begins

For a change it was a normal wake-up time for me. The advantage of flying late morning is you don’t have to get up so early. The disadvantage is the traffic. I left an hour earlier than usual, just to make sure, and it paid off. I missed some of the traffic, but there were some questionable decisions by my taxi driver. He seemed like a nice guy, but his SatNav was taking us on (more...)

Dell EMC "Ready Bundle for Oracle"

The Dell EMC "Ready Bundle for Oracle" supports both production OLAP and OLTP along with test/dev environments in a single VMware virtualized environment. The high availability (HA) architecture and design built at every component level of the solution eliminates single point of failure and provides flexibility for planned maintenance downtime. 

Lower entry point with a purchase price up to 55% lower than the most advanced engineered solution for Oracle in the market, according to (more...)