How to Fix ORA-31696 When Using DIRECT_PATH Import in Oracle Data Pump
When performing a schema or table import using Oracle Data Pump with the DIRECT_PATH method, you might encounter the following error: This error simply…
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
How to Check If Your Oracle Database Is Multitenant (CDB or non-CDB)
Oracle introduced the Multitenant Architecture starting in version 12c. This allows multiple Pluggable Databases (PDBs) to exist inside a single Container Database (CDB), bringing…
Oracle Index Management
What is an Index in Oracle? An index in Oracle is a performance tuning structure that improves the speed of data retrieval on a…
Opening a Physical Standby Database
1. Real-time Query What is Real-time Query? Real-time Query allows you to run read-only queries on a physical standby database while redo apply is…
Starting & Shutting Down a Physical Standby Database
Use the STARTUP command from SQL*Plus. 📝 Note:If Redo Apply is started before the standby has received any redo from the primary, you may…
Role Transitions in Oracle Data Guard
Seamlessly switch roles between primary and standby databases to ensure high availability and disaster recovery. What is a Role Transition? In Oracle Data Guard,…
Apply Services in Oracle Data Guard
Apply Services in Oracle Data Guard Apply Services keep the standby database updated by applying redo data received from the primary — using core…
Redo Transport Services in Oracle Data Guard
The mechanism that keeps your standby database in sync with the primary — in real time or near real time. What Are Redo Transport…
Oracle Data Guard Protection Modes
Oracle Data Guard Protection Modes Balance between data safety and performance — you choose the right level for your business What Are Protection Modes?…
Far Sync Instances in Oracle Data Guard
🛰️ A lightweight relay to ensure zero data loss across long distances What is a Far Sync Instance? A Far Sync Instance is like…
Types of Standby Databases in Oracle Data Guard
Oracle Data Guard uses standby databases to maintain a real-time or near-real-time replica of your primary database. These standby databases help ensure disaster recovery…
Primary Database
The Primary Database is the main, production database in an Oracle Data Guard setup.It’s the one your users, apps, and systems actually connect to…