Author: Tarif Ahmad
-
Automatic Diagnostic Repository
The Automatic Diagnostic Repository (ADR) is a system-wide tracing and logging central repository for database diagnostic data. It includes the following items: Background trace files : Background trace files store information from database background processes. When a process detects an internal error, the process dumps information about the error to its trace file. Some of the information written to a…
//
-
Database corruption
Database corruption Database corruption in Oracle can occur due to various reasons, such as hardware failures, software bugs, or issues during database operations. It’s crucial to identify and address corruption promptly to ensure data integrity. Here are some steps you can take to deal with database corruption in Oracle: Physical corruption: This happens generally due to…
//
-
Cloning In Oracle
In the context of Oracle databases, “cloning” typically refers to the process of creating an exact replica of a database, usually for purposes such as testing, development, or disaster recovery. There are several methods for cloning an Oracle database, each with its own advantages and use cases. Here’s an overview of some common cloning methods…
//
-
Install MySQL 8 on Oracle Linux
Installing MySQL on Oracle Linux is simple and straightforward. Download the latest version of MySQL based on your OS version. Download via Command Line (optional): Use wget or curl to download the file directly if you prefer using the command line wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz Change to the directory where you downloaded the tarfile: cd /test Extract…
//
-
Mysql Replication
MySQL database servers (slave)- I/O thread and SQL Thread- Replication I/O threads- When a start slave statement is issued on a replica server, the replica creates an I/O thread, which connects to the source and asks it to send the updates recorded in its binary logs. The replication I/O thread reads the updates that the…
//
Search
Categories
- Azure (7)
- About Us (1)
- Azure SQL Database (6)
- My SQL (53)
- About Us (1)
- DBMS Concepts (20)
- Handbook (1)
- MySQL Architecture (19)
- MySQL Basics (29)
- MySQL L1 (14)
- Oracle (34)
- PostgreSQL (37)
- About Us (1)
- DBMS Concepts (21)
- PG Hand Book (1)
- pg_ High Availability (4)
- pg_Backup (4)
- pg_basic (11)
- SQL Server (132)
- About Us (1)
- Azure SQL Database (4)
- Backup and Recovery (17)
- Backup Tools for SQL Server (3)
- DBA Worries Continued (27)
- DBMS Concepts (28)
- High Availability (12)
- Installation and Configuration (23)
- L1 DBA (59)
- Monitoring (17)
- Performance Tuning (29)
- Power Shell Script (6)
- Security (12)
- SQL DBA Hand Book (2)
- SQL Scripting (16)
- SQL Server Reporting Services (2)
- Uncategorized (3)