0 Comments

Offline Restore or Clone Database on the same server or rename database in Oracle 0 (0)

Offline Restore or Clone Database on the same server or rename database in Oracle In a recent article, we have demonstrated How to Rename Database using CONTROLFILE in Oracle, click here to go through it. In this article, we will demonstrate Offline Restore or clone Database on the same server with a new name or rename database […]

 51 Total Views,  9 Views Today

2 Comments

Configure Streaming Backup and WAL Streaming using BARMAN 0 (0)

Configure Streaming Backup & WAL Streaming using BARMAN In our previous blog, we saw steps to set up Traditional BARMAN Setup via rsync/SSH Click here to read more.  In this blog, we will see How to Configure Streaming Backup & WAL Streaming using BARMAN. Traditionally, Barman has always operated remotely via SSH, taking advantage of […]

 128 Total Views,  2 Views Today

0 Comments

Point in Time Recovery (PITR) using pgBackRest in PostgreSQL 0 (0)

Point in Time Recovery (PITR) using pgBackRest in PostgreSQL In the previous blog, we saw How to perform Full recovery using backup taken from pgBackRest Click here to read more.   In this blog, we will see How to perform PITR using backup taken from pgBackRest in PostgreSQL. For demonstration, we will be using our PostgreSQL Cluster created on […]

 80 Total Views

0 Comments

Restore Backup using pgBackRest in PostgreSQL 0 (0)

Restore Backup using pgBackRest in PostgreSQL In the previous blog, we saw How to Install and Configure pgBackRest for Backup Click here to read more.  In this blog, we will see How to perform a restore of a backup taken from pgBackRest. We will complete steps for the below two scenarios: 1. Restore in the same directory […]

 98 Total Views,  2 Views Today

0 Comments

Point in Time Recovery (PITR) using BARMAN in PostgreSQL 0 (0)

Point in Time Recovery (PITR) using BARMAN in PostgreSQL In the previous blog, we saw How to perform Full recovery using backup taken from BARMAN Click here to read more. In this blog, we will see How to perform PITR using backup taken from BARMAN in PostgreSQL.  For demonstration, we will be using our PostgreSQL […]

 109 Total Views,  1 Views Today

0 Comments

Restore Backup using BARMAN in PostgreSQL 0 (0)

Restore Backup using BARMAN in PostgreSQL In previous blog, we saw How to Install and Configure BARMAN for Backup Click here to read more.  In this blog, we will see How to perform a restore of a backup taken from BARMAN. We will see complete steps for the below two scenarios: 1. Restore in the same […]

 124 Total Views,  1 Views Today

0 Comments

Point in Time Recovery (PITR) using pg_basebackup in PostgreSQL 0 (0)

Point in Time Recovery (PITR) using pg_basebackup in PostgreSQL In previous blog we saw How to perform Full recovery using backup taken from pg_basebackup  Click here to read more. In this blog we will see How to perform PITR using backup taken from pg_basebackup in PostgreSQL.  For the purpose of demonstration we will be using our second […]

 79 Total Views,  2 Views Today

0 Comments

Restore Backup using pg_basebackup in PostgreSQL 0 (0)

Restore Backup using pg_basebackup in PostgreSQL In this blog, we will see How to perform a restore of a backup taken from pg_basebackup. We will see full steps for the below two scenarios: 1. Restore in the same directory structure of the backup database.2. Restore in the different directory structures of the backup database. For […]

 141 Total Views,  3 Views Today

0 Comments

How to Rename Database and DBID using DBNEWID in Oracle 0 (0)

Rename Database and DBID using DBNEWID in Oracle In this article, we are going to demonstrate rename of the database along with DBID using utility DBNEWID in Oracle. The question comes in mind why we require to rename DB? Whenever we do clone a database to a target (clone DB) server from the source (production […]

 122 Total Views,  6 Views Today

0 Comments

Physical Backup using pgBackRest in PostgreSQL 0 (0)

Physical Backup using pgBackRest in PostgreSQL In the previous blog, we have demonstrated Configure pgbackrest on Backup Host – Remote in Backup Server Click here to read more. In this blog, we will use the pgbackrest tool to take different types of database backup. pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable […]

 106 Total Views,  1 Views Today