As a database professional with over 20 years of managing Oracle environments, I've seen firsthand how database security has evolved from a checkbox task to a mission-critical discipline. With threats becoming increasingly sophisticated and auditors relying more...
Database Blog Posts
Resolving Oracle Patch Issues: Troubleshooting ORA-20001 and Applying Datapatch
Keeping your Oracle database up to date with patches is crucial for both security and performance. However, patching issues can arise, leading to errors such as ORA-20001. In this blog, we'll walk through a real-world troubleshooting scenario where an Oracle 19c...
Stop Throwing Money at the Problem: How XTIVIA Optimizes Your Managed Cloud Database
Cloud databases offer scalability and flexibility but can become a money pit if not correctly managed. Often, when performance issues arise – slow queries, application latency, or unexpected downtime – the knee-jerk reaction is to throw more resources at the problem....
Using Oracle Cloud Storage with RMAN for Backups
Oracle Cloud Infrastructure (OCI) provides a secure and scalable Object Storage solution for storing database backups. By integrating Oracle Recovery Manager (RMAN) with Oracle Cloud Infrastructure (OCI), organizations can achieve efficient, cost-effective, and...
Percona XtraBackup vs MySQL Enterprise Backup: Which One Should You Choose?
When it comes to backing up large MySQL databases, especially without downtime, two tools dominate the conversation: Percona XtraBackup and MySQL Enterprise Backup (MEB). Both are designed for hot backups (backups that do not require stopping the database) and support...
Creating and Sizing the Oracle Fast Recovery Area
When creating the fast recovery area, place it on a separate disk from the database binaries and data files. For this example, I am using the C drive because this is on a VM, which is what is available. The size of your fast recovery will also depend on several...
Understanding Transparent Application Failover in Oracle Database
What is Transparent Application Failover (TAF)? TAF is a feature in Oracle that helps maintain database availability by automatically reconnecting client applications to a different database server when a failure occurs (such as a network failure or server crash) or...
Create Temporary Tablespace in Oracle and Make It the Default Temporary Tablespace
This article covers the steps to create a temporary tablespace in Oracle and make it the default temporary tablespace for the database. Step-By-Step This method works for both regular Oracle databases and multitenant databases. Each PDB and CDB has its own separate...
How to Upgrade Oracle Database to 19c
Below is a step-by-step guide to walk you through how to upgrade oracle database to 19c. Step 1 Download the Oracle 19c binaries, the latest version of OPatch, How To Download And Install The Latest OPatch (6880880) Version (Doc ID 274526.1) and the AutoupGrade Tool...
The Rising Costs of Database Monitoring Tools and Why Virtual-DBA Is the Smarter Choice
Businesses rely on robust database monitoring to ensure systems are secure, reliable, and high-performing. However, the costs associated with traditional database monitoring tools are climbing, placing a heavy burden on organizations looking to manage growing...