Infrastructure at your Service

Category

Database management

Jérôme Dubar

ODA: odacli now supports Data Guard in 19.8

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

Introduction I’ve been dreaming of this kind of feature: just because most of the ODA configurations now include Disaster Recovery capabilities, through Data Guard or Dbvisit standy. If Dbvisit will obviously never be integrated to odacli, the lack of Data Guard features is now solved by the very latest 19.8 ODA software appliance kit. How Data Guard was implemented before 19.8? Those who have been using ODA and Data Guard for a while know that…

Read More
Ali Asghari

Create and configure an Oracle linked server in SQL Server Instance

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

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database is not easy. A linked servers is configured to enable the Database Engine to execute a Transact-SQL statement that includes…

Read More
Franck Pachot

DBPod – le podcast Bases de Données

By | AWS, Cloud, Database Administration & Monitoring, Database management, Development & Performance, DevOps, NoSQL, Oracle, Postgres, SQL Server | No Comments

By Franck Pachot . J’essaie quelque chose de nouveau. Je publie beaucoup en anglais (blog, articles, présentations) mais cette fois quelque chose de 100% francophone. En sortant du confinement, on reprend les transports (train, voiture,…) et c’est l’occasion de se détendre en musique mais aussi de s’informer avec des podcasts. J’ai l’impression que c’est un format qui a de l’avenir: moins contraignant que regarder une video ou ou lire un article ou une newsletter. Alors…

Read More
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