1 min read
Hey Folks , As a DBA, performing routine checks for fast recovery are (FRA) monitoring is a fundamental task. Here...
Oracle
1 min read
6 min read
Hey Folks, As a DBA, performing routine checks for tablespace monitoring is a fundamental task. Here are some scripts that...
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:
2 min read
Good evening Sir/Madam, I am glad to be here for the interview. I am <Your_name>, an engineering graduate from <College...
1 min read
Database release 19.7, has finally attained certification for Oracle Linux 8. However, successful installation may necessitate some workarounds. Begin by...
2 min read
Introduction ORAchk (Oracle Autonomous Health Framework) is a utility provided by Oracle to perform proactive health checks and validation of...
