Posts by Md Asif Hussain

How to Perform Password-Based Encrypted RMAN Tablespace Backup & Restore

  Overview  This blog explains how to secure an Oracle 19c tablespace using RMAN password-based encryption and demonstrates a complete backup, restore, and recovery cycle. It covers verifying tablespaces and datafiles, taking an encrypted RMAN backup…

Read More

Oracle 19c Table Shrink Space

Shrinking a table in an Oracle database is used to reclaim unused space and optimize storage. As data is inserted, updated, and deleted over time, tables can become fragmented and retain empty blocks, leading to wasted…

Read More

APEX 21.2 Installation in Oracle Linux 19C Database

Introduction:This document provides a step-by-step guide to installing Oracle APEX 21.2 on an Oracle 19c database running on Oracle Linux.It covers prerequisites, setup, and configuration for APEX, ORDS, Java, and…

Read More

Configuring Transparent Data Encryption (TDE) in Oracle 19c with WALLET_ROOT and FILE Keystore

IntroductionThis guide explains how to enable Transparent Data Encryption (TDE) in Oracle 19c.TDE protects sensitive data at rest by encrypting it automatically.We will set up the wallet, create the master…

Read More