PostgreSQL 15 – Move Data Directory

PostgreSQL

The Postgres data directory, sometimes known by the environment variable $PGDATA that references it is the heart of your database cluster installation. We as Database Administrators should never touch files within the data directory (with very few exceptions), as we could harm the integrity of the database software or completely destroy the database itself. That

Read More

Oracle Database 19c Install Script for Oracle Linux 8

Oracle

Installing Oracle Database is a time-consuming process, especially when done manually. There are plenty of resources on the web for accomplishing the process using Vagrant, Ansible, or other automated build tools. These are helpful and tend to work well, but in some cases, we’re not allowed to make use of this tooling. Having to install

Read More

Recovery Catalog – Backup Summary

Oracle

Use of a recovery catalog provides for additional protection against data loss. The catalog database holds information about databases, their structure, backupsets, and a host of other useful information. The best part about it is that all of this useful information for multiple databases is available in the tables and views of the user that

Read More

Oracle Database – Instance Monitoring Script

Oracle

For most organizations using Oracle Database the de facto tool for monitoring instance health is Oracle Enterprise Manager Cloud Control. While Cloud Control is great at what it does, there are times when the Oracle Management Server (OMS), the Oracle Management Agent, or other components of Cloud Control are down. This could be during maintenance

Read More