Infrastructure at your Service

Category

Database management

Jérôme Dubar

Oracle Cloud basics for beginners

By | Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 2 Comments

Introduction Cloud, Cloud, Cloud. Everyone is talking about the Cloud but a lot of people are still in the fog with Cloud technologies. Let’s talk about basic features of the Oracle Cloud, called OCI for Oracle Cloud Infrastructure. What is really OCI? OCI is physically a lot of servers in datacenters all around the world. These servers are not very different from the servers you probably have in your own datacenter. Some of these servers…

Read More
Christophe Cosme

AWS – RDS – SQL Server Native backups

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

Introduction RDS provide automatic backup feature. This feature will backup the entire RDS instance. As a DBA sometimes you need to backup individual database, they are many reason for that (legal, migration, replication,…). Unfortunately individual database backups are not available within the RDS instance. This post explains how you can enable the native database backup on RDS , as you are used to with an on-premises SQL Server instance. To summarize we will create a…

Read More
Joël Cattin

pgBackRest – a simple privileges-related issue

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

I recently had to replace Barman by pgBackRest as Backup & Recovery solution for one of my customer. The purpose of this blog is not to show how I made the setup (some dbi blogs already exists for that), but only to share a small issue I encountered during the creation of the Stanza : [email protected]:/ [cms2] pgbackrest –stanza=cms2_primary stanza-create ERROR: [058]: version ’11’ and path ‘(null)’ queried from cluster do not match version ’11’…

Read More
Marc Wagner

Applying archive log on a standby is failing with error ORA-00756: recovery detected a lost write of a data block

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

During one last ODA project, I was deploying dbvisit software version 9.0.10 on Oracle database SE Edition version 18.7. From time to time I was getting lost write of a data block with type KTU UNDO on the standby. Through this blog, I would like to share my investigation and experience on this subject.

Read More
Jérôme Dubar

6 things Oracle could do for a better ODA

By | Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction With the latest ODA X8 range, at least 80% of the customers could find an ODA configuration that fits their needs. For the others, either they can’t afford it, either they are already in the Cloud, or they need extremely large storage or EXADATA performance. Among these 80% of customers, only a few choose ODA. Let’s see how Oracle could improve the ODA to make it a must. 1) Make robust and reliable releases…

Read More
Stéphane Savorgnano

Use MABS to protect Hyper-V on-premises VMs workload

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

During my last blog post I explained how to installed a MABS. Now that your infrastructure is setup you will be able to protect the workload of your Hyper-V Virtual Machines. You have first to create a new protection group. This group will contain one or more VMs which will share the same backup configuration for retention, synchronization and recovery. Protection is managed as follow: DPM create a copy of the selected data on the…

Read More
Jérôme Dubar

Oracle Database Appliance: which storage capacity to choose?

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction If you’re considering ODA for your next platform, you surely already appreciate the simplicity of the offer. 3 models with few options, this is definitely easy to choose from. One of the other benefit is also the hardware support of 5 years, and combined with software updates generally available for up to 7 years old ODAs, you can keep your ODA running even longer for non-critical databases and/or if you have a strong Disaster…

Read More
Elisa Usai

The evolution of MySQL authentication mechanism

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

The authentication, the first level of security for each IT system, is the stage to verify the user identity through the basic username and password scheme. It is crucial to have a mechanism to protect and secure password storing and transmitting over network. In MySQL, there is plenty of different authentication methods available, and last versions improved the security of this concept.

Read More
Jérôme Dubar

ODA 19.6 is available

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 5 Comments

Introduction It’s been 1 year now that 19c is available on-premise. Finally, 19c is now available today on ODA too, in a real production release. Let’s have a glance of what’s inside. Is 19.6 available for my old ODA? The 19.6 release, like most recent releases, is the same for all ODAs. But oldest ODAs will not support it. First-gen ODA (now 8 years old), X3-2 (7yo) and X4-2 (6yo) won’t support this very latest…

Read More