The latest Oracle database version, Oracle 23ai, introduced
a new open mode called Hybrid Read-Only for pluggable databases
(PDBs). Local users can only connect with read-only access when a PDB is set to
this new mode. However, common users are not restricted and can still
perform write operations.
Command to convert...
Oracle Dataguard Broker Configuration (DGMGRL)
Data Guard Broker is a
command-line interface that makes managing primary and standby databases easy.
DBA can use a single command to switch from primary and standby and vice versa.
Several pre-defined commands can
be used to manage Data Guard....
Oracle 23ai : Use of NOVALIDATE Constraints in IMPDP
While performing impdp operations
in the Oracle database, Oracle performs validation checks for every constraint
on the imported table, that can cause a significant delay in importing data.
All new Oracle 23ai, introduces new feature called NOVALIDATE CONSTRAINTS In
this article, we’ll cover its functionality, benefits, practical usage, and the
scenarios...
Data pump (expdp/impdp) troubleshooting in Oracle 23ai
The latest database version, Oracle 23ai, i.e., version 23c
with AI features enabled, is powerful and brings a lot of features to view and
troubleshoot different parts of the database
Once such an improvement is on the data pump utility and its
troubleshooting with all new dynamic performance views
There are a few issues while performing a data pump...
Oracle ASM Scrubbing
What is ASM Scrubbing?
ASM scrubbing is a process used to
identify and repair data corruption issues within an ASM disk group. ASM
Scrubbing scans the data stored in the disk group and checks for
inconsistencies or corruption. The process typically involves reading each data
block, comparing it to expected values, and correcting errors by...
ORACLE : Creating a new pluggable database using PDB$SEED
As a database administrator, you might come across creating a pluggable database, here is the method to create a pluggable database (PDB), Follow the below steps to create a pluggable database using the default pluggable database PDB$SEEDStep 1: Connect
to the Container database using admin privileges
[oracle@localhost
Desktop]$ sqlplus...
RMAN Backup of Container and Pluggable Database in 19c/21c/23c
In multitenant architecture, there are two databases involved, container
database and pluggable database.To manage RMAN backups of these databases, we need to consider different
scenarios,Backup of a container database (CDB+PDB)Backup of pluggable databaseBackup of the root container Case 1: RMAN Backup of container (CDB) plus pluggable database...