0 Comments

Perform Mysql Physical Backup using Percona Xtrabackup 0 (0)

Perform Mysql Physical Backup using Percona Xtrabackup The Percona XtraBackup tools provide a method of performing a hot backup of your MySQL data while the system is running. Percona XtraBackup is a free, online, open source, complete database backups solution for all versions of Percona Server for MySQL and MySQL. Percona XtraBackup performs online non-blocking, tightly compressed, highly secure full backups on transactional […]

Loading

0 Comments

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle 0 (0)

RMAN Incremental Level 1 Differential and Cumulative Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental and differential Level 1 (L1) database backup which includes backup of datafiles (L1), control files, spfile along with archives. RMAN incremental backups back up only datafile blocks that have changed since […]

Loading

2 Comments

RMAN Incremental Level 0 Database Backup Scripts in Oracle 1 (1)

RMAN Incremental Level 0 Database Backup Scripts in Oracle In this article, we are going to prepare a script for RMAN Incremental Level 0 (L0) database backup which includes backup of datafiles (L0), control files, spfile along with archives. RMAN incremental backups back up only datafile blocks that have changed since a specified previous backup. You […]

Loading

0 Comments

Backup Based RMAN Duplicate Without Connecting To Target Database in Oracle 5 (1)

Backup Based RMAN Duplicate Without Connecting To Target Database in Oracle This article is a continuation of a recent article where we have demonstrated RMAN Active Duplicate Database in Oracle from ASM to ASM click here to go through it. In this article, we will perform a Backup Based RMAN Duplicate Without Connecting To Target […]

Loading

0 Comments

RMAN Active Duplicate Database in Oracle from ASM to ASM 5 (1)

RMAN Active Duplicate Database in Oracle from ASM to ASM In a recent article, we demonstrated about Step by Step Migrate Database from Non-ASM to ASM in Oracle click here to know more about it. In this article, we will demonstrate step by step RMAN Active Duplicate Database in Oracle from ASM to ASM with […]

Loading

0 Comments

Step by Step Migrate Database from Non-ASM to ASM in Oracle 5 (1)

Step by Step Migrate Database from Non-ASM to ASM in Oracle This article is a continuation of a recent article where we have demonstrated Offline Restore or Clone Database on the same server or rename database in Oracle click here to go through it. In this article, we will perform a Step by Step Migrate […]

Loading

0 Comments

Backups from the Standby Server using pgBackRest in PostgreSQL 0 (0)

Backups from the Standby Server using pgBackRest in PostgreSQL   In the previous blog, we have configured Streaming Replication Cluster using pgBackRest Click here to read more. We will use the same PostgreSQL cluster to show How we can take a backup from Standby Cluster using pgBackRest.  Below are the high-level steps which we will […]

Loading

0 Comments

Traditional Barman Setup With WAL Streaming in PostgreSQL 0 (0)

Traditional Barman Setup With WAL Streaming in PostgreSQL In the previous blog, we saw How To Configure Traditional Barman Backup Setup via rsync/ssh  Click here to read more. And How To Configure Streaming Backup & WAL Streaming using BARMAN Click here to read more. In this blog, we will combine features offered by both Setup […]

Loading

2 Comments

Traditional Barman Setup With WAL archiving via archive_command in PostgreSQL 0 (0)

Traditional Barman Setup With WAL archiving via archive_command in PostgreSQL   In the previous blog, we saw How To Configure Traditional Barman Backup Setup via rsync/ssh  Click here to read more. In this blog, we will replace archive_command for WAL archiving via rsync with barman-wal-archive. From Barman 2.6, the recommended way to safely and reliably […]

Loading

0 Comments

Streaming Backup With Fallback WAL Archiving in PostgreSQL 5 (1)

Streaming Backup With Fallback WAL Archiving in PostgreSQL In previous blog we saw How To Configure Streaming Backup & WAL Streaming using BARMAN Click here to read more. In this blog we will configure WAL archiving via barman-wal-archive along with WAL Streaming  for more robust architecture in PostgreSQL. This alternate approach requires:1. An additional SSH […]

Loading