What is Oracle Data Guard
Let’s say you have a production database running your business — orders, transactions, customers, everything.Now imagine something goes wrong — the server crashes, there’s…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
Generate AWR, ASH, ADDM Reports from SQL Prompt
Oracle provides built-in tools to generate performance reports like AWR, AWRDD, ASH, and ADDM. These reports help identify resource issues, long-running queries, and system…
Recompile Invalid Schema Objects in Oracle
Invalid schema objects can cause runtime errors and unexpected behavior—especially after upgrades, patching, or DDL changes. Oracle can recompile them automatically, but it’s often…
ADRCI Commands
ADRCI (Automatic Diagnostic Repository Command-Line Interface) is a powerful Oracle utility for managing diagnostic data such as listener logs, alert logs, incidents, and core…
Oracle Flashback Commands
A concise guide to essential Oracle Flashback commands for database recovery, restore points, and undoing changes. Useful for managing Flashback settings, querying historical data,…
Oracle Data Guard Broker (DGMGRL) Commands
Key DGMGRL commands to configure, manage, validate, troubleshoot, and switch over Oracle Data Guard environments. Broker Setup (DB Level) Create & Enable Configuration View…
Oracle DBMS_SCHEDULER Commands
Oracle DBMS_SCHEDULER enables automation of routine tasks like report generation, cleanup, and backups. Below is a concise guide to creating, managing, and monitoring Scheduler…
ASMCMD Commands for Oracle ASM
ASMCMD (Automatic Storage Management Command-Line Interface) is used to manage ASM disk groups, disks, instances, and configurations. Below are essential commands categorized by their…
Linux Commands for Oracle DBA
A concise list of essential Linux commands every Oracle DBA should know to efficiently manage database servers, perform system checks, and troubleshoot issues. System…
Oracle RMAN Commands
A practical guide to essential Oracle RMAN (Recovery Manager) commands for performing database backups, recovery operations, maintenance tasks, validation, and cataloging. Commands are grouped…
Oracle CRSCTL Commands
This guide covers essential crsctl commands used to manage Oracle Clusterware components such as CRS, voting disks, OCR, cluster status, and network configuration. Each…
Oracle SRVCTL Commands
This guide is a practical cheat sheet for Oracle DBAs using srvctl in RAC environments. Each section below covers a specific srvctl command with…