Infrastructure at your Service

Category

Database management

Joël Cattin

From Oracle to Postgres with the EDB Postgres Migration Portal

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

EnterpriseDB is a valuable actor in PostgreSQL’s world. In addition to provide support, they also deliver very useful tools to manage easily your Postgres environments. Among these we can mention EDB Enterprise Manager, EDB Backup & Recovery Tool, EDB Failover Manager, aso… With this post I will present one of the last in the family, EDB Postgres Migration Portal, a helpful tool to migrate from Oracle to Postgres. To acces to the Portal, use your…

Read More
David Barbarin

First steps into SQL Server 2019 availability groups on K8s

By | Cloud, Database management, DevOps, SQL Server | No Comments

A couple of weeks ago, Microsoft announced the first public CTP version of next SQL Server version (CTP2). It is not a surprise, the SQL Server vNext becomes SQL Server 2019 and there are a plenty of enhancements as well as new features to discover. But for now, let’s start with likely one of my favorites: availability groups on Kurbernetes (aka K8s). As far I may see from customers and hear from my colleagues as well,…

Read More
Stéphane Haby

SQL Server Tips: How many different datetime are in my column and what the delta?

By | Database management, Development & Performance, SQL Server | No Comments

Few months ago, a customer asks me for finding in a column, how many rows exist with the same date & time and the delta between them. The column default value  is based on the function CURRENT_TIMESTAMP and used as key as well. This is obviously a very bad idea but let’s go ahead… This anti pattern may lead to a lot of duplicate keys and the customer wanted to get a picture of the…

Read More
Mouhamadou Diaw

Dbvisit 8 Standby Daemon on Windows

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

In this previous blog, we have installed Dbvisit standby for Windows on both servers. We suppose that the database is created and that the standby is configured (see this blog). The steps are the same that on Linux except that the command is launched on a traditional DOS terminal or a PowerShell. We will not describe these steps (see here for more details). Dbvisit by default will neither send nor apply the archived log files….

Read More
Mouhamadou Diaw

Install Dbvisit 8 on Windows

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

In a previous blog we described how to install dbvisit standby in a Linux box. In this article I am going to describe the installation on a Windows machine. We are using dbvisit 8 and windows server 2016. The name of my servers are winserver1 and winserver2. The first thing you will have to do is to download dbvisit standby package here . A trial key will be sent to you. Before starting the installation…

Read More
Stéphane Haby

SQL Server Tips: Drop a database-user attached to a service…

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Few weeks ago, I have a little issue when I try to drop a database-user without login Unfortunately, I do a little mistake at the beginning… I receive like every morning a report if all AD logins (computers, groups, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins This report indicates that a computer name dbi\server_name$ was no more in the AD. I drop the login without problem and…

Read More
Jérôme Dubar

Restoring a database without having any controlfile backup

By | Database Administration & Monitoring, Database management, Oracle | One Comment

It should never happen but sometimes it happens. You just lost your datafiles as well as your fast recovery area (probably because most of the time these areas are on the same disks despite the recommendations). Normal restore operations with RMAN are quite easy and secure as far as you have backupsets for database, archivelogs, and spfile/controlfile: Step 1 – restore the spfile and start the instance Step 2 – restore the controlfile and mount…

Read More
Clemens Bleile

Running PLSQL as SYSDBA through DEFINER-rights?

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

Recently I got an interesting request: The customer wanted to allow the application installation routine to create a guaranteed restore point without giving it all required privileges to do so. So the idea was to encapsulate creating and dropping a guaranteed restore point in a PLSQL package and granting the application owner the permission to execute the package. The problem with that approach is that SYSDBA-privileges are required to create a guaranteed restore point and…

Read More
Jérôme Dubar

Easily manage dual backup destination with RMAN

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

Backup on disk with RMAN is great. It’s fast, you can set as many channels as your platform can handle for faster backups. And you can restore as fast as you can read and write files on disk with these multiple channels. As far as you’re using Enterprise Edition because Standard Edition is stuck to a single channel. Disk space is very often limited and you’ll probably have to find another solution to keep backups…

Read More
Oracle Team

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

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

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver). Assumptions : You have installed Oracle GI 12.1 as grid user You have installed Oracle Database 12.1 as oracle user You have configured the groups asmadmin,asmoper,asmdba You installed oracle-rdbms-server-12cr2-preinstall rpm You patched your Oracle GI to…

Read More