WAL Internals in PostgreSQL Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events or changes and WAL data is just a description of changes… Read More
Data Fragmentation in PostgreSQL PostgreSQL is a relational database management system with a client-server architecture. At the server-side, PostgreSQL’s processes and shared memory work together and build an instance, which handles the access to the data. Client programs connect to the instance and request read… Read More
Ask Doubts & Learn! (Oracle Snapshot Standby Database) In the below article, you can find all questions and answers regarding our upcoming session Oracle Snapshot Standby Database on (🕘28th Nov 2021 09:00 PM IST / 07:30 AM PST). Note: New Q&A will be updated… Read More
OGG-08223 Error when registering Extract for a container database. Hi Experts. In this article, we will see the OGG-08223 Error when registering Extract for a container database. I do have a plans to setup replication between the pluggable database in different containers. When registering… Read More
Replication to GCP PostgreSQL Using Oracle GoldenGate Use Case: Real-time replication of transactional data from an on-premises database to GCP Managed PostgreSQL instance using GoldenGate. Architecture: Source Database (Source Database can be any GoldenGate supported databases) Oracle GoldenGate (OGG) 19c/18c/12c for extraction from Source DB… Read More
Hi Readers, In this article, we will see the Oracle : Shell script for Crontab Monitoring alert THIS SCRIPT WILL IDENTIFY changes with the crontab file made comparing with original file. [oracle@nposqa1 ~]$ cat /home/oracle/DBA/bin/crontab_compare.bash #!/bin/bash # set -x # Get the current crontab entries… Read More
RAC Important Commands (SecureCRT) Dear Readers, In this article, we will see the Oracle : Important Commands for RAC (SecureCRT) Menu Bar : RAC Button : VD_Location crsctl query css votedisk ## STATE File Universal Id File Name Disk group — —– —————– ——— ——— 1.… Read More
Adding new table to existing GoldenGate Replication In this article, we will add a new table in existing GG replication setup without downtime using filter (@GETENV (‘TRANSACTION’,’CSN’) > scn number); Source : GG11 Target : GG12 Source : Connect and Login to the ggsci [oracle@GG11… Read More
Oracle : Shell script for RMAN backup of Standby Database In this article, we wrote an automation job for Shell script for RMAN backup of Standby Database The below script will be initiating the RMAN backup on the standby database: RMAN Script : [oracle@tewnposqa1 scripts]$… Read More
There is no excerpt because this is a protected post.
CONFIGURING Object Storage & Archive Storage In this article we will learn about “CONFIGURING Object Storage & Archive Storage” Object Storage provides unlimited, high-performance, durable, and secure data storage. Data is uploaded as objects that are stored in buckets. It can store an unlimited amount… Read More
Autonomous Transaction Processing In this article, we will know about “ATP” Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet the demands of a variety of applications: mission-critical transaction processing, mixed transactions and analytics, IoT, JSON… Read More
HOW TO CONNECT AND ACCESS ATP DATABASE In this article, we will know “HOW TO CONNECT AND ACCESS ATP DATABASE” We can access ATP database through SQL developer for that we have to download wallet file of this particular database 1. Click on the ATP… Read More
Dear Readers, In this article, we will see the following Realtime Usecase. Realtime Usecase : My Client swiggy wants to administrate theri technical Engineers as follows. They have team such as Developers,Database Admins,Linux Admins and storage admins.All the team should be in two levles L1… Read More
Hi Dears, In this article, we will see Install Oracle VM Virtual Box On Windows. Oracle VirtualBox Oracle VM VirtualBox is a free, open-source, cross-platform application for creating, managing and running virtual machines (VMs). Virtual machines are computers whose hardware components are emulated by the… Read More
How to drop a two-node Oracle RAC database database manually. In this article, we wrote an Clear steps for dropping a two node oracle database with Pre-requisite steps. Server: sewnpossqa01/02 Database : npossqa1 DB Unique name: sewnpossqa1 Step 1: Take consistent export of NPOSSQA1 database… Read More
Dear Readers, In this article, we will see the following Real-Time Use Case On Storage. Realtime Usecase : My Client, Nokia needs a Windows Server for Data Storage. So Launch a Server with three Additional Volumes. Volume capacities should be 10GB & 5GB. Duplicate the… Read More
Dear Readers, In this article, we wrote an automation job for Shell Script to gather stats for Stale tables. Note : 1) Please test the Shell script in Non-Prod before implementing it in Production. Script for gather stats for Stale tables #!/bin/bash function PreChks {… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Architecture. SNO Article Name Article Link 1 Startup and Shutdown modes in Oracle https://www.ktexperts.com/startup-and-shutdown-modes-in-oracle/ 2 ORACLE ARCHITECTURE -4(PHYSICAL REPRESENTATION OF DATABASE) https://www.ktexperts.com/oracle-architecture-4physical-representation-of-database/ 3 ORACLE OPTIONAL BACKGROUND PROCESSES https://www.ktexperts.com/oracle-optional-background-processes/ 4 ORACLE ARCHITECTURE -2… Read More
Dear Readers, Please check the below articles to get good knowledge on Oracle Partitioning. SNO Article Name Article Link 1 Partition https://www.ktexperts.com/partition/ 2 Oracle : Partitioning using online Redefinition method which requires minimal downtime https://www.ktexperts.com/oracle-partitioning-using-online-redefinition-method-which-requires-minimal-downtime/ 3 Oracle : High Level steps for Partitioning a non… Read More
