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
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
Configure pgbackrest on Backup Host – Remote in PostgreSQL In the previous blog, we demonstrated How to install pgbackrest on Database Server – Local in PostgreSQL Click here to read more. Such setups are not used in a production environment to perform the backup on the same server where the database is running. In this blog,
Configure pgbackrest on Database Server – Local in PostgreSQL pgBackRest is an open-source backup tool for PostgreSQL which offers easy configuration and reliable backups. pgBackRest is a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms optimized for database-specific requirements. Some of the key
Physical PostgreSQL Backup using BARMAN In the previous blog, we have demonstrated Install & Configured barman tool in Backup Server Click here to read more. In this blog, we will use barman tool to take database backups. List available servers: Use command barman list-server to get the list configured server in barman. Show configured parameters: Use
Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux) In a recent blog, we demonstrated Step by Step Install Linux 8 (OEL) along with Guest Addition, in this article, we will perform Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux). To upgrade OEL 8.2 to 8.4, we will be using
Install and Configure BARMAN for PostgreSQL BARMAN (Backup and Recovery Manager) is an open-source administration tool for backup and disaster recovery of PostgreSQL servers. It allows performing remote backups of multiple servers. Following are barman features. 1) Open Source Tool. 2) Remote backup and restore of multiple Servers. 3)
Physical PostgreSQL Backup using pg_basebackup pg_basebackup is used to take base backups of a running PostgreSQL database cluster. It Can be used both for point-in-time recovery and as the starting point for log shipping or streaming replication standby servers. pg_basebackup makes a binary copy of the database cluster files while making sure the system is
Physical PostgreSQL Backup Is file system-level copy of files that comprise the database cluster can be either Offline or Online mode. Advantage : 1) Generally faster to backup and restore. 2) Allow Point-In-Time-Recovery PITR (If WAL are archived) 3) Full or Incremental backup. 4) Will allow DDL during backup. Disadvantage : 1) Lack of flexibility:- Backup/Restore entire DB Cluster. Selective
Logical PostgreSQL Backup – Import Logical (SQL DUMP) Database Backup (Export/Import) is an extract of some or all data or structure of objects within the database. This is a dump in the form of an SQL command that can be executed on the server in order to recreate database objects. Advantage:1) Flexibility: Dump files are OS-independent. 2) Cross Version Compatibility: Take backup from Higher Version and
