Oracle Archives - Page 4 of 30

What is the difference between Prepatch and Postpatch in Oracle Patching !!

Hey Folks !! In Oracle patching, the terms prepatch and postpatch refer to specific sets of tasks or procedures that need to be performed before and after applying a patch…

asrblogger August 14, 2024No Comments

Oracle

How to identify the top Wait Events within a Wait Class in Oracle ??

Each wait event in Oracle belongs to a specific class. Below is a breakdown of the various wait classes and their descriptions:1. Administrative These waits occur due to DBA commands…

asrblogger August 14, 2024No Comments

Oracle

Calculate the necessary disk space for an Oracle EXPORT backup !!

Size of the Data: Determine the size of the database objects you intend to export. This includes tables, indexes, and other database structures. Compression: Decide whether you'll use compression during…

asrblogger August 14, 2024No Comments

Oracle

How To export a table with specific columns in Oracle !!

Hey Folks !! Today I have received a client requirement regarding exporting few columns from a table in Oracle 19c. Here are three methods you can use to achieve this:1.…

asrblogger August 10, 2024No Comments

Oracle

Create Service Request (SR) in My Oracle Support (MOS) !!

Hey Folks !! Today I will guide you towards the process of raising Oracle SR via metalink website or also known as My Oracle Support. There are several reasons why…

asrblogger August 3, 2024No Comments

Oracle

PostgreSQL Interview Question !!

Hey Folks, The objective of this blog post is to guide you through out the questionnaire that is being asked now a day from interviewer regrading Postgres Database. Below are…

asrblogger July 20, 2024No Comments

ASM Core DBA Oracle

ORA-1654: unable to extend index in tablespace

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 128 in tablespace TBS_012024-03-23T16:26:19.194628+05:30 Find the status of tablespace details…

asrblogger July 9, 2024No Comments

Core DBA DataGuard Oracle

Command to Check Archivelog Size

Oracle databases maintain a detailed history of all changes made to the database through archived redo logs, commonly known as archivelogs. These archivelogs are crucial for data recovery and are…

asrblogger July 9, 2024No Comments

DataGuard Oracle

Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set (DataGuard Broker Configuration)

The ORA-16698 error in Oracle indicates that a Data Guard member has a LOG_ARCHIVE_DEST_n parameter with the SERVICE attribute set, which is causing a conflict or an incorrect configuration in…

asrblogger June 22, 2024No Comments

Cassandra Cloud Oracle

Deploy CNPG Postgres on Kubernetes Cluster !!

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 Entry in /etc/hosts: 192.168.115.190 master.localdomain 192.168.115.195 worker1.localdomain 192.168.115.196 worker2.localdomain 192.168.115.197…