Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
In the previous part of this series, we set up a new instance on the destination server. Now, we move on to duplicating the source database using RMAN (Recovery Manager). This process can be performed using either a Push-based or…
When working with Oracle databases, there are times when you might need to duplicate a database to a different server for testing, backup, or development purposes. In this three-part series, we will walk through the process of creating a duplicate…
The ORA-00020 error occurs when Oracle exceeds the maximum number of processes allowed by the PROCESSES parameter. This setting controls the maximum number of user processes that can connect to the database at the same time. When this limit is…
Oracle Data Guard is one of the most important tools for keeping your database running smoothly in case of an emergency. It’s designed to ensure that your data is safe and always available, even if your main database goes down.…
When managing backups in Oracle RMAN (Recovery Manager), it’s essential to understand the difference between obsolete and expired backups. This distinction is key for keeping your storage clean and ensuring your database is recoverable within your desired retention policy. Obsolete…
Managing scheduled jobs in Oracle is crucial for automating tasks like gathering statistics. In this post, I’ll outline the steps I followed to query jobs in DBA_SCHEDULER_JOBS, check their execution schedule, and explore the content of a specific procedure associated…
Rebuilding indexes in Oracle is a resource-intensive task that can put pressure on your Fast Recovery Area (FRA) and affect Data Guard synchronization. Monitoring both is crucial to avoid lag in Data Guard and FRA overflow. In this article, we’ll…
Ensuring redundancy and proper management of redo logs in Oracle is essential for maintaining database availability and data recovery. This guide walks you through the steps to query, create, multiplex, and manage redo logs effectively. 1. Checking the Current Configuration…
Multiplexing the control file in Oracle is a crucial practice to enhance the security and availability of your database. This step-by-step guide walks you through a hands-on approach to properly multiplex a control file in Oracle. Step 1: Verify Existing…
Efficient storage management is a critical aspect of maintaining an Oracle database. Over time, database objects, particularly indexes, can grow disproportionately large and consume excessive storage space, impacting performance and increasing costs. Recently, I encountered a situation where indexes were…
