mongorestore –oplogReplay gives you point-in-time recovery for a whole instance, replayed from the captured oplog of a single backup. It has no equivalent for a single database or a single collection. Say you need “restore just this one collection to 4:35pm” instead of the whole instance. The supported tooling has nothing to offer for in-place namespace point-in-time recovery (PITR). The…
If your Oracle database is running in ARCHIVELOG mode, monitoring your backups is essential.Without proper backup supervision, the Fast Recovery Area (FRA) can eventually become full, which may block archive log generation and, in the worst case, stop database activity. In this article, we will see how to monitor Oracle backups using Zabbix and the Oracle plugin available with Zabbix…
Replace brittle T-SQL links and manual checks with a central PowerShell orchestrator to reliably manage Always On backup data at scale.
How to test your Oracle RMAN backups
Backup operations can increase significantly I/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have some limitations.For the time being, supported backups on a secondary replicas are: So we cannot perform: Those limitations may cause…
Introduction SQL Server 2025 introduces a new algorithm for backup compression: ZSTD. As a result, SQL Server 2025 now offers three solutions for backup compression: In this blog, we will compare MS_XPRESS and ZSTD. Environment To perform these tests, the following virtual machine was used: Additionally, I used the StackOverflow database to run the backup tests (reference: https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/). ZSTD usage…
I recently had to install and configure the Veeam RMAN plug-in on an ODA, and would like to provide the steps in this article, as it might be helpful for many other people. Create Veeam linux OS user We will create an OS linux user on the ODA that will be used to authenticate on the Veeam Backup server. This…
In this article I will give a short overview of some Backup & Recovery features in the new Oracle 23ai database. Meanwhile there are more than 300 new features in Oracle 23ai most of them reflecting artificial intelligence. I will focus here on pure Backup & Recovery enhancements. Creating Immutable Backups Using RMAN It is now possible to store immutable…
This blog describes how to create a backup report in Enterprise Manager 13c.
1. Introduction In the world of PostgreSQL database management, ensuring robust backup strategies is mandatory. This week I discovered on postgresql.org latest news one useful tool that streamlines this process: pg_back. pg_back serves as a dedicated dumping tool designed for PostgreSQL. Its primary objective is to facilitate the comprehensive dumping of either all or specific databases, along with global entities,…
Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration & offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to hardware devices. At first it seems very interresting to speed up for instance backup tasks especially for big databases. But…
To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using platforms like Exadata Cloud at Customer. I recently had a case where both the Primary and the Standby site had…
