Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
This post is mainly for self documentation as I have to search my old notes every time I want to do this (I am faster by searching on our blog 🙂 ): If you want to monitor GoldenGate with Cloud Control using the GoldenGate plugin you’ll have to install the JAGENT on the host where GoldenGate is running on and…
By Franck Pachot . I had a recent question about the following mention from the 12cR2 Multitenant book, about Partial PDB backups: . Here is an example in 12.2 with local undo to illustrate the answer, which may help to understand what is a partial PDB backup. Of course, since 12cR1 you can backup PDB individually, without the CDB$ROOT, in…
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; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.7.4.0 – Production PL/SQL Release 8.1.7.4.0 – Production CORE 8.1.7.0.0 Production TNS for Solaris:…
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 here. After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle…
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 you can expect that to happen next week. What we can say already is that we will be there and that you can expect…
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 realise this operation, we must use the ONLINE keyword and/or the UPDATE_INDEXES clause. If you remember, in the previous Oracle…
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 you can’t configure TAF, you can use a virtual IP address. But then the question is how to configure the…
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 wal segments is usually 16MB. Although 16MB seems very low you don’t need to worry about that in most of the cases,…
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 it was not detected automatically (see https://www.dbi-services.com/blog/oracle-12c-rman-list-failure-does-not-show-any-failure-even-if-there-is-one/). In 12.2 you can run the repair directly, by specifying what you want…
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. New parameters Here is the result of a diff between 12.1 and 12.2 ‘imp help=y’ But for this post, I’ll show the parameters that existed in 12.1 but have…
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 the tables to all disks. Today, we use LVM striping, maximum Inter-Policy, ASM even distribution. And we may even use…
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 blog post, I wrote about SQL Server on Linux and the introduction of availability groups features. At this moment the SQL Server release version was CTP 1.3. As…
