High availability

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show(…)

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

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(…)

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

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(…)

Azure SQL Managed instances, Business Critical Tier and high availability

Last blog of this year 2018 with SQL databases and Cloud Azure and this is not trivial choice. <Speculation mode> I would say year 2019 could be important for all stakeholders. Cloud transformation has begun in many forms at customer(…)

Strange behavior when patching GI/ASM

I tried to apply a patch to my 18.3.0 GI/ASM two node cluster on RHEL 7.5. The first node worked fine, but the second node got always an error...

SQL Server 2019 availability groups – Introduction to R/W redirection

writeThis is a second write-up about SQL Server 2019 CTP2.0 and availability group new features. This time the interesting one is about READRWRITE redirection capabilities. A couple of months ago, I wrote about SQL Server 2017 and(…)

SQL Server availability groups, SQL Browser and Shared Memory considerations

Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating(…)

How to migrate Grid Infrastructure from release 12c to release 18c

Oracle Clusterware 18c builds on this innovative technology by further enhancing support for larger multi-cluster environments and improving the overall ease of use. Oracle Clusterware is leveraged in the cloud in order to provide enterprise-class resiliency where required and dynamic(…)

First steps into SQL Server 2019 availability groups on K8s

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(…)

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

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).