All articles

A new OGG challenge: Migrate an Oracle 8.1.7.4 instance to 10.2.0.5

Yes, these beasts still exist in production: [/u01/appl/ora817]$ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Thu Apr 27 09:54:20 2017 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. SQL> select * from v$version;(…)

Migrating from oracle to postgresql with ora2pg

By Mouhamadou Diaw PostgreSQL is one of the most used Rdbms. In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found(…)

Save the date: Swiss PGDay 2017

The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but(…)

Oracle 12.2 tables, indexes new features

The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes. The first new feature is about the online table move. In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations. To(…)

Listener and Virtual IP

By Franck Pachot . When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That's the role of Transparent Application Failover, but this requires configuration on the client side. If(…)

Does the wal segment size matter in PostgreSQL?

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the(…)

12cR2 RMAN> REPAIR

By Franck Pachot . Do you know the RMAN Recovery advisor? It detects the problems, and then you: RMAN> list failure; RMAN> advise failure; RMAN> repair failure; You need to have a failure detected. You can run Health Check if(…)

Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c

By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.

SecureFiles on multi-datafiles tablespaces

By Franck Pachot . When we have a tablespace with multiple datafiles, we are used to seeing the datafiles filled evenly, the extents being allocated in a round-robin fashion. In the old time, we used that to maximize performance, distributing(…)

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first(…)