Posted by Mir Sayeed Hassan on April 25th, 2026
Oracle RMAN Configuration for Optimizing Backup and Recovery using the RMAN Utility.
Overview:
The RMAN configuration parameters are set to default rules for performing the backup and recovery in Oracle databases using CONFIGURE commands and they control retention, backup type, device usage, and automation. therefore this settings are ensure consistent...
Read more..
Posted in RMAN | Comments Off on Oracle RMAN Configuration for Optimizing Backup and Recovery using the RMAN Utility.
Posted by Mir Sayeed Hassan on April 16th, 2026
Different Methodologies of Working with Data Pump scenarios in Oracle Database 19C
Oracle Data Pump is a high-performance utility for performing the database data. This dumpfile can be used to import the same data and structures into same database or another Oracle database environment for migration purpose, making it a key tool for backup, migration, and data...
Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on Different Methodologies of Working with Data Pump scenarios in Oracle Database 19C
Posted by Mir Sayeed Hassan on April 11th, 2026
Use Segment Advisor in Oracle Database for Space Management Optimization
Overview
Segment Advisor in Oracle Database helps identify and reclaim unused space in database segments such as tables and indexes. It provides recommendations like segment shrink and reorganization to optimize storage...
Read more..
Posted in DBA Administration | Comments Off on Use Segment Advisor in Oracle Database for Space Management Optimization
Posted by Mir Sayeed Hassan on April 9th, 2026
Essential ASMCMD and CRSCTL Commands as Key Expertise for Oracle DBAs
Overview:
ASMCMD is a command-line utility in Oracle Automatic Storage Management (ASM) used by Oracle DBAs to manage ASM disk groups and files. It provides a Linux-like interface to perform navigation, monitor storage, and execute file operations.
Posted in ASM | Comments Off on Essential ASMCMD and CRSCTL Commands as Key Expertise for Oracle DBAs
Posted by Mir Sayeed Hassan on April 5th, 2026
Oracle 19c Upgrade from 12c with Migration Planning and Execution in Real-time.
Overview
Upgrading from Oracle Database 12c to 19c is essential for improved performance, security, and long-term support. Oracle 19c, as the long-term release, provides enhanced stability, better resource management, and...
Read more..
Posted in UPGRADATION | Comments Off on Oracle 19c Upgrade from 12c with Migration Planning and Execution in Real-time
Posted by Mir Sayeed Hassan on March 28th, 2026
Oracle CREATE Commands Cheat Sheet for Database administrators as Best Practices.
CREATE USER: is used to define and manage user access within the Oracle database system.
CREATE USER mir IDENTIFIED BY mirdb;
or
CREATE USER mir IDENTIFIED...
Read more..
Posted in DBA Administration | Comments Off on Oracle CREATE Commands Cheat Sheet for Database administrators as Best Practices.
