My Blog
Documenting database internals, backend engineering, and technical problems I solve day-to-day. What took me hours to figure out should take you minutes.
Oracle RAC Cold Backup Using RMAN — Step by Step
A complete walkthrough of taking a cold backup on an Oracle RAC cluster using RMAN — covering shutdown, mount, compressed backup, controlfile, SPFILE, and pfile creation.
Oracle DBA Scripts Collection — Standby, Archive Sync, Space & Performance
A practical reference of Oracle DBA shell scripts and SQL queries covering standby database build automation, archive log sync check, space monitoring, RMAN progress, and everyday DBA tasks.
MySQL / MariaDB Database Migration — Step-by-Step Guide
End-to-end procedure for migrating a MySQL/MariaDB database between environments using mysqldump — covering export, user grants, import, and post-migration verification.
Step by step to create oracle database 19c using dbca – silent mode
create non-container database on oracle 19c in silent mode using dbca Contents:- 1.Overview2.set the environment3.Create database using silent mode using dbca4.verify 1.Overview Creating 19c database using silent mode DB Version : 19.3.0.0 OS Version : OEL 8.8 2.Set the environment Create a bash profile Verify environments: 3.Create database using silent mode 4.Verification: Listener and Continue reading Step by step to create oracle database 19c using dbca silent mode
Step by Step Install Oracle 19c Release 3 on Linux 8.8
Pre-requisites already been taken care like memory, swap, kernel parameters, add groups, profile and users Table of Contents 1.Hardware Requirements 2.Download DB Software https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html 3.Transfer to linux and unzip [oracle@localhost dbhome_1]$ pwd /u01/app/oracle/product/19.0.0/dbhome_1 [oracle@localhost dbhome_1]$ ls -ltr -rwxrwxr-x. 1 oracle oinstall 3059705302 Oct 18 20:25 LINUX.X64_193000_db_home.zip [oracle@localhost dbhome_1]$ unzip LINUX.X64_193000_db_home.zip 4.Invoke ./runInstaller 6.Verify