In Oracle, a “shutdown” refers to the process of stopping the Oracle Database instance. There are several types of shutdowns available, depending on the purpose and the level of activity in the database. Here are the common types of shutdowns in Oracle: 1. Shutdown Normal This is the regular and graceful way to shut down…
Category: Oracle
Add or Create A New ASM Disk
Adding or creating a new ASM (Automatic Storage Management) disk involves several steps. ASM is a feature of Oracle Database that manages database files and provides striping and mirroring for better performance and redundancy. Here’s a general outline of the process to add or create a new ASM disk: 1. Identify the Disk First, identify…
Primary & Standby SYNC Check
In Oracle Data Guard, you can check whether the standby database is in sync with the primary database by monitoring the apply lag. The apply lag represents the time delay between when a redo log is generated on the primary database and when it is applied on the standby database. A zero or low apply…
Oracle Data Guard
Oracle Data Guard is a high-availability solution provided by Oracle Corporation to enhance the resilience and availability of Oracle databases. It enables the creation, maintenance, and monitoring of one or more standby databases that can be used for disaster recovery, reporting, or backup purposes. The primary database (also known as the production database) is kept…
Oracle Architecture
Introduction Oracle, one of the world’s leading database management systems, serves as the backbone of countless enterprise applications and systems. With its robust architecture, oracle helps organizations to handle massive amounts of data while ensuring data security, integrity, and availability. In this blog, we will embark on a journey to explore the intricate details of…