Database Blog

OEM13.4 TARGET STATUS SHOWING WARNING

INTRODUCTION  This blog is about, one of our non-prod OEM13C environment the Database target status was showing warning eventhough the target is actually up and running.  SOLUTION  Login into OEM…

Read More

Manual Data Guard Manual Failover 

Introduction to Failover:  Oracle Failover is a critical feature designed to ensure high availability and continuous operation of Oracle databases in the event of unexpected system failures. In enterprise environments…

Read More

Oracle patch prerequisite failed with PRVF-4083 & PRKN-1035 

ISSUE:  When I initiated the grid patch, it failed while executing the prerequisite with the following errors:  PRVF-4083: Node reachability check failed from node <NODE1>.  PRKN-1035: Host unreachable.”  Cause of…

Read More

How to download the database backup from OCI storage using MV2bucket

Introduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to download the database backup from OCI…

Read More

Backup and Restore validation for Oracle database in OCI console

Introduction: Oracle Cloud Infrastructure (OCI) offers robust tools and features that allow database administrators to manage backups and restores efficiently. Ensuring that data is securely backed up and easily restorable…

Read More

Steps to apply and rollback patch in OCI console

Introduction : Maintaining the security and performance of your Oracle Database is crucial, and applying patches is a key aspect of this maintenance. Oracle Cloud Infrastructure (OCI) simplifies the process…

Read More

How to upload the backup files to OCI Archival storage using MV2bucket

Introduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to Upload the database backup files from…

Read More

Steps to delete the Inactive Patches in Oracle Database

Please follow the below steps to delete the same.   cd $ORACLE_HOME/OPatch ./opatch util listorderedinactivepatches -silent ./opatch util deleteinactivepatches -silent ./opatch util listorderedinactivepatches -silent

Read More

Monitoring and Managing Streaming Replication in PostgreSQL

Streaming replication in PostgreSQL is a vital feature for ensuring data availability and redundancy. Once your primary and standby servers are set up, it’s essential to monitor the replication status…

Read More

PostgreSQL Master and Slave Configuration Guide: Implementing Streaming Replication

PostgreSQL’s streaming replication is a powerful feature that allows real-time data replication from a primary database server (master) to one or more standby servers (slaves). This guide will take you…

Read More