Infrastructure at your Service

Tag

Oracle Archives - Blog dbi services

Daniel Westermann

Real time replication from Oracle to PostgreSQL using Data Replicator from DBPLUS

By | Database Administration & Monitoring | No Comments

I’ve done quite some real time logical replication projects in the past, either using Oracle Golden Gate or EDB replication server. Build in logical replication in PostgreSQL (which is available since PostgreSQL 10) can be used as well when both, the source and the target are PostgreSQL instances. While being at the DOAG conference and exhibition 2019 I got in contact with people from DBPLUS and they provide a product which is called “Data Replicator”….

Read More
Jérôme Dubar

Focus on 19c NOW!

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases. Both of them having patchsets (the last number) and regular patchset updates (the date optionally displayed at the end) to remove bugs and to increase security. Jumping from release 1 to release 2 required a…

Read More
Clemens Bleile

Elapsed time of Oracle Parallel Executions are not shown correctly in AWR

By | Database Administration & Monitoring | 2 Comments

As the elapsed time (time it takes for a task from start to end, often called wall-clock time) per execution of parallel queries are not shown correctly in AWR-reports, I thought I setup a testcase to find a way to get an elapsed time closer to reality. REMARK: To use AWR (Automatic Workload Repository) and ASH (Active Session History) as described in this Blog you need to have the Oracle Diagnostics Pack licensed. I created…

Read More
Marc Wagner

Adding a dbvisit standby database on the ODA in a non-OMF environment

By | Database Administration & Monitoring | No Comments

I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database, myDB, is running on server named srv02 and using a non-OMF configuration. On the ODA side we are working with OMF configuration. The dbvisit version available at that time was version 8. You need to…

Read More
Marc Wagner

Having multiple standby databases and cascading with dbvisit

By | Database Administration & Monitoring | No Comments

Dbvisit standy is a disaster recovery solution that you will be able to use with Oracle standard edition. I have been working on a customer project where I had to setup a system having one primary and two standby databases. One of the standby database had to run with a gap of 24 hours. Knowing that flashback possibilities are very limited on standard edition, this would give customer the ability to extract and restore some…

Read More
Marc Wagner

Connecting to ODA derby database

By | Database Administration & Monitoring | No Comments

ODA light (ODA X7-2S, X7-2M, X8-2S, X8-2M) come with an internal derby database to manage ODA metadata. From time to time, there is a need to check or update some information within it, as for example when facing database deletion issue. I would like to strongly advise that updating manually the ODA repository should only be done after getting Oracle support guidance and agreement to do so. Neither the author (that’s me 🙂 ) nor…

Read More