Infrastructure at your Service

Category

Database management

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 | No 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
Petre Radut

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
Jérôme Dubar

Patching ODA lite to 12.2.1.4.0

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

Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the patch The patch number is 28216794. This patch will update the following components:  dcs (odacli), operating system, bios/firmwares, ilom, GI, dbhomes and databases. Download and copy the patch to a temporary folder on the server,…

Read More
Michael Hein

Logical standby: No view for data guard status on session level

By | Database management, Oracle | No Comments

On logical standby you have to switch off data guard at least on session level to make modifications on objects which are maintained by data guard. This is done by command alter session disable guard; Dataguard can be reenabled for this session by issuing alter session enable guard; For executing these commands “alter database” privilege is at least needed, which is often not liked by IT security staff. Command “alter session disable guard” is also…

Read More
David Barbarin

SQL Server on Linux – I/O internal thoughts

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

Let’s start the story from the beginning with some funny testing I tried to perform with SQL Server on Linux a couple of months ago. At that time, I wanted to get some pictures of syscalls from SQL Server as I already did in a past on Windows side with sysinternal tools as procmon and stack traces. On Linux strace is probably one of the best counterparts. Firstly, please note this blog is just from…

Read More