Duplication of Oracle database on same node/cluster with skip of tablespaces
In this blog post I want to write about a typical restore scenario. You need to restore a database to a historical point in time to investigate some former data or maybe even rescue some data, but need to leave the source database intact. So…
GoldenGate: Initial Load DB2 to Oracle and HANDLECOLLSIONS
In this blog post I mainly want to discuss the GoldenGate parameter HANDLECOLLISIONS and do some tests to find out about its reliability. I always felt very uncomfortable whenever I needed to use it. So this post is also about the desire for trust in…
PostgreSQL’s foreign data wrapper to Oracle: hide passwords using secure external password store
Hi there, customer is worried about the credentials that are stored in PostgreSQL dbwhen using foreign data wrappers. In that case to Oracle, using oracle_fdw.It is possible to query a stored password from data dictionary. Only privileged users can do it, but still kind of…
FAN events and FCF for SEHA
With Oracle database version 19.7 we got Standard Edition High Availability as a kind of replacement for Standard Edition RACs which cannot be used as of 19c any more. See https://blogs.oracle.com/maa/standard-edition-high-availability-officially-released In a recent discussion I wondered whether FAN events and Fast Connection Failover might…
Data Guard – Definition of Online Redo Logs is “broken” after duplicate for standby
Hi there, today is the 1st birthday of a service request with Oracle I opened for which I see no progress since quite a while. I raised it exactly one year ago, on Oct 2nd 2019. There were some activity in last October, November mostly…
TNS chaos
I like to have my Oracle Net config consistent and without surprises. So for me it is a best practice to have ONE central TNS_ADMIN directory on the database server, which is set in all my shells. But a lot of processes might ignore that…
Preplugin Backups and the Missing Piece
Subheading 1: Preplugin Backups for non-CDB to PDB Conversions and the RMAN-06054 Subheading 2: PrePlugin Backups and the need for “Trick 17” The following is coming from a customer project. Imagine you have a huge non-CDB database, assume some terabytes. And you want to bring…
Getting the most out of Oracle Database Express Edition (XE) 18c
Express Edition is a nice starter database which comes for free and does not need a license. Well, you do not get support for it either. There where XE databases in 10g and in 11g, but in this blog post I look into current XE…
Why this Blog?
I had a blog, so why a new one? … Cause the old one was maintained by Trivadis – my employer – and just disappeared. Some customers and friends just asked me about that content. Thank you, that you consider it valuable. As it seems…
My First Blog Post
…. coming soon … Be yourself; Everyone else is already taken. — Oscar Wilde. This is the first post on my new blog. I’m just getting this new blog going, so stay tuned for more. Subscribe below to get notified when I post new updates.