Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB). This statement enables you to perform the following tasks: Create a PDB...
1 min read
Hey Folks , As a DBA, performing routine checks for fast recovery are (FRA) monitoring is a fundamental task. Here...
6 min read
Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task. Here are some scripts that...
15 min read
OpenSearch is a community-driven, open-source search and analytics suite used by developers to ingest, search, visualize, and analyze data. OpenSearch...
4 min read
Hey Folks, Today I faced an issue while configuring Oracle DR setup which was due to different diskgroup present in...
2 min read
A symlink is a symbolic Linux/ UNIX is a special kind of file that points to another file on your...
2 min read
To start a physical standby database, follow these steps using SQL*Plus with administrator privileges: Start the database in NOMOUNT mode:...
6 min read
Primary --Check DB role (PRIMARY/STANDBY) SELECT DATABASE_ROLE, DB_UNIQUE_NAME AS INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; DATABASE_ROLE INSTANCE OPEN_MODE PROTECTION_MODE...
2 min read
Hey Folks !! With the enhancement in Oracle 23ai features one of the beautiful thing which we can see is...
2 min read
Hey Folks !! Oracle Database 23c, the latest long-term support release, brings over 300 new features, with a focus on...
10 min read
Oracle Database 23ai is the next long-term support release of Oracle Database. It includes over 300 new features with a...
3 min read
Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that...
5 min read
Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and...
5 min read
Size of the Data: Determine the size of the database objects you intend to export. This includes tables, indexes, and...
5 min read
Hey Folks !! Today I have received a client requirement regarding exporting few columns from a table in Oracle 19c....
3 min read
Hey Folks !! Today I will guide you towards the process of raising Oracle SR via metalink website or also...
4 min read
Hey Folks, The objective of this blog post is to guide you through out the questionnaire that is being asked...
1 min read
From Alert logs ORA-1654: unable to extend index SCHEMA.IN021S1 by 128 in tablespace TBS_012024-03-23T16:26:11.156475+05:30ORA-1654: unable to extend index SCHEMA.IN021S1 by...
2 min read
Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as...
3 min read
The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter with the SERVICE attribute set,...
2 min read
ConfigMaster Nodes: 1Worker Nodes: 3DB Cluster Nodes: 2Postgres Operator: CNPGCluster Mode: 1 primary 1 standby Cluster Details: HostnameIPNode NameRoleExternal Storagemaster.localdomain 192.168.115.190k3s-mastermasterNAworker1.localdomain 192.168.115.195k3s-worker1worker200GiBworker2.localdomain 192.168.115.196k3s-worker2worker200GiBworker3.localdomain 192.168.115.197k3s-worker3worker200GiB...
18 min read
This content is password protected. To view it please enter your password below: Password:
25 min read
This content is password protected. To view it please enter your password below: Password:
42 min read
This content is password protected. To view it please enter your password below: Password:
1 min read
Share/Print/Export Output:The output of the search query can be shared, print or exported in the form of a csv. Delete/Inspect...
