Infrastructure at your Service

Category Archives: Database management

Petre Radut

Create a primary database using the backup of a standby database on 12cR2

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

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp'; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….

Read More
Petre Radut

Recover a corrupted datafile in your DataGuard environment 11G/12C.

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

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to repair the Standby database, without to be necessary to restore entire database. Initial situation : DGMGRL> connect / Connected to “PROD_SITE2″ Connected as SYSDG. DGMGRL> show configuration; Configuration – CONFIG1 Protection Mode: MaxPerformance Members: PROD_SITE2 -…

Read More
Christophe Cosme

Copy or Migrate a SSISDB environment

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

Integration catalog is easy to work with and the environments feature is as well very convenient. In SQL Server management Studio, there are a lot of features available to administrate your SQL Server instances, but some are missing that can be very useful. You have the possibility to move an SSISDB environment but this is only possible in another folder of your SSIS catalog. But how if you will to duplicate your environment or move…

Read More
Joël Cattin

OEM Cloud Control 13c – Agent Gold Image

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

Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : oracle@oms13c:/home/oracle/ [agent13c] opatch lsinventory |…

Read More
Thomas Rein

DOAG 2018: OVM or KVM on ODA?

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

The DOAG 2018 is over, for me the most important topics were in the field of licensing. The insecurity among the users is great, let’s take virtualization on the ODA, for example: The starting point: The customer uses Oracle Enterprise Edition, has 2 CPU licenses, uses Dataguard as disaster protection on 2 ODA X7-2M systems and wants to virtualize, he also has 2 application servers that are also to be virtualized. Sure, if I use…

Read More
Yann Neuhaus

Flashback to the DOAG conference 2018

By | Application integration & Middleware, Database Administration & Monitoring, Database management | No Comments

Each year, since the company creation in 2010, dbi services attends the DOAG conference in Nürnberg. Since 2013 we even have a booth. The primary goal of participating to the DOAG Conference, is to get an overview about the main trends in the Oracle business. Furthermore, this conference and our booth allow us to welcome our Swiss and German customers and thank them for their trust. They’re always pleased to receive some nice Swiss Chocolate…

Read More
Clemens Bleile

Technical and non-technical sessions at the DOAG 2018

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

The amazing DOAG 2018 conference is over now. As every year we saw great technical as well as great non-technical sessions. What impressed me was the non-technical presentation “Zurück an die Arbeit – Wie aus Business-Theatern wieder echte Unternehmen werden” (back to work – how business theatres become real business company again) provided by Lars Vollmer. It was very funny, but also thought-provoking. Lars started with the provocative sentence that people do work too less….

Read More
Stéphane Haby

SQL Pass Summit 2018: SQL Server 2019 features coming soon!

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

It’s the 20th anniversary of the event and the keynote today was amazing (see the blog from Christophe) for different reasons but the more important is that is every time better people. Not only DBA’s but also people using their application connected to the database. Today, one of my focus will be the next version of SQL Server 2019 with the session of Bob Ward, Asad Khan & Amit Banerjee from Microsoft. I already tested…

Read More
Christophe Cosme

Pass summit – dbi visit day 3

By | Big Data, Business Intelligence, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

The Microsoft data platform is evolving The third day began with the Keynote help by Rohan Kumar the Corporate Vice President of Azure Data by Microsoft The main message was “Hybrid data platform is the way for the future” and Microsoft is working in this direction. The use of AI and analytic to transform the customer business is also a key driver for the Microsoft data platform, which is building to enable this easily. Rohan…

Read More