2 Comments

Important Technical Links Powered by DBsGuru 5 (4)

Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are […]

 2,197 Total Views,  10 Views Today

0 Comments

Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux) 0 (0)

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 […]

 13 Total Views,  13 Views Today

0 Comments

Install and Configure BARMAN for PostgreSQL 0 (0)

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) […]

 21 Total Views,  11 Views Today

0 Comments

Physical PostgreSQL Backup using pg_basebackup 0 (0)

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 […]

 30 Total Views,  6 Views Today

2 Comments

Physical PostgreSQL Backup 0 (0)

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 […]

 48 Total Views,  3 Views Today

0 Comments

Logical PostgreSQL Backup – Import 0 (0)

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 […]

 58 Total Views,  4 Views Today

0 Comments

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation 0 (0)

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation In this article we will solve error [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’.  Above error occurred while 19c (19.3) binary installation on server Oracle enterprise Linux version (OEL) 8.2 or greater than version 8.1 i.e Oracle 19c supported up to version […]

 56 Total Views,  4 Views Today

0 Comments

Logical PostgreSQL Backup – Export 0 (0)

Logical PostgreSQL Backup – Export Logical (SQL DUMP) Database Backup 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) […]

 52 Total Views,  2 Views Today

0 Comments

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility 5 (1)

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility Upgrading a database is always a big task for DBAs in this world but this time Oracle introduces a new feature in 19c for an upgrade which is called “AutoUpgrade Utility” where we will upgrade a database from version 12c to 19c. Supported version for upgrade […]

 101 Total Views,  5 Views Today

0 Comments

Similarities Between Oracle and PostgreSQL 0 (0)

Similarities Between Oracle & PostgreSQL In this blog, we will compare similarities between Oracle & PostgreSQL in terms of Memory, Process, Files, General architecture, etc. COMPONENTS ORACLE POSTGRESQL Architecture: Memory Shared Global Area (SGA) Shared Memory DB buffer cache Shared buffer Log Buffer WAL (Write Ahead Log) Buffer Private Global Area (PGA) Work Memory Architecture: […]

 76 Total Views,  1 Views Today

0 Comments

Solution for OGG-00516 Fatal error executing DDL replication 0 (0)

Solution for OGG-00516 Fatal error executing DDL replication In this blog, we will perform a solution to resolve OGG-00516 Fatal error executing DDL replication.This error occurs when the golden gate REPLICATE process unable to perform the same DDL on Target DB which was executed on Source DB. In the Target database, you may not create […]

 64 Total Views,  2 Views Today